Defining a Print Output File - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Interactive Teradata Query Facility
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Before starting ITEQ from TSO or VM, or during your ITEQ session, you can define a print output file using the following commands:

  • Under TSO:
  • tso attrib printatt lrecl(85) recfm(v)
    tso allocate ddname(iteqprt2) sysout(b) using(printatt)
  • Under VM:
  • CMS;
    filedef iteqprt2 printer (recfm vba lrecl 85
    cp spool printer cont class b

    This sequence of commands:

  • Enters TSO or CMS
  • Defines the following file attributes:
  • A logical record length of 85 bytes for a print line width of 80 characters (one extra byte for the printer control character and four extra bytes for a record descriptor word for each record)
  • A variable record format
  • Assigns the file to output class B
  • After defining a print output file, during your ITEQ session you can send the current result to be printed on 8 1/2‑ by 11‑inch paper by executing the following ITEQ PRINT command:

    PRINT iteqprt2;

    A print output file is cleared and made available for printing when you log off TSO or CMS. To clear a print output file during your ITEQ session to make it immediately available for printing, execute:

  • Under TSO:
  • tso free iteqprt2
  • Under CMS:
  • CMS;
    filedef iteqprt2 clear
    cp spool printer nocont
    cp close print

    For complete information about the ITEQ PRINT command, refer to the Interactive Teradata Query Reference (B035-2451). For more information about the TSO Allocate, Free, and Output commands, refer to the OS/VS2 TSO Command Language Reference Manual (IBM).

    For more information about CMS and CP commands, refer to the VM/SP CMS Command and Macro Reference Manual and the VM/SP CP Command Reference Manual (IBM).