DB2 10.5 for Linux, UNIX, and Windows

PC/IXF record types

There are five basic PC/IXF record types:

header
table
column descriptor
data
application

There are seven application subtypes that DB2® uses:

index
hierarchy
subtable
continuation
terminate
identity
DB2 SQLCA

Each PC/IXF record type is defined as a sequence of fields; these fields are required, and must appear in the order shown.

HEADER RECORD
 
   FIELD NAME     LENGTH    TYPE        COMMENTS
   ----------     -------   ---------   -------------
   IXFHRECL       06-BYTE   CHARACTER   record length
   IXFHRECT       01-BYTE   CHARACTER   record type = 'H'
   IXFHID         03-BYTE   CHARACTER   IXF identifier
   IXFHVERS       04-BYTE   CHARACTER   IXF version
   IXFHPROD       12-BYTE   CHARACTER   product
   IXFHDATE       08-BYTE   CHARACTER   date written
   IXFHTIME       06-BYTE   CHARACTER   time written
   IXFHHCNT       05-BYTE   CHARACTER   heading record count
   IXFHSBCP       05-BYTE   CHARACTER   single byte code page
   IXFHDBCP       05-BYTE   CHARACTER   double byte code page
   IXFHFIL1       02-BYTE   CHARACTER   reserved

The following fields are contained in the header record:

IXFHRECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. The H record must be sufficiently long to include all of its defined fields.
IXFHRECT: The IXF record type, which is set to H for this record.
IXFHID: The file format identifier, which is set to IXF for this file.
IXFHVERS: The PC/IXF format level used when the file was created, which is set to '0002'.
IXFHPROD: A field that can be used by the program creating the file to identify itself. If this field is filled in, the first six bytes are used to identify the product creating the file, and the last six bytes are used to indicate the version or release of the creating product. The database manager uses this field to signal the existence of database manager-specific data.
IXFHDATE: The date on which the file was written, in the form yyyymmdd.
IXFHTIME: The time at which the file was written, in the form hhmmss. This field is optional and can be left blank.
IXFHHCNT: The number of H, T, and C records in this file that precede the first data record. A records are not included in this count.
IXFHSBCP: Single-byte code page field, containing a single-byte character representation of a SBCS CPGID or '00000'.
The export utility sets this field equal to the SBCS CPGID of the exported database table. For example, if the table SBCS CPGID is 850, this field contains '00850'.
IXFHDBCP: Double-byte code page field, containing a single-byte character representation of a DBCS CPGID or '00000'.
The export utility sets this field equal to the DBCS CPGID of the exported database table. For example, if the table DBCS CPGID is 301, this field contains '00301'.
IXFHFIL1: Spare field set to two blanks to match a reserved field in host IXF files.

TABLE RECORD
 
   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     -------    ---------   -------------

   IXFTRECL       006-BYTE   CHARACTER   record length
   IXFTRECT       001-BYTE   CHARACTER   record type = 'T'
   IXFTNAML       003-BYTE   CHARACTER   name length
   IXFTNAME       256-BYTE   CHARACTER   name of data
   IXFTQULL       003-BYTE   CHARACTER   qualifier length
   IXFTQUAL       256-BYTE   CHARACTER   qualifier
   IXFTSRC        012-BYTE   CHARACTER   data source
   IXFTDATA       001-BYTE   CHARACTER   data convention = 'C'
   IXFTFORM       001-BYTE   CHARACTER   data format = 'M'
   IXFTMFRM       005-BYTE   CHARACTER   machine format = 'PC'
   IXFTLOC        001-BYTE   CHARACTER   data location = 'I'
   IXFTCCNT       005-BYTE   CHARACTER   'C' record count
   IXFTFIL1       002-BYTE   CHARACTER   reserved
   IXFTDESC       030-BYTE   CHARACTER   data description
   IXFTPKNM       257-BYTE   CHARACTER   primary key name
   IXFTDSPC       257-BYTE   CHARACTER   reserved
   IXFTISPC       257-BYTE   CHARACTER   reserved
   IXFTLSPC       257-BYTE   CHARACTER   reserved

The following fields are contained in the table record:

IXFTRECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. The T record must be sufficiently long to include all of its defined fields.
IXFTRECT: The IXF record type, which is set to T for this record.
IXFTNAML: The length, in bytes, of the table name in the IXFTNAME field.
IXFTNAME: The name of the table. If each file has only one table, this is an informational field only. The database manager does not use this field when importing data. When writing a PC/IXF file, the database manager writes the DOS file name (and possibly path information) to this field.
IXFTQULL: The length, in bytes, of the table name qualifier in the IXFTQUAL field.
IXFTQUAL: Table name qualifier, which identifies the creator of a table in a relational system. This is an informational field only. If a program writing a file has no data to write to this field, the preferred fill value is blanks. Programs reading a file might print or display this field, or store it in an informational field, but no computations should depend on the content of this field.
IXFTSRC: Used to indicate the original source of the data. This is an informational field only. If a program writing a file has no data to write to this field, the preferred fill value is blanks. Programs reading a file might print or display this field, or store it in an informational field, but no computations should depend on the content of this field.
IXFTDATA: Convention used to describe the data. This field must be set to C for import and export, indicating that individual column attributes are described in the following column descriptor (C) records, and that data follows PC/IXF conventions.
IXFTFORM: Convention used to store numeric data. This field must be set to M, indicating that numeric data in the data (D) records is stored in the machine (internal) format specified by the IXFTMFRM field.
IXFTMFRM: The format of any machine data in the PC/IXF file. The database manager will only read or write files if this field is set to PCbbb, where b represents a blank, and PC specifies that data in the PC/IXF file is in IBM® PC machine format.
IXFTLOC: The location of the data. The database manager only supports a value of I, meaning the data is internal to this file.
IXFTCCNT: The number of C records in this table. It is a right-aligned character representation of an integer value.
IXFTFIL1: Spare field set to two blanks to match a reserved field in host IXF files.
IXFTDESC: Descriptive data about the table. This is an informational field only. If a program writing a file has no data to write to this field, the preferred fill value is blanks. Programs reading a file might print or display this field, or store it in an informational field, but no computations should depend on the content of this field. This field contains NOT NULL WITH DEFAULT if the column was not null with default, and the table name came from a workstation database.
IXFTPKNM: The name of the primary key defined on the table (if any). The name is stored as a null-terminated string.
IXFTDSPC: This field is reserved for future use.
IXFTISPC: This field is reserved for future use.
IXFTLSPC: This field is reserved for future use.

COLUMN DESCRIPTOR RECORD
 
   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     -------    ---------   -------------
   IXFCRECL       006-BYTE   CHARACTER   record length
   IXFCRECT       001-BYTE   CHARACTER   record type = 'C'
   IXFCNAML       003-BYTE   CHARACTER   column name length
   IXFCNAME       256-BYTE   CHARACTER   column name
   IXFCNULL       001-BYTE   CHARACTER   column allows nulls
   IXFCDEF        001-BYTE   CHARACTER   column has defaults
   IXFCSLCT       001-BYTE   CHARACTER   column selected flag
   IXFCKPOS       002-BYTE   CHARACTER   position in primary key
   IXFCCLAS       001-BYTE   CHARACTER   data class
   IXFCTYPE       003-BYTE   CHARACTER   data type
   IXFCSBCP       005-BYTE   CHARACTER   single byte code page
   IXFCDBCP       005-BYTE   CHARACTER   double byte code page
   IXFCLENG       005-BYTE   CHARACTER   column data length
   IXFCDRID       003-BYTE   CHARACTER   'D' record identifier
   IXFCPOSN       006-BYTE   CHARACTER   column position
   IXFCDESC       030-BYTE   CHARACTER   column description
   IXFCLOBL       020-BYTE   CHARACTER   lob column length
   IXFCUDTL       003-BYTE   CHARACTER   UDT name length
   IXFCUDTN       256-BYTE   CHARACTER   UDT name
   IXFCDEFL       003-BYTE   CHARACTER   default value length
   IXFCDEFV       254-BYTE   CHARACTER   default value
   IXFCREF        001-BYTE   CHARACTER   reference type
   IXFCNDIM       002-BYTE   CHARACTER   number of dimensions
   IXFCDSIZ       varying    CHARACTER   size of each dimension

The following fields are contained in column descriptor records:

IXFCRECL

The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. The C record must be sufficiently long to include all of its defined fields.

IXFCRECT

The IXF record type, which is set to C for this record.

IXFCNAML

The length, in bytes, of the column name in the IXFCNAME field.

IXFCNAME

The name of the column.

IXFCNULL

Specifies if nulls are permitted in this column. Valid settings are Y or N.

IXFCDEF

Specifies if a default value is defined for this field. Valid settings are Y or N.

IXFCSLCT

An obsolete field whose intended purpose was to allow selection of a subset of columns in the data. Programs writing PC/IXF files should always store a Y in this field. Programs reading PC/IXF files should ignore the field.

IXFCKPOS

The position of the column as part of the primary key. Valid values range from 01 to 16, or N if the column is not part of the primary key.

IXFCCLAS

The class of data types to be used in the IXFCTYPE field. The database manager only supports relational types (R).

IXFCTYPE

The data type for the column.

IXFCSBCP

Contains a single-byte character representation of a SBCS CPGID. This field specifies the CPGID for single-byte character data, which occurs with the IXFDCOLS field of the D records for this column.

The semantics of this field vary with the data type for the column (specified in the IXFCTYPE field).

For a character string column, this field should normally contain a non-zero value equal to that of the IXFHSBCP field in the H record; however, other values are permitted. If this value is zero, the column is interpreted to contain bit string data.
For a numeric column, this field is not meaningful. It is set to zero by the export utility, and ignored by the import utility.
For a date or time column, this field is not meaningful. It is set to the value of the IXFHSBCP field by the export utility, and ignored by the import utility.
For a graphic column, this field must be zero.

IXFCDBCP

Contains a single-byte character representation of a DBCS CPGID. This field specifies the CPGID for double-byte character data, which occurs with the IXFDCOLS field of the D records for this column.

The semantics of this field vary with the data type for the column (specified in the IXFCTYPE field).

For a character string column, this field should either be zero, or contain a value equal to that of the IXFHDBCP field in the H record; however, other values are permitted. If the value in the IXFCSBCP field is zero, the value in this field must be zero.
For a numeric column, this field is not meaningful. It is set to zero by the export utility, and ignored by the import utility.
For a date or time column, this field is not meaningful. It is set to zero by the export utility, and ignored by the import utility.
For a graphic column, this field must have a value equal to the value of the IXFHDBCP field.

IXFCLENG

Provides information about the size of the column being described. For some data types, this field is unused, and should contain blanks. For other data types, this field contains the right-aligned character representation of an integer specifying the column length. For yet other data types, this field is divided into two subfields: 3 bytes for precision, and 2 bytes for scale; both of these subfields are right-aligned character representations of integers. Starting with Version 9.7, for a timestamp data type this field contains the right-aligned character representation of an integer specifying the timestamp precision.

IXFCDRID

The D record identifier. This field contains the right-aligned character representation of an integer value. Several D records can be used to contain each row of data in the PC/IXF file. This field specifies which D record (of the several D records contributing to a row of data) contains the data for the column. A value of one (for example, 001) indicates that the data for a column is in the first D record in a row of data. The first C record must have an IXFCDRID value of one. All subsequent C records must have an IXFCDRID value equal to the value in the preceding C record, or one higher.

IXFCPOSN

The value in this field is used to locate the data for the column within one of the D records representing a row of table data. It is the starting position of the data for this column within the IXFDCOLS field of the D record. If the column is nullable, IXFCPOSN points to the null indicator; otherwise, it points to the data itself. If a column contains varying length data, the data itself begins with the current length indicator. The IXFCPOSN value for the first byte in the IXFDCOLS field of the D record is one (not zero). If a column is in a new D record, the value of IXFCPOSN should be one; otherwise, IXFCPOSN values should increase from column to column to such a degree that the data values do not overlap.

IXFCDESC

Descriptive information about the column. This is an informational field only. If a program writing to a file has no data to write to this field, the preferred fill value is blanks. Programs reading a file might print or display this field, or store it in an informational field, but no computations should depend on the content of this field.

IXFCLOBL

The length, in bytes, of the long or the LOB defined in this column. If this column is not a long or a LOB, the value in this field is 000.

IXFCUDTL

The length, in bytes, of the user defined type (UDT) name in the IXFCUDTN field. If the type of this column is not a UDT, the value in this field is 000.

IXFCUDTN

The name of the user defined type that is used as the data type for this column.

IXFCDEFL

The length, in bytes, of the default value in the IXFCDEFV field. If this column does not have a default value, the value in this field is 000.

IXFCDEFV

Specifies the default value for this column, if one has been defined.

IXFCREF

If the column is part of a hierarchy, this field specifies whether the column is a data column (D), or a reference column (R).

IXFCNDIM

The number of dimensions in the column. Arrays are not supported in this version of PC/IXF. This field must therefore contain a character representation of a zero integer value.

IXFCDSIZ

The size or range of each dimension. The length of this field is five bytes per dimension. Since arrays are not supported (that is, the number of dimensions must be zero), this field has zero length, and does not actually exist.

DATA RECORD
 
   FIELD NAME     LENGTH    TYPE        COMMENTS
   ----------     -------   ---------   -------------
   IXFDRECL       06-BYTE   CHARACTER   record length
   IXFDRECT       01-BYTE   CHARACTER   record type = 'D'
   IXFDRID        03-BYTE   CHARACTER   'D' record identifier
   IXFDFIL1       04-BYTE   CHARACTER   reserved
   IXFDCOLS       varying   variable    columnar data

The following fields are contained in the data records:

IXFDRECL

The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each D record must be sufficiently long to include all significant data for the current occurrence of the last data column stored in the record.

IXFDRECT

The IXF record type, which is set to D for this record, indicating that it contains data values for the table.

IXFDRID

The record identifier, which identifies a particular D record within the sequence of several D records contributing to a row of data. For the first D record in a row of data, this field has a value of one; for the second D record in a row of data, this field has a value of two, and so on. In each row of data, all the D record identifiers called out in the C records must actually exist.

IXFDFIL1

Spare field set to four blanks to match reserved fields, and hold a place for a possible shift-out character, in host IXF files.

IXFDCOLS

The area for columnar data. The data area of a data record (D record) is composed of one or more column entries. There is one column entry for each column descriptor record, which has the same D record identifier as the D record. In the D record, the starting position of the column entries is indicated by the IXFCPOSN value in the C records.

The format of the column entry data depends on whether or not the column is nullable:

If the column is nullable (the IXFCNULL field is set to Y), the column entry data includes a null indicator. If the column is not null, the indicator is followed by data type-specific information, including the actual database value. The null indicator is a two-byte value set to x'0000' for not null, and x'FFFF' for null.
If the column is not nullable, the column entry data includes only data type-specific information, including the actual database value.

For varying-length data types, the data type-specific information includes a current length indicator. The current length indicators are 2-byte integers in a form specified by the IXFTMFRM field.

The length of the data area of a D record cannot exceed 32 771 bytes.

APPLICATION RECORD
 
   FIELD NAME     LENGTH    TYPE        COMMENTS
   ----------     -------   ---------   -------------
   IXFARECL       06-BYTE   CHARACTER   record length
   IXFARECT       01-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       12-BYTE   CHARACTER   application identifier
   IXFADATA       varying   variable    application-specific data

The following fields are contained in application records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies the application creating the A record. PC/IXF files created by the database manager can have A records with the first 6 characters of this field set to a constant identifying the database manager, and the last 6 characters identifying the release or version of the database manager or another application writing the A record.
IXFADATA: This field contains application dependent supplemental data, whose form and content are known only to the program creating the A record, and to other applications which are likely to process the A record.

DB2 INDEX RECORD

   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     --------   ---------   -------------
   IXFARECL       006-BYTE   CHARACTER   record length
   IXFARECT       001-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE   CHARACTER   application identifier = 'DB2 02.00'
   IXFAITYP       001-BYTE   CHARACTER   application specific data type = 'I'
   IXFADATE       008-BYTE   CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE   CHARACTER   time written from the 'H' record
   IXFANDXL       002-BYTE   SHORT INT   length of name of the index
   IXFANDXN       256-BYTE   CHARACTER   name of the index
   IXFANCL        002-BYTE   SHORT INT   length of name of the index creator
   IXFANCN        256-BYTE   CHARACTER   name of the index creator
   IXFATABL       002-BYTE   SHORT INT   length of name of the table
   IXFATABN       256-BYTE   CHARACTER   name of the table
   IXFATCL        002-BYTE   SHORT INT   length of name of the table creator
   IXFATCN        256-BYTE   CHARACTER   name of the table creator
   IXFAUNIQ       001-BYTE   CHARACTER   unique rule
   IXFACCNT       002-BYTE   SHORT INT   column count
   IXFAREVS       001-BYTE   CHARACTER   allow reverse scan flag
   IXFAIDXT       001-BYTE   CHARACTER   type of index
   IXFAPCTF       002-BYTE   CHARACTER   amount of pct free
   IXFAPCTU       002-BYTE   CHARACTER   amount of minpctused
   IXFAEXTI       001-BYTE   CHARACTER   reserved
   IXFACNML       006-BYTE   SHORT INT   length of name of the columns
   IXFACOLN       varying    CHARACTER   name of the columns in the index

One record of this type is specified for each user defined index. This record is located after all of the C records for the table. The following fields are contained in DB2 index records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFAITYP: Specifies that this is subtype "I" of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFANDXL: The length, in bytes, of the index name in the IXFANDXN field.
IXFANDXN: The name of the index.
IXFANCL: The length, in bytes, of the index creator name in the IXFANCN field.
IXFANCN: The name of the index creator.
IXFATABL: The length, in bytes, of the table name in the IXFATABN field.
IXFATABN: The name of the table.
IXFATCL: The length, in bytes, of the table creator name in the IXFATCN field.
IXFATCN: The name of the table creator.
IXFAUNIQ: Specifies the type of index. Valid values are P for a primary key, U for a unique index, and D for a non unique index.
IXFACCNT: Specifies the number of columns in the index definition.
IXFAREVS: Specifies whether reverse scan is allowed on this index. Valid values are Y for reverse scan, and N for no reverse scan.
IXFAIDXT: Specifies the index type. Valid values are R for a regular index, and C for a clustered index.
IXFAPCTF: Specifies the percentage of index pages to leave as free. Valid values range from -1 to 99. If a value of -1 or zero is specified, the system default value is used.
IXFAPCTU: Specifies the minimum percentage of index pages that must be free before two index pages can be merged. Valid values range from 00 to 99.
IXFAEXTI: Reserved for future use.
IXFACNML: The length, in bytes, of the column names in the IXFACOLN field.
IXFACOLN: The names of the columns that are part of this index. Valid values are in the form +name-name..., where + specifies an ascending sort on the column, and - specifies a descending sort on the column.

DB2 HIERARCHY RECORD

   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     --------   ---------   -------------
   IXFARECL       006-BYTE   CHARACTER   record length
   IXFARECT       001-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE   CHARACTER   application identifier = 'DB2 02.00'
   IXFAXTYP       001-BYTE   CHARACTER   application specific data type = 'X'
   IXFADATE       008-BYTE   CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE   CHARACTER   time written from the 'H' record
   IXFAYCNT       010-BYTE   CHARACTER   'Y' record count for this hierarchy
   IXFAYSTR       010-BYTE   CHARACTER   starting column of this hierarchy

One record of this type is used to describe a hierarchy. All subtable records (see the following list) must be located immediately after the hierarchy record, and hierarchy records are located after all of the C records for the table. The following fields are contained in DB2 hierarchy records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFAXTYP: Specifies that this is subtype "X" of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFAYCNT: Specifies the number of subtable records that are expected after this hierarchy record.
IXFAYSTR: Specifies the index of the subtable records at the beginning of the exported data. If export of a hierarchy was started from a non-root subtable, all parent tables of this subtable are exported. The position of this subtable inside of the IXF file is also stored in this field. The first X record represents the column with an index of zero.

DB2 SUBTABLE RECORD

   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     --------   ---------   -------------
   IXFARECL       006-BYTE   CHARACTER   record length
   IXFARECT       001-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE   CHARACTER   application identifier = 'DB2 02.00'
   IXFAYTYP       001-BYTE   CHARACTER   application specific data type = 'Y' 
   IXFADATE       008-BYTE   CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE   CHARACTER   time written from the 'H' record
   IXFASCHL       003-BYTE   CHARACTER   type schema name length
   IXFASCHN       256-BYTE   CHARACTER   type schema name
   IXFATYPL       003-BYTE   CHARACTER   type name length
   IXFATYPN       256-BYTE   CHARACTER   type name
   IXFATABL       003-BYTE   CHARACTER   table name length
   IXFATABN       256-BYTE   CHARACTER   table name
   IXFAPNDX       010-BYTE   CHARACTER   subtable index of parent table
   IXFASNDX       005-BYTE   CHARACTER   starting column index of current table
                                           
   IXFAENDX       005-BYTE   CHARACTER   ending column index of current table

One record of this type is used to describe a subtable as part of a hierarchy. All subtable records belonging to a hierarchy must be stored together, and immediately after the corresponding hierarchy record. A subtable is composed of one or more columns, and each column is described in a column record. Each column in a subtable must be described in a consecutive set of C records. The following fields are contained in DB2 subtable records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFAYTYP: Specifies that this is subtype "Y" of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFASCHL: The length, in bytes, of the subtable schema name in the IXFASCHN field.
IXFASCHN: The name of the subtable schema.
IXFATYPL: The length, in bytes, of the subtable name in the IXFATYPN field.
IXFATYPN: The name of the subtable.
IXFATABL: The length, in bytes, of the table name in the IXFATABN field.
IXFATABN: The name of the table.
IXFAPNDX: Subtable record index of the parent subtable. If this subtable is the root of a hierarchy, this field contains the value -1.
IXFASNDX: Starting index of the column records that made up this subtable.
IXFAENDX: Ending index of the column records that made up this subtable.

DB2 CONTINUATION RECORD

   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     --------   ---------   -------------
   IXFARECL       006-BYTE   CHARACTER   record length
   IXFARECT       001-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE   CHARACTER   application identifier = 'DB2 02.00'
   IXFACTYP       001-BYTE   CHARACTER   application specific data type = 'C'
   IXFADATE       008-BYTE   CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE   CHARACTER   time written from the 'H' record
   IXFALAST       002-BYTE   SHORT INT   last diskette volume number
   IXFATHIS       002-BYTE   SHORT INT   this diskette volume number
   IXFANEXT       002-BYTE   SHORT INT   next diskette volume number

This record is found at the end of each file that is part of a multi-volume IXF file, unless that file is the final volume; it can also be found at the beginning of each file that is part of a multi-volume IXF file, unless that file is the first volume. The purpose of this record is to keep track of file order. The following fields are contained in DB2 continuation records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFACTYP: Specifies that this is subtype "C" of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFALAST: This field is a binary field, in little-endian format. The value should be one less than the value in IXFATHIS.
IXFATHIS: This field is a binary field, in little-endian format. The value in this field on consecutive volumes should also be consecutive. The first volume has a value of 1.
IXFANEXT: This field is a binary field, in little-endian format. The value should be one more than the value in IXFATHIS, unless the record is at the beginning of the file, in which case the value should be zero.

DB2 TERMINATE RECORD

   FIELD NAME     LENGTH     TYPE        COMMENTS
   ----------     --------   ---------   -------------
   IXFARECL       006-BYTE   CHARACTER   record length
   IXFARECT       001-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE   CHARACTER   application identifier = 'DB2 02.00'
   IXFAETYP       001-BYTE   CHARACTER   application specific data type = 'E' 
   IXFADATE       008-BYTE   CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE   CHARACTER   time written from the 'H' record

This record is the end-of-file marker found at the end of an IXF file. The following fields are contained in DB2 terminate records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFAETYP: Specifies that this is subtype "E" of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.

DB2 IDENTITY RECORD
  
   FIELD NAME     LENGTH    TYPE        COMMENTS
   ----------     -------   ---------   -------------
   IXFARECL       06-BYTE   CHARACTER   record length
   IXFARECT       01-BYTE   CHARACTER   record type = 'A'
   IXFAPPID       12-BYTE   CHARACTER   application identifier
   IXFATYPE       01-BYTE   CHARACTER   application specific record type = 'S'
   IXFADATE       08-BYTE   CHARACTER   application record creation date
   IXFATIME       06-BYTE   CHARACTER   application record creation time
   IXFACOLN       06-BYTE   CHARACTER   column number of the identity column
   IXFAITYP       01-BYTE   CHARACTER   generated always ('Y' or 'N')
   IXFASTRT       33-BYTE   CHARACTER   identity START AT value
   IXFAINCR       33-BYTE   CHARACTER   identity INCREMENT BY value
   IXFACACH       10-BYTE   CHARACTER   identity CACHE value
   IXFAMINV       33-BYTE   CHARACTER   identity MINVALUE
   IXFAMAXV       33-BYTE   CHARACTER   identity MAXVALUE
   IXFACYCL       01-BYTE   CHARACTER   identity CYCLE ('Y' or 'N')
   IXFAORDR       01-BYTE   CHARACTER   identity ORDER ('Y' or 'N')
   IXFARMRL       03-BYTE   CHARACTER   identity Remark length
   IXFARMRK      254-BYTE   CHARACTER   identity Remark value

The following fields are contained in DB2 identity records:

IXFARECL: The record length indicator. A 6-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus 6 bytes. Each A record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to A for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this A record.
IXFATYPE: Application specific record type. This field should always have a value of "S".
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFACOLN: Column number of the identity column in the table.
IXFAITYP: The type of the identity column. A value of "Y" indicates that the identity column is always GENERATED. All other values are interpreted to mean that the column is of type GENERATED BY DEFAULT.
IXFASTRT: The START AT value for the identity column that was supplied to the CREATE TABLE statement at the time of table creation.
IXFAINCR: The INCREMENT BY value for the identity column that was supplied to the CREATE TABLE statement at the time of table creation.
IXFACACH: The CACHE value for the identity column that was supplied to the CREATE TABLE statement at the time of table creation. A value of "1" corresponds to the NO CACHE option.
IXFAMINV: The MINVALUE for the identity column that was supplied to the CREATE TABLE statement at the time of table creation.
IXFAMAXV: The MAXVALUE for the identity column that was supplied to the CREATE TABLE statement at the time of table creation.
IXFACYCL: The CYCLE value for the identity column that was supplied to the CREATE TABLE statement at the time of table creation. A value of "Y" corresponds to the CYCLE option, any other value corresponds to NO CYCLE.
IXFAORDR: The ORDER value for the identity column that was supplied to the CREATE TABLE statement at the time of table creation. A value of "Y" corresponds to the ORDER option, any other value corresponds to NO ORDER.
IXFARMRL: The length, in bytes, of the remark in IXFARMRK field.
IXFARMRK: This is the user-entered remark associated with the identity column. This is an informational field only. The database manager does not use this field when importing data.

DB2 SQLCA RECORD

   FIELD NAME     LENGTH    TYPE        COMMENTS
   ----------     -------   ---------   -------------
   IXFARECL       006-BYTE  CHARACTER   record length
   IXFARECT       001-BYTE  CHARACTER   record type = 'A'
   IXFAPPID       012-BYTE  CHARACTER   application identifier = 'DB2 02.00'
   IXFAITYP       001-BYTE  CHARACTER   application specific data type = 'A'
   IXFADATE       008-BYTE  CHARACTER   date written from the 'H' record
   IXFATIME       006-BYTE  CHARACTER   time written from the 'H' record
   IXFASLCA       136-BYTE  variable    sqlca - SQL communications area

One record of this type is used to indicate the IXF file cannot be used to re-create the table in a subsequent import operation. For more information, refer to the message and reason code returned in IXFASLCA.

The following fields are contained in DB2 SQLCA records:

IXFARECL: The record length indicator. A six-byte character representation of an integer value specifying the length, in bytes, of the portion of the PC/IXF record that follows the record length indicator; that is, the total record size minus six bytes. Each 'A' record must be sufficiently long to include at least the entire IXFAPPID field.
IXFARECT: The IXF record type, which is set to 'A' for this record, indicating that this is an application record. These records are ignored by programs which do not have particular knowledge about the content and the format of the data implied by the application identifier.
IXFAPPID: The application identifier, which identifies DB2 as the application creating this 'A' record.
IXFAITYP: Specifies that this is subtype 'A' of DB2 application records.
IXFADATE: The date on which the file was written, in the form yyyymmdd. This field must have the same value as IXFHDATE.
IXFATIME: The time at which the file was written, in the form hhmmss. This field must have the same value as IXFHTIME.
IXFASLCA: SQL communications area, which contains the SQL27984W warning message, along with a reason code that explains why the IXF file does not contain all of the information required by the IMPORT command to re-create the table.