PRINT command

The PRINT command prints a copy of an object that is in the current window (temporary storage) or stored in a database.

Syntax

Note: This command is not supported in QMF for WebSphere®.

To print a copy of an object that resides on a database:

>>-- PRINT ----------- ObjectName ---------------------------------------<<
                                      ( +- PRINTER = Printer -----------+
                                        +- LEFTMARGIN = integer --------+
                                        +- RIGHTMARGIN = integer -------+
                                        +- TOPMARGIN = integer ---------+
                                        +- BOTTOMMARGIN = integer ------+
                                        +- COPIES = NumCopies-----------+
                                        +- WIDTH = NumChars/CONT/AUTO --+
                                        +- HEIGHT = NumChars/CONT/AUTO -+
>>-- PRINT ----------- ObjectName ---------------------------------------<<
           +- QUERY -+                ( +- PRINTER = Printer -----------+
           +- PROC  -+                  +- LEFTMARGIN = integer --------+
           +- TABLE -+                  +- RIGHTMARGIN = integer -------+
                                        +- TOPMARGIN = integer ---------+
                                        +- BOTTOMMARGIN = integer ------+                        
>>-- PRINT ----- ANALYTICS --- ObjectName ---------------------------<<
                                  ( +- WIDTH = NumChars/CONT/AUTO -+
                                    +- HEIGHT = NumChars/CONT/AUTO -+
                                    +- PRINTER = Printer ----------+
>>-- PRINT FORM --- ObjectName------------------------------------------<<
                ( +- DATETIME = YES/NO --------------------------------+
                  +- PAGENO = YES/NO ----------------------------------+
                  +- PRINTER = Printer --------------------------------+
                  +- LENGTH = NumLines/CONT/AUTO ----------------------+
                  +- WIDTH = NumChars/CONT/AUTO -----------------------+
                  +- LEFTMARGIN = integer -----------------------------+
                  +- RIGHTMARGIN = integer ----------------------------+
                  +- TOPMARGIN = integer ------------------------------+
                  +- BOTTOMMARGIN = integer ---------------------------+

To print a copy of the current object in an open window (temporary storage):

>>-- PRINT ---------- QUERY -----------------------------------<<
           +- PROC -+         ( +- PRINTER = Printer ------+
           +- TABLE -+          +- LEFTMARGIN = integer ---+
                                +- RIGHTMARGIN = integer --+
                                +- TOPMARGIN = integer ----+
                                +- BOTTOMMARGIN = integer -+

>>-- PRINT REPORT -------------------------------------------------------<<
                  ( +- DATETIME = YES/NO --------------------------------+
                    +- PAGENO = YES/NO ----------------------------------+
                    +- PRINTER = Printer --------------------------------+
                    +- COPIES = NumCopies--------------------------------+
                    +- TYPEFACE = fontname ------------------------------+
                    +- SIZE = FontSize ----------------------------------+
                    +- BOLD = YES/NO ------------------------------------+
                    +- ITALIC = YES/NO ----------------------------------+
                    +- CHARSET = ANSI/DEFAULTS/SYMBOL/SHIFTJIIS/GB2312/ -+
                                 HANGUEL/CHINESEBIG5/OEM/JOHAB/HEBREW/ --+
                                 ARABIC/GREEK/TURKISH/THAI/EASTEUROPE/ --+
                                 RUSSIAN/MAC/BALTIC ---------------------+
                    +- ORIENTATION = PORTRAIT/LANDSCAPE -----------------+
                    +- USEFORMPS = YES/NO -------------------------------+
                    +- LENGTH = NumLines/CONT/AUTO ----------------------+
                    +- WIDTH = NumChars/CONT/AUTO -----------------------+
                    +- LEFTMARGIN = integer -------------+
                    +- RIGHTMARGIN = integer ------------+
                    +- TOPMARGIN = integer --------------+
                    +- BOTTOMMARGIN = integer -----------+ 
>>-- PRINT FORM -------------------------------------------------------<<
                ( +- DATETIME = YES/NO --------------------------------+
                  +- PAGENO = YES/NO ----------------------------------+
                  +- PRINTER = Printer --------------------------------+
                  +- LENGTH = NumLines/CONT/AUTO ----------------------+
                  +- WIDTH = NumChars/CONT/AUTO -----------------------+
                  +- LEFTMARGIN = integer -----------------------------+
                  +- RIGHTMARGIN = integer ----------------------------+
                  +- TOPMARGIN = integer ------------------------------+
                  +- BOTTOMMARGIN = integer ---------------------------+
Parameter Description
ObjectName The name of the object to print.
Note: For Cloudant queries, specify the full object key.
DATETIME Specifies whether or not to include the current date and time in the page footer. When you print a report, the date and time are printed in the page footer unless you specify DATETIME=NO or include the &DATE or &TIME variables in the page text in the form. If included, the date and time are formatted according to the current Windows regional settings.
PAGENO Specifies whether or not to include page numbers in the page footer. When you print a report, page numbers are printed in the page footer unless you specify PAGENO=NO or include the &PAGE variable in the page text in the form.
PRINTER Specifies the name of the printer on which to print the object or report.
Tip: You can get the name of the printer from the General tab of the Print window. Put the name of your printer in double quotation marks if you want to specify it as the value of the PRINTER parameter. For example, PRINTER="My_Printer"
TYPEFACE Specifies the font typeface to use when printing the object.
COPIES Specifies the number of copies to print when printing the object.
SIZE Specifies the font size to use when printing the object.
BOLD Specifies to use bold text when printing the object.
ITALIC Specifies to use italic text when printing the object.
CHARSET Specifies the character set to use when printing the object.
ORIENTATION Specifies the paper orientation of the printed object.
USEFORMPS Specifies whether or not to use the Windows form associated with the object.
LENGTH Specifies the maximum number of lines to print on each page (from 1 to 999), CONT (to cause continuous printing without page breaks), or AUTO. If LENGTH is omitted, the values of the DSQQW_RPT_LEN_TYP and DSQQW_RPT_NUM_LNS global variables are used.
WIDTH
  • Specifies the maximum number of characters to print on each line (from 1 to 999), CONT (to cause continuous printing without page breaks), or AUTO. When you print a report, lines longer than WIDTH are formatted on a subsequent page.
  • For Analytics object: Specifies the width of a printed page. The unit of width is one single-byte character.
HEIGHT For Analytics object: Specifies the height of a printed page. The unit of height is one single-byte character.
LEFTMARGIN Specifies the value that will be used for the left margin. Units of measurement are based on inches.
RIGHTMARGIN Specifies the value that will be used for the right margin. Units of measurement are based on inches.
TOPMARGIN Specifies the value that will be used for the top margin. Units of measurement are based on inches.
BOTTOMMARGIN Specifies the value that will be used for the bottom margin. Units of measurement are based on inches.

Example

The following examples print a copy of the current objects in an open window. If you want to print an object from the database, specify its name in the procedure.
PRINT QUERY
PRINT REPORT (LENGTH=60, DATETIME=NO
The following example prints a Cloudant query that is stored in a repository:
PRINT rsbi:/.workspaces/Default/Cloudant_query