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