Re: Data type problem

Peter Wiley wrote: > > In article <3403FD11.F6FA2B5E@informix.com> "Mark D. Stock" > <mdstock@informix.com> writes: > >Jonathan Leffler wrote: > >> > > > >From: "Kemlo" <abm62@dial.pipex.com> > > > >Date: 26 Aug 1997 21:10:33 GMT > > > >X-Informix-List-Id: <news.42144> > > > > > > > <SNIP> > > > > > > >I understand that there is a utility called "unload" which will > > > export the > > > >database in ASCII . My 4GL RDS package does not have this. Does > > > anyone > > > >know where I could get this utility. > > > > >> There's nothing called 'unload' as a program. There is an UNLOAD > >> statement > >> which can be embedded in an I4GL program: > >> > >> UNLOAD TO "tablename.unl" SELECT * FROM TableName > >> > >> Repeat ad nauseam for each table in the database. If you still > have > >> the AIX > >> system, you can use this to do the unloading. Given that you're > >> working with > >> a 1.1 I4GL, you probably do not have dbexport available, which does > >> this job > >> automatically. > > > >I don't think 4GL 1.10/2.10 HAD an UNLOAD command either. This could > >be a problem also. > > UNLOAD existed in ISQL back in 1989 with the 2.10 SE engine, maybe > earlier. It didn't appear in R4GL until release 4.00. I remember > having to > use ISQL or write reports to unload data back then. Thanks for that. I thought my memory was..., um, er.... :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+