HPL & Collection Data

Posted in 1999

Peter Jones — Wed, 13 Jan 1999 17:56:19 -0000 — source: Informix-list mailing list archive (1991-1998)

Anyone had success loading list collections with the HPL and IUS 9.14? I have a table with about 20 columns of either LIST(INTEGER NOT NULL) or LIST(REAL NOT NULL). The data file is delimited and the field format is External String Type. The format in the file is LIST{1,2,3,4} etc. The lists are about 100 items long. If it try it with just one column it seems to work fine. But when I do my whole table I get no errors just a load of nulls in all the columns. It works fine with SQL LOAD and with dbload - but sloooooow .. and I've got 100,000 rows to load. Anyone help? Thanks Peter