SHOW | Example | Teradata FastLoad - 17.10 - Example: SHOW - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

When the following DEFINE command is active:

DEFINE EmpNo (smallint),
Name (varchar(12)),
DeptNo (decimal (3,0)),
JobTitle (varchar(12)),
Salary (decimal(8,2)),
YrsExp (byteint),
DOB (date),
Sex (char(1)),
Race (char(1)),
MStat (char(1)),
EdLev (byteint),
HCap (byteint)
FILE=EmpData ; 

The Teradata FastLoad response to the SHOW command is:

FILE = EmpData
EMPNO        OFFSET=   0   LEN =  2   SMALLINT
NAME         OFFSET =  2   LEN =  12  VARCHAR
DEPTNO       OFFSET=  16   LEN =  2   DECIMAL
JOBTITLE     OFFSET=  18   LEN =  12  VARCHAR
SALARY       OFFSET=  32   LEN =  4   DECIMAL
YRSEXP       OFFSET=  36   LEN =  1   BYTEINT
DOB          OFFSET=  37   LEN =  4   DATE
SEX          OFFSET=  41   LEN =  1   CHAR
RACE         OFFSET=  42   LEN =  1   CHAR
MSTAT        OFFSET=  43   LEN =  1   CHAR
EDLEV        OFFSET=  44   LEN =  1   BYTEINT
HCAP         OFFSET=  45   LEN =  1   BYTEINT
TOTAL RECORD LENGTH=  46