Products Downloads


French version


 

The IXF source (SRC = "IXF") enables IXF format files to be read and written (IXF is DB2's standard exchange format). These present the advantage of being binary files, meaning they can store any type of data. In addition, this format can be used to store an accurate description of the table.

The IXF V1 (DB2 <= 5.2) and IXF V2 (DB2 >= 6.1) formats are recognized, and detected automatically in read mode.


The following source-related parameters are recognized:


Input parameters (DATA_SRC)

Parameter name

Type

Mandatory

Description

FILE

string

Yes

Name of the IXF file to be read.

FILEDIR

string

No

Directory containing the file.
If no directory is specified, the current directory will be used.

LOBDIR

string

No

Directory containing the LOB files.

If the IXF file contains references to large binary data objects (> 32,700 bytes), these can be stored in external files called "LOB files".

If this directory is not specified, the system considers the LOB files to be in the same directory as the IXF file.

Output parameters (DATA_DEST)

Parameter name

Type

Mandatory

Description

FILE

string

Yes

Name of the IXF file to be produced.

FILEDIR

string

No

Directory receiving the file. If no directory is specified, the current directory will be used.

LOBDIR

string

No

Directory receiving the LOB files.

If the IXF file contains references to large binary data objects (> 32,700 bytes), these can be stored in external files called "LOB files".

If this directory is not specified, the system considers that the LOB files will be produced in the same directory as the IXF file.

VERSION

integer

Yes

Version number of the IXF file to be produced.
The possible values are:

- "1": DB2 <= 5.2,

- "2": DB2 >= 6.1.

Specific features of the Java version:


The IXF source uses the ANSI character set (Cp1252 or override with -DansiCharset) defined in the introduction for non-Unicode data, and the UTF-16LE character set for Unicode data (Graphical in the DB2 sense). The file's code page is derived from the ANSI character set.


The IXF source is compatible in read mode with older versions of the format (PC-IXF 1.0 / DB2 <= 5.x). However, it only produces files in format 2.0 (DB2 6.1 and later) in write mode, which means that the VERSION parameter is ignored in write mode.



Click below for further details about:


↑ Top of page