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