Programmers/Testers developing DP4 applications are strongly encouraged to run this utility as part of the process of testing their applications, as rounding errors in floating pointer numbers can cause problems (for example inaccurate totals).
Analyses the data in the tables in an application database, reporting on and optionally correcting any invalid data such as inexact floating point numbers, invalid dates or times etc. Unless you specify various command line options the program only checks floating point values for fields that are not keyfields anywhere.
| Command Tail | Description |
|---|---|
|
−ALL |
Turns on all checks (same as -null -keys -date) |
|
−DATE |
Also check date and time fields |
|
−KEYS |
Also check type N fields that are keyfields. Combining -keys and -post options can cause duplicate records to be created, as ROUNDER does not attempt to delete any data. |
|
−NULL |
Also check that character fields using a 0 as their first character, contain all character 0, and for character fields that are not keyfields ensure any characters after a character 0 are all 0. |
|
−PAD |
Also checks that all padding bytes are set to zero |
|
−PAD |
Also checks that all padding bytes are set to zero |
|
−POST |
Report on and correct errors |
|
−REPORT |
Report on errors but do not correct them |