Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!ucsd!ucbvax!hplabs!pyramid!infmx!dranney From: dranney@infmx.UUCP (David Ranney) Newsgroups: comp.databases Subject: Re: reading flat files in Informix Message-ID: <2735@infmx.UUCP> Date: 30 Nov 89 23:35:36 GMT References: <792@crash.cts.com> <1989Nov29.233548.14714@aqdata.uucp> Reply-To: dranney@infmx.UUCP (David Ranney) Organization: Informix, Menlo Park, Ca. U.S.A. Lines: 22 In article <1989Nov29.233548.14714@aqdata.uucp> sullivan@aqdata.uucp (Michael T. Sullivan) writes: >From article <792@crash.cts.com>, by scotto@crash.cts.com (Scott O'Connell): >> I have a need to read in prepared text files with Informix 4GL. The > >I was about to respond to this article with something along the lines >of filters and using RDSQL's "load" command when something made me look >in the 4gl manual. I find out there is no "load" command and there is >no "unload" command in 4gl, unlike SQL. Am I missing something here? >If I'm not, I'm going to be very upset. You are sort of correct. There is no "unload" command in 4gl, but you can write a short report that acts like unload. There is no "load" command per-se, but dbload does the exact same type of thing. Look in the appendices of your reference manual for an explanation of dbload. ------------------------------------------------------------------------------- David Ranney ({!uunet|!pyramid}!infmx!dranney) Go Brewers!! please? Consequences, schmonsequences; as long as I'm rich. -- Daffy Duck Disclaimer: Informix doesn't pay me enough to write their opinions. ------------------------------------------------------------------------------- Brought to you by Super Global Mega Corp .com