return to PRS Technologies website
<![CDATA[
################################################################################
Instructions on running checktab.4ge from the command line:
nohup checktab.4ge [tablename] [B] [C] [D] [E] [F] [G begin] [G end] > [filename] &
(use A-G above and below as a reference):
where:
B. Enter a 'WHERE' condition (optional). This should be a valid SQL statement.
C. The default Sampling Number is "1". This means it will check every record.
If this is being used after a Conversion and you just want to "spot check" the table,
you can enter a "10" here (for example) to just check every tenth record.
D. Enter the Checking Level:
Level 1 will make one pass through the table and check for NULLS, valid dates, etc.
Level 2 will also check joins to make sure the joined tables have valid data.
Level 3 is for more complex checks and is currently only used with the ledger table.
E. Enter output file name. The default is "[tablename].out".
F. Enter Maximum number of errors to print per error type.
The default is 1000. To conserve disk space you may want to change this to 100.
G. Enter your date range in the "Earliest valid date: Latest valid date: " fields.
################################################################################
]]>