Filing a Result for Later Use - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2452
lifecycle
previous
Product Category
Teradata Tools and Utilities

Filing a Result for Later Use

Before entering a subsequent query, you may execute the command:

FILE;

to store the spooled result of the current SELECT statement or macro. When control is returned to the interactive system, this file is stored in a client flat file that is allocated to a system file with the name ITEQDSK1 (under TSO) or to a system file with the name ITEQDSK1 DATA (under CMS). The file is created in TEXT form so that it may be used later by an application program.

The maximum logical record length for a result file is 32,000 bytes.