Re: dbload under 4GL RDS 4.00

Path: emory!sol.ctr.columbia.edu!samsung!olivea!uunet!sequent!muncher.sequent.com!lugnut From: lugnut@sequent.com Newsgroups: comp.databases.informix Message-ID: <1991Sep24.181837.5498@sequent.com> Date: 24 Sep 91 18:18:37 GMT References: <1991Sep24.153208.3787@watmath.waterloo.edu> Sender: news@sequent.com (News on Muncher) Organization: Sequent Computer Systems, Inc. In article <1991Sep24.153208.3787@watmath.waterloo.edu> dvadura@plg.uwaterloo.ca (Dennis Vadura) writes: >This one is for a friend. She's been trying to use dbload (under 4GL RDS 4.00 >the interpretted version) to load a an ascii file containing variable length >data records into a simple database. The file contains lines of the form: > > f1|f2|f3|f4| > f1|f2|f3|f4| > f1|f2|f3|f4| > ... > >She's built a command file which contains: > > FILE "table1.new" DELIMITER "|" 4 ; > insert into table1 ;> >Which is exactly as is described in Appendix E of Volume 2 of the reference >manual. running dbload on this with the command line, > > dbload -d database -c cmdfile -l err> >(I think those are the flags, anyway, you give the file, the database and an >error log file) produces nothing but a message saying that a file command >must be the first command in the command file. I've checked the manual for >her and can see nothing wrong. She's placed a call to informix but alas got >told "all our soFtware engineers are busy" so I thought I'd post here >since no doubt someone has tried this and perhaps even figured out what >the magic incantation should be. > Hows bout creating a table in ISQL and using the ISQL LOAD FROM "filename" INSERT INTO tablename; ???? Works for me Don "but I'm to dense to know better too" Bolton