Direct Access – HEADER

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:

Note: This is produced as the byproduct of performing the Load Sequential File with DB2 Catalog job.
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)