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
PC
bbb, 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
orN
. - IXFCDEF
- Specifies if a default value is defined for this field. Valid
settings are
Y
orN
. - 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
to16
, orN
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.
- If the column is nullable (the IXFCNULL field is set to
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, andD
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, andN
for no reverse scan. - IXFAIDXT
- Specifies the index type. Valid values are
R
for a regular index, andC
for a clustered index. - IXFAPCTF
- Specifies the percentage of index pages to leave as free. Valid values range from
-1
to99
. 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
to99
. - 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.