Re: dbload crashing

>From: uunet!bevsun.bev.lbl.gov!biocca (Alan K Biocca) >Subject: dbload crashing >Date: 16 Jul 92 22:19:39 GMT >X-Informix-List-Id: <news.1547> > >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. > FILE "vme_database" delimiter "|" 7 ; > ( project, manufact, model, serial_num, descrip, proj_id, comment ) > values ( "gammasphere", f01, f02, f03, f05, f06, f07 ); I'm not sure about why it core dumps -- it shouldn't. But then, no program should produce a core dump unless it is a documented method of reporting an error. I would expect the dbload statements to look like: FILE "vme_database" delimiter "|" 7 ; INSERT INTO Some_table_or_other { This was missing } ( project, manufact, model, serial_num, descrip, proj_id, comment ) values ( "gammasphere", f01, f02, f03, f05, f06, f07 ); >Since I'm fairly new to Informix - is dbload generally so flakey? Yes. It's also apt to be slow. >Informix SE, ISQL 4.00.UH1, SunOS 4.1.2 What about moving to 5.00? Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>