Re: dbload under 4GL RDS 4.00

Path: emory!samsung!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!bloom-beacon!micro-heart-of-gold.mit.edu!rutgers!pyrnj!pyramid!infmx!aland From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases.informix Summary: what's up, doc error? Message-ID: <1991Sep25.024827.24585@informix.com> Date: 25 Sep 91 02:48:27 GMT References: <1991Sep24.153208.3787@watmath.waterloo.edu> Sender: news@informix.com (Usenet News) Organization: International Brotherhood of Geeks, Local 619 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, Which is exactly wrong. The 4.00 doc has this wrong, for some reason. The filename can *not* have quotes around it. Duhhhhhhhhhhhhhhh... Try: FILE table1.new DELIMITER "|" 4 ; insert into table1 ; I hate utilities with an attitude... >-thanks in advance >-dennis -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland Circle number 408 on Usenet Reader Service Card.