ixfcvt

A tool for converting an IBM PC/IXF format file to SQL statements

Currently supports the following DB2 data types:

• CHAR
• VARCHAR
• SMALLINT
• INTEGER
• BIGINT
• DECIMAL
• REAL
• DOUBLE
• DATE
• TIME
• TIMESTAMP

Building:

on Linux:   cd src && make
on AIX:     cd src && make -f Makefile.AIX

Usage:

ixfcvt [-c CFILE] [-t TNAME] [-e] [-o OFILE] [-s SIZE] [IXFFILE]

Argument:

<IXFFILE>   input IXF format file, the data source

Options:

-c CFILE    output CREATE TABLE statement to <CFILE> if specified
-e          escape backslash(\\), or use it as literal by default
-h          display this help and exit
-o OFILE    output data of <IXFFILE> as INSERT statements to <OFILE>
            If not specified, write to the standard output
            <IXFFILE>, <OFILE> and <CFILE> must differ from each other
-s SIZE     issue a COMMIT every <SIZE> rows (default 1000)
            If <SIZE> is 0, no COMMIT statement will be issued
-t TNAME    use <TNAME> as the table name when output
            If not specified, use data name of <IXFFILE>
-v          show version: "ixfcvt V0.80 by Guo, Xingchun"

Examples:

./ixfcvt -c create_table.sql -t tableA -e -o insert_data.sql -s 2000 source.ixf
./ixfcvt -c create_table.sql -o insert_data.sql source.ixf
./ixfcvt -t tableB -o insert_data.sql source.ixf
./ixfcvt -o insert_data.sql source.ixf

To insert data generated by ixfcvt to Oralce, set nls date/time format parameters first.
e.g.  ALTER SESSION SET nls_timestamp_format = 'YYYY-MM-DD-HH24.MI.SS.FF6';

References:

• PC/IXF file format specification from IBM
• PC/IXF data type descriptions from IBM

License:

Licensed under the Apache License, Version 2.0.