ADABAS Data Store – DETAIL

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)