When you enable database query logging, DBQL automatically counts how many rows are updated, inserted, and deleted in a request and logs the counts in DBC.DBQLogTbl. DBQL also counts how many rows are updated, inserted, and deleted in SQL procedures, external stored procedures, Teradata Parallel Transporter, MultiLoad, and FastLoad. The StmtDMLRowCount field in DBC.QryLogV and DBC.QryLogV_sz shows the counts in JSON format. You can use JSON functions to extract data from the views.
Benefits
Tracking the amount of data manipulated for each DML request may be useful for decision-making.
Considerations
If you begin query logging using the LIMIT SUMMARY option, DBQL does not store the DML row count in DBC.DBQLogTbl.
Additional Information
For more information, see Teradata Vantage™ Data Dictionary, B035-1092.