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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

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