Re: Data type problem

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. Best bet is to resurrect the AIX box, unload the data to ASCII using a tedious set of reports and then reload it. If you can't do that because the box is defunct....maybe someone here has one available. This pack rat still has a 1989 PC Informix dev system sitting in the book case. Peter Wiley