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.

 

 

Click below for further details about:

 

↑ Top of page