15.00 - Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

Usage Notes

When a result is filed, a client flat file that contains selected records is established. The records are stored in record mode, that is, in client computer format.

Before logging on to ITEQ, the user may associate names with these files using TSO ATTRIBUTE/ALLOCATE commands or the CMS FILEDEF command. The logical record limit of each flat file is 32,760 bytes.

Files must be able to accept variable-length records. If members changed data set to file of a partitioned file are used, file names must be fully qualified.

When a character constant is retrieved from a client file, the character constant is treated as a variable-length string, which appends the constant with a two byte field. To select a fixed‑length character constant, a user may include a character data type phrase in the SELECT statement. For example, the character data type phrase in the following SELECT statement causes the character constant ‘First’ to be returned as a fixed-length string:

SELECT ..., First CHAR(5) FROM expr [expr... ,expr];

See Database Administration for additional information on data attributes.