Hmm, i'am really the first one with this problem ?
ok, maybe this is useful for others:
When Informix has not a solution have a look on the competition:
I found a nice website with a solution for postgresql:
http://www.onlamp.com/onlamp/2004/12/09/examples/create_input_sql.pl
You have only to adapt your table schema, works also perfectly for Informix.
Regards,
try_and_err
try_and_err@web.de (try_and_err) wrote in message news:<fbcbd702.0503181213.50f422e1@posting.google.com>...
> ok, maybe my first explanation was to simple (or false):
> We have a standard CSV file (comma separated) from an extern firma to
> insert in an Informix table, like this:
> 1,ABC,"ABC,DEF",DEF,2,,,
> 2,BCD,EFG,"BCD,EFG",2,,,
>
> There were three problems (for Informix/dbaccess):
> - double quotes
> - comma in double quotes identified as delimiter
> - last column without finally delimiter (table has 8 columns)
>
> ok, i can write an (awk) script to fix these problems, but i am
> surprised that is it really not possible to load an normal and
> standard CSV file in Informix ?
> sqlreload doesn't work:
> env | grep DB
> DBQUOTE="
> DBDELIMITER=,
> sqlreload -d db1 -i test1.csv -t test1 -v -x
> SQL -846: Number of values in load file is not equal to number of
> columns.
> ISAM -746: Too many values in record
> It seems, that the comma in double quotes is already identified as
> delimiter...
> I have tried with and without an additionally delimiter (comma).
> Further suggestions ?
>
> Regards,
> try_and_err