Direct Access – DETAIL

The following table describes the columns in the Load Data Store Information from External Interface sequential file for DB2 databases using direct access for DETAIL:

Note: This is produced as the byproduct of performing the Load Sequential File with DB2 Catalog job.
Column Type Length Decimal Domain
FILETYPE CHARACTER 001-004 4 DB2F
Separator CHARACTER 005-005 1 must be blank
FLDDISPL INTEGER 006-010 5 field displacement (mandatory field)
Separator CHARACTER 011-011 1 must be blank
FLDNAME CHARACTER 012-041 30 field name ( mandatory field)
Separator CHARACTER 042-042 1 must be blank
FLDLEN INTEGER 043-047 5 field length ( mandatory field)
Separator CHARACTER 048-048 1 must be blank
FLDINT INTEGER 049-051 3 field integer ( mandatory field)
Separator CHARACTER 052-052 1 must be blank
FLDDEC INTEGER 053-055 3 field decimal ( mandatory field)
Separator CHARACTER 056-056 1 must be blank
FLDTYPE CHARACTER 057-057 1 field type ( mandatory field)
Separator CHARACTER 058-058 1 must be blank
CLATYPE INTEGER 059-062 4 field class
Separator CHARACTER 063-063 1 must be blank
NULLCAP CHARACTER 064-064 1 null capable field ( mandatory field). Blank = N
Separator CHARACTER 065-065 1 must be blank
VARLEN CHARACTER 066-066 1 field with variable length
Separator CHARACTER 067-067 1 must be blank
FLDTXT CHARACTER 068-117 50 text