Print Utility Options panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                        
 FM/Db2 (DFE2)               Print Utility Options

 Processing Options:                   Null Column Indicator:
    Print mode                            Display . . . . . .  
    1  1. Table
       2. Single

    Enter "/" to select option
    /  Batch execution
    /  Use uncommitted read
       Print HEX representation








 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Print Mode

The format of the print output. The default is 1 (Table):

1. Table

In Table print mode (the default mode), the rows of the table are formatted into columns and printed horizontally across the page. Each column has a heading of either the column name or a heading specified by you. Multiple rows are printed on each page. Each column of the table is formatted according to the data type for that column. For example, numeric data types are printed as whole or decimal numbers, and date and time columns are printed as dates or times. Print data might be truncated, depending on the LRECL of the print data set.

2. Single

In Single mode, only one column of the table is printed on each line of the page. The columns of the table are arranged vertically on the page, with the column header on the left of the page, and the data for that column on the right. Each column of the table is formatted according to the data type for that column. For example, numeric data types are printed as whole or decimal numbers, and date and time columns are printed as dates or times.

Display

Null Column Display Indicator. This option, applying to columns that allow Db2® nulls only, allows you to specify a character to represent the Db2® null value for the FM/Db2 print utility. The default is the underscore character.

Batch execution

Builds the necessary JCL to perform the Print function in a batch job. The generated JCL is displayed using the ISPF editor, where you can review the JCL and submit the job for batch processing. The default is selected, that is, the print is executed in batch.

Use uncommitted read

Enables data to be read that has not yet been committed. The default setting is selected; that is, FM/Db2 uses uncommitted read when retrieving the data from Db2®.

Note: If FM/Db2 attempts to retrieve data that has a write lock, an SQL error might result.

Print HEX representation

Prints the hexadecimal representation of the data. The default is not selected; that is, the data is not printed in hexadecimal format.