- CHAR
- VARCHAR
- SMALLINT
- INTEGER
- BIGINT
- DECIMAL
- REAL
- DOUBLE
- DATE
- TIME
- TIMESTAMP
on Linux: cd src && make
on AIX: cd src && make -f Makefile.AIX
ixfcvt [-c CFILE] [-t TNAME] [-e] [-o OFILE] [-s SIZE] [IXFFILE]
<IXFFILE> input IXF format file, the data source
-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"
./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';