The following table describes the columns in the Load Data Store Information from External Interface sequential file for ADABAS Data Store for DETAIL:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| FILETYPE2 | CHARACTER | 001-004 | 4 | ADAF |
| 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 |
| CPYLIB | CHARACTER | 059-102 | 44 | tablespace number (mandatory field) |
| Separator | CHARACTER | 103-103 | 1 | must be blank |
| CPYNAME | CHARACTER | 104-113 | 10 | database number (mandatory field) |
| Separator | CHARACTER | 114-114 | 1 | must be blank |
| IOAREANAME | CHARACTER | 115-144 | 30 | I/O area name (mandatory field) |
| Separator | CHARACTER | 145-145 | 1 | must be blank |
| FLDLEVEL | CHARACTER | 146-147 | 2 | level of field (mandatory field) |
| Separator | CHARACTER | 148-148 | 1 | must be blank |
| IOAREANBR | INTEGER | 149-153 | 5 | I/O area nunmber (mandatory field) |
| Separator | CHARACTER | 154-154 | 1 | must be blank |
| FLDNBR | INTEGER | 155-159 | 5 | field number (mandatory field) |
| Separator | CHARACTER | 160-160 | 1 | must be blank |
| FLDSIGN | CHARACTER | 161-161 | 1 | field sign(mandatory field) |
| Separator | CHARACTER | 162-162 | 1 | must be blank |
| FLDOCC | INTEGER | 163-167 | 5 | field OCCURS (mandatory field) |
| Separator | CHARACTER | 168-168 | 1 | must be blank |
| FLDOCCTOT | INTEGER | 169-173 | 5 | field OCCURS elements (mandatory field) |
| Separator | CHARACTER | 174-174 | 1 | must be blank |
| FLDOCCLVL | INTEGER | 175-177 | 3 | OCCURS Level (mandatory field) |
| Separator | CHARACTER | 178-178 | 1 | must be blank |
| FLDOCCPRG | INTEGER | 179-183 | 5 | OCCURS progressive (mandatory field) |
| Separator | CHARACTER | 184-184 | 1 | must be blank |
| FLDGROUP | CHARACTER | 185-185 | 1 | group field (mandatory field) |
| Separator | CHARACTER | 186-186 | 1 | must be blank |
| STMTNBR | INTEGER | 187-193 | 7 | statement number (mandatory field) |
| Separator | CHARACTER | 194-194 | 1 | must be blank |
| FLAGFLD | CHARACTER | 195-195 | 1 | flag for TAB. ANURDFLF (mandatory field) |
| Separator | CHARACTER | 196-196 | 1 | must be blank |
| FLDRECID | INTEGER | 197-205 | 9 | field ID (mandatory field) |
| Separator | CHARACTER | 206-206 | 1 | must be blank |
| FLDNAT | CHARACTER | 207-207 | 1 | field nature (mandatory field) |