Printing the contents of a Db2® table

To print the contents of a Db2® table or view, use the Print utility function (3.1).

When you print data, you can:
  • Select which rows to print.
  • Select which columns to print and the order in which they are arranged on the listing.
  • Print Db2® tables or views with columns formatted according to column data type.
  • Provide customized column headings.
  • Limit the number of rows printed:
    Limit the print
    You can limit the number of rows that are printed by specifying the number of rows to print.

    To print all the rows of the Db2® object, specify 0 (zero) or ALL.

    Select rows
    You can select the rows you want to print by specifying row selection criteria.

To display the Print Utility panel,

  1. From the Primary Option Menu panel, enter 3 (Utilities) to display the Utility Functions panel.
  2. From the Utility Functions panel, enter 1 (Print)

Now that you have the Print Utility panel displayed, you can specify the name of the Db2® table or view you want to print, how many rows you want to print, and other options to control how the data is printed.

When you have finished specifying these details, press Enter.

If you selected Edit options (either by using a “/”, or by having previously used the A selection character for this option), before printing the data, the Print Utility Options panel is displayed.

If you selected Edit template (either by using a “/”, or by having previously used the A selection character for this option), before printing the data, the Column Selection/Edit panel is displayed.

If you selected Batch execution (either by using a “/”, or by having previously used the A selection character for this option), the generated JCL is displayed using the ISPF editor, where you can review the JCL and submit the job for batch processing.

Otherwise (if you selected none of the preceding options), FM/Db2 prints the data.