Where Does Your Output Go? - 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

Where Does Your Output Go?

If you do not define output files, they are set by default, as follows:

  • When you issue the ITEQ FILE command during an ITEQ session to save the result of the current SELECT or EXECUTE MACRO statement, a client flat file is created with a logical record length of 30004 bytes. Under TSO, a file with ddname ITEQDSK1 is created to store the result; under CMS, a file named ITEQDSK1 is created.
  • When you issue the ITEQ PRINT command during an ITEQ session to print a result, a file (ddname (TSO) of ITEQPRT1 or file name (CMS) of ITEQPRT1 DATA) containing the result of the current statement is sent to a printer. System output class (wide paper or narrow paper) is determined by your organization’s installation.
  • If you are using the Teradata DBS through ITEQ, after logging on to the interactive subsystem you can define ddnames (TSO) or file names (CMS) for output files that you need for your ITEQ session. These files may be saved for later use by an application program or printed on a system printer. Defining output files is described in Appendix D.