Defining a Print Output File - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Product
Interactive Teradata Query Facility
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2452
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
    return

    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
    return

    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).