Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!pacbell.com!ucsd!nosc!crash!ipars!scotto
From: scotto@ipars.UUCP (Scott O'Connell)
Newsgroups: comp.databases
Subject: Informix dbload utility
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
Lines: 33


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