Re: dbload crashing

Posted in 1992

Colonel Panic — 18 Jul 92 05:04:30 GMT — source: Informix-list mailing list archive (1991-1998)

In article <24633@dog.ee.lbl.gov> biocca@bevsun.bev.lbl.gov (Alan K Biocca) writes: >I'm experiencing crashing with dbload, making it difficult to know what's >going wrong. I've already discovered that the 'DELIMITER' keyword only >works in lowercase, but the following dbload program just coredumps. >Since I'm fairly new to Informix - is dbload generally so flakey? > > FILE "vme_database" delimiter "|" 7 ; > ( project, manufact, model, serial_num, descrip, proj_id, comment ) > values ( "gammasphere", f01, f02, f03, f05, f06, f07 ); >Informix SE, ISQL 4.00.UH1, SunOS 4.1.2 There are a couple of known bugs that could be the problem. Do you have more delimited fields in the data file than you are referencing in the dbload command file? That's one known problem (B9417, fixed in 5.0). Another is a random alignment problem which is also fixed in 5.0 (B9491). -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland I'm Pro-Anarchy... and I Vote!