scotto@ipars.UUCP (Scott O'Connell) (06/21/91)
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