The DATAEXTRACT statement is not executed when LOAD detects that significant digits could be lost during the output of numerical values because the output fields are not wide enough.
Nevertheless, should an overflow occur (e.g., in case of output made in INTEGER format), then asterisks (*) are output instead and the extract run is aborted.
During the extraction, a counter keeps track of the number of rows written.
After a certain number of rows has been output (depending on the lengths of the result rows), LOAD displays the current counter reading:
Rows written : 40
Once the result table has been completely processed, the final counter reading is written into the protocol file and displayed:
Rows written : 5241