2.215 STATOPTIONS
Valid for
Extract, Replicat
Description
Use STATOPTIONS
to report zero counts for insert, update, and delete operations. For Replicat also use STATOPTIONS
to report on the time spent creating a file, purging a file, or ending a transaction.
Default
ZEROSUPPRESS
, no reporting on Replicat timings
Syntax
STATOPTIONS [ZEROSUPPRESS | NOZEROSUPPRESS}[, PROGSTATS]
Examples
- Example 1
-
Sample results for
STATOPTIONS
NOZERSUPPRESS
:Total # records written to RFUNLDS 349 \NY015.$DATA06.QABASE.BRANCH # inserts: 100 # updates: 0 # deletes: 0 \NY015.$DATA07.LQASRC.HISTORY # inserts: 249 # updates: 0 # deletes: 0
- Example 2
-
Sample results for
STATOPTIONS
ZEROSUPPRESS
:Total # records written to RFUNLDS 349 \NY015.$DATA06.QABASE.BRANCH # inserts: 100 \NY015.$DATA07.LQASRC.HISTORY # inserts: 249
- Example 3
-
Sample results for
STATOPTIONS
PROGSTATS
:EndTransaction 7 elapsed 00:00:00.079211 PerOp 0 FileCreate 1 elapsed 00:00:00.021796 PerOp 0 FilePurge 3 elapsed 00:00:00.011630 PerOp 0