DB2 graphic QMF Version 8

PRINT command

The PRINT command prints a copy of an object in temporary storage or from the database.

Syntax

For a target object from the database:

>>-- PRINT ------------- ObjectName -------------------------------------<<
            +- QUERY -+              +- PRINTER = Printer -+
            +- PROC --+
            +- TABLE -+

For a temporary target object:

>-- PRINT --- QUERY ------------------------------------------------------<<
            +- PROC --+ +- PRINTER = Printer -+
            +- TABLE -+


>>-- PRINT REPORT -------------------------------------------------------<<

>------------------------------------------------------------------------<<
  +- ( --- DATETIME = YES/NO ----------+
        +- PAGENO = YES/NO ------------+
        +- PRINTER = Printer ----------+
        +- FORM = --- FORM ------------+
                   +- FormName --------+
        +- COPIES = NumChars ----------+
        +- TYPEFACE = Fontname --------+
        +- SIZE = NumChars ------------+
        +- 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 = NumChars/CONT/AUTO -+
                     +- CONT -----------+
        +- WIDTH = NumChars/CONT/AUTO --+

Parameters

Table 43. PRINT Command Parameters
Parameter Description
ObjectName The name of the object to print.
DATETIME Specifies whether or not to include the current date and time in the page footing. When you print a report, the date and time are printed in the page footing 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 footing. When you print a report, page numbers are printed in the page footing 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.
FORM Specifies which form to use when generating the report. You can specify the keyword FORM to use the current form object, or specify the name of a form saved in the database.
COPIES Specifies the number of copies to print when printing the object.
TYPEFACE Specifies the font typeface to use when printing the object.
SIZE Specifies the font size to use when printing the object.
BOLD Specifies whether or not to use bold text when printing the object.
ITALIC Specifies whether or not 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 LENGTH of the printed object, which is one of the following:
  • The maximum number of lines to print on each page (from 1 to 999)
  • CONT (to cause continuous printing without page breaks)
  • AUTO
If LENGTH is omitted, the values of the DSQQW_RPT_LEN_TYP and DSQQW_RPT_NUM_LINES global variables are used.
WIDTH Specifies the WIDTH of the printed object, which is one of the following:
  • The maximum number of characters to print on each line (from 1 to 999)
  • CONT (to cause continuous printing without page breaks)
  • AUTO
When you print a report, lines longer than WIDTH are formatted on a subsequent page.

Example

PRINT QUERY

PRINT REPORT (LENGTH=60, DATETIME=NO


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004