Re: dbload under 4GL RDS 4.00
Try changing the words FILE and DELIMITER to lowercase.
Scott Myers - Informix (uunet!infmx!scottm)
----------------------------------------------------------------------
From uunet!rmy.emory.edu!ilist Wed Sep 25 16:38:55 1991
Received: from informix.com (infmx) by washington. (4.0/SMI-4.0)
id AA25316; Wed, 25 Sep 91 16:38:51 EDT
Received: from uunet.UUCP by informix.com (4.1/SMI-4.1)
id AA09685; Wed, 25 Sep 91 13:38:32 PDT
Received: from rmy.rmy.emory.edu by relay2.UU.NET with SMTP
(5.61/UUNET-internet-primary) id AA23501; Wed, 25 Sep 91 16:32:47 -0400
Received: by
rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via MAILPROG
id AA26090 ; Wed, 25 Sep 91 16:32:27 -0400
Received: from emory.mathcs.emory.edu by
rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via SMTP
id AA25824 ; Wed, 25 Sep 91 10:49:16 -0400
Received: by
emory.mathcs.emory.edu (5.65/Emory_mathcs.3.2.10) via MAILPROG
id AA25758 ; Wed, 25 Sep 91 10:49:07 -0400
Return-Path: walt@mathcs.emory.edu
Date: Wed, 25 Sep 91 10:49:07 -0400
From: uunet!mathcs.emory.edu!walt (Walt Hultgren {rmy})
Message-Id: <9109251449.AA25758@emory.mathcs.emory.edu>
To: informix-news-gate@rmy
Subject: dbload under 4GL RDS 4.00
X-Informix-List-Id: <newsgate.273>
Status: R
Path: emory!swrinde!cs.utexas.edu!utgpu!watserv1!watmath!plg.waterloo.edu!dvadura
From: dvadura@plg.uwaterloo.ca (Dennis Vadura)
Newsgroups: comp.databases.informix
Message-ID: <1991Sep24.153208.3787@watmath.waterloo.edu>
Date: 24 Sep 91 15:32:08 GMT
Sender: news@watmath.waterloo.edu (News Owner)
Organization: Computer Science Dept., University of Waterloo
Originator: dvadura@plg.waterloo.edu
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.
-thanks in advance
-dennis