Record (In Record Mode)
Purpose
In Record Mode, nulls are not explicitly identified in the Record parcel, when Return‑statement‑info 'Y' was not specified.
Usage Notes
Note that a Teradata SQL SHOW TABLE statement returns only one Record parcel.
Within the Record parcel, each line of a table is separated from the next by hex 0D (decimal 13).
This parcel is generated by the Teradata Database.
Parcel Data
The following information applies to the Record parcel (in Record Mode).
Flavor |
Parcel Body Length |
Parcel Body Fields |
10 |
1 to maximum body size |
Data: organized as: item 1, item2, . . . , item i, . . . , item n |
If in Record Mode, the Record parcel for an ECHO statement does NOT contain zeros.
Field Notes
The Data Field contains items with characteristics as follows:
One method for obtaining the resulting data type of an expression is to use the HELP COLUMN statement on that expression.
For details, see the description of the HELP COLUMN statement in the SQL Data Definition Language (B035‑1144).
An alternate method for obtaining the resulting data type of an expression is to consult the data type conversion rules.
The rules begin with the data type of the elementary operands (columns in CREATE TABLE statements, variables in USING row descriptors, constants in expressions, and built‑in values in expressions).
The rules then account for the effects of operations on the elementary operands (explicit data type conversion in description phrases of expressions, arithmetic operations in expressions, character operations in expressions, and functions and aggregate operations in expressions).
For details, see SQL Data Types and Literals (B035‑1143) and SQL Functions, Operators, Expressions, and Predicates (B035‑1145) for pointers to the rules.
The contents of each item are in client internal format as determined by the resulting data type of the expression. See Table 64 on page 438.
For the form that a null value takes in each of these data types, see “Manipulating Nulls” in SQL Fundamentals (B035‑1141).