Re: dbload under 4GL RDS 4.00

Path: emory!swrinde!cs.utexas.edu!utgpu!watserv1!watmath!plg.waterloo.edu!dvadura From: dvadura@plg.waterloo.edu (Dennis Vadura) Newsgroups: comp.databases.informix Message-ID: <1991Sep25.182238.23334@watmath.waterloo.edu> Date: 25 Sep 91 18:22:38 GMT References: <1991Sep24.153208.3787@watmath.waterloo.edu> <1991Sep25.024827.24585@informix.com> Sender: news@watmath.waterloo.edu (News Owner) Organization: Computer Science Dept., University of Waterloo 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 ; Thanks to all those that replied to my querry. Unfortunately none of the suggestions you all mentioned (making sure DELIMITER is in lower case, no quotes around the FILENAME) worked. Perhaps it was due to the fact that this is not the compiled version. Whatever the case, the solution that finaly worked and was suggested by one of the informix help line people was to use the ISQL version of dbload which my friend already had. It seems to work just fine. I share this tidbit of news so that if the problem comes up again someone may suggest using the ISQL version of dbload (I didn't know there was an ISQL dbload). -thanks again -dennis