Print Table Data or Audit Trail function

This section describes how to use Option 5, Print Table Data or Audit Trail. It explains how you can use selection criteria to select the table data to be printed. This allows you to tailor your reports to your specific needs and have them printed in either table or row mode. Sample reports appear in Example Row Mode Table Data Print to Dataset and Example Table Mode Table Data Print to Database.

This chapter also describes how an audit trail report is printed in File-AID for Db2. An audit trail report contains a record of all successful modifications (inserts, deletes, updates, commits and rollbacks) to Db2 table data during a File-AID for Db2 edit session. A sample report appears in Example Audit Trail Report. For information on producing an audit trail dataset, see Creating-an-Audit-Trail-Dataset.

Printing Unicode Data

The Print function supports printing of Unicode table data. File-AID for Db2 retrieves the native Unicode data from Db2 and then, internally calls the IBM z/OS Conversion Services program, CUNLCNV, to convert data from Unicode to CCSID EBCDIC-based data. The EBCDIC CCSID is a parameter in the Batch Print JCL, and it comes from terminal CCSID when the JCL is generated. The Configuration default variable, CCSID, is used as default, if the EBCDIC CCSID is not specified in the Print parameters. If the converted EBCDIC data exceeds the original Unicode data length, File-AID for Db2 prints “>>>>>>” characters to indicate where the EBCDIC data exceeds the Unicode data length.

For variable column data, the print data area for the column is the longest size of the actual data in the print target rows. It is not the defined column length.

EBCDIC Tables With UNICODE Columns

Db2 Version 11 EBCDIC tables with individually defined UNICODE columns are supported in Print. UNICODE columns in EBCDIC tables display like UNICODE columns in UNICODE tables.

This section provides information about the following topics: