Informix dbload utility

Path: emory!swrinde!mips!pacbell.com!ucsd!nosc!crash!ipars!scotto From: scotto@ipars.UUCP (Scott O'Connell) Newsgroups: comp.databases Message-ID: <157@ipars.UUCP> Date: 21 Jun 91 04:45:53 GMT Reply-To: scotto@ipars.UUCP (Scott O'Connell) Organization: Spectrum Data Services I'm trying to use dbload for the first time and am having problems. I've narrowed it down but can't see anything wrong with what I've done. The file is fixed length. -- begin file loadfile -- file "calif" (fsectctr 1 - 3, fzone 4 - 5, fzipsub 6 - 9, flastname 10 - 14); insert into nameaddr (sectctr, zone, zipsub, lastname) values (fsectctr, fzone, fzipsub, flastname);-- end file loadfile -- I'm using the command line: dbload -d test -c loadfile -l errlog When I use the above, the dbload program just sits there doing nothing. If I remove the lastname/flastname field in the insert statement everything works fine. I can leave the flastname in the file field. It seems to have a problem with the insert. I can't see anything wrong with this so I'm looking to others for help. Thanks in advance. -- Scott O'Connell - N6ZEK UUCP: {nosc, ucsd}!crash!ipars!scotto Spectrum Data Services ARPA: crash!ipars!scotto@nosc.mil Carlsbad, CA INET: scotto@ipars.cts.com