The following table describes the columns in the Load Data Store Information from External Interface sequential file for DB2 databases using direct access for HEADER:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| FILETYPE | CHARACTER | 001-004 | 4 | DB2D |
| Separator | CHARACTER | 005-005 | 1 | must be blank |
| FILNAME | CHARACTER | 006-133 | 128 | table name (mandatory field) |
| Separator | CHARACTER | 134-134 | 1 | must be blank |
| FILLIB | CHARACTER | 135-262 | 128 | table creator ( mandatory field) |
| Separator | CHARACTER | 263-263 | 1 | must be blank |
| APPLID | CHARACTER | 264-273 | 10 | application code |
| Separator | CHARACTER | 274-274 | 1 | must be blank |
| TSNAME | CHARACTER | 275-298 | 24 | tablespace name |
| Separator | CHARACTER | 299-299 | 1 | must be blank |
| DBNAME | CHARACTER | 300-323 | 24 | database name ( mandatory field) |
| Separator | CHARACTER | 324-324 | 1 | must be blank |
| OBID | INTEGER | 325-328 | 4 | OBID ( mandatory field) |
| Separator | CHARACTER | 329-329 | 1 | must be blank |
| FILTXT | CHARACTER | 330-379 | 50 | text |
| Separator | CHARACTER | 380-380 | 1 | must be blank |
| NUMREC | INTEGER | 381-389 | 9 | number of records (if not specified, it will be considered as 5000) |
| Separator | CHARACTER | 390-390 | 1 | must be blank |
| RECLEN | INTEGER | 391-395 | 5 | length of records (mandatory field) |