SHOW - FastLoad

Purpose  

The SHOW command displays active definitions for the input data source or INMOD routine and the field names that were established by one or more DEFINE commands.

Syntax  

Usage Notes

The SHOW command displays:

Field names

Data type (integer or character) of each field

Internal length of each field

Offset of each field within the input record

Input data source or INMOD routine names

If a DEFINE command has not been entered, the result is blank and Teradata FastLoad responds with this message:

TOTAL RECORD LENGTH = 0

Note: The SHOW command is processed by Teradata FastLoad. It is not transmitted to the Teradata Database.

Example  

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