Home » Categories » Solutions by Business Process » Profiler

B – Blank out a Database

Datafile Software

B – Blank out a Database

This option removes all records from a database. You may wish to do this to clear a work file after the details have been processed / reported and are no longer required.

After creating the call for the clear down routine on the menu there are no further parameter settings required.

Note that this option allows the use of selection criteria at run-time but you can not predefine the criteria within the definition, also note that this option is not suitable for use in an automatic (Q) menu as it will pause to allow entry of criteria.If you wish to pre-define criteria or run the option automatically in a menu use the G-Global Update option for clearing records (see later).

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
O – Organise Pointers
Viewed 1179 times since Thu, Jun 28, 2012
Log ProFiler Actions
Viewed 2164 times since Wed, Jun 13, 2012
Exception Procedures - EDI Order Processing
Viewed 2071 times since Thu, Jul 5, 2012
User-Defined Reports - Update Excel Spreadsheet from Accumulators
Viewed 16057 times since Mon, Jun 11, 2012
P – Program
Viewed 1248 times since Fri, Jun 29, 2012
Report with Output Database Updating – Wait Record Locking for Update Database
Viewed 1378 times since Wed, Jun 13, 2012
Copy Items Back to Lookup File (9902)
Viewed 2312 times since Fri, Jun 29, 2012
Screen Options - Increment Code within ‘Location’
Viewed 2253 times since Fri, Oct 26, 2012
Delete a Menu
Viewed 2199 times since Thu, Jun 28, 2012
User Defined Reports - Email Links
Viewed 2187 times since Wed, Jun 13, 2012