Re: Pulling data out of informix tables

On 13 Jan 97 at 5:18, Wayne Regier wrote: > On of my clients has an old informix SCO based application. They > have no support for this application and need to move to another > system. I need to pull data from these tables into any kind of ASCII > file that I can convert to the file system used by their new system. > I am a UNIX cripple and basically can list files and view text files > with a text editor. Is there command line access to the informix > engine which allows SQL manipulation of data files. What format are > result sets put into and how can you make them so that they are > accessible from the UNIX command line (i.e.. files). You might be able to use dbexport command. If that doesn't work, you'll have to use dbaccess and unload the tables manually (UNLOAD TO filename SELECT * FROM tablename). HTH. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...