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:
| 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 |