Re: Pulling data out of informix tables

You can use the the "UNLOAD" SQL-Statement to write any selected data to an ASCII file. to use it from the command line you can write something like this : dbaccess <dbname> - <<EOF UNLOAD TO <outputfilename> DELIMITER '@' SELECT * FROM table;EOF perhaps this is what you want -- Ciao from Bodo Any Contacts please to B_Wippermann@compuserve.com Wayne Regier <censure@southwind.net> wrote in article <01bc0110$d3005490$476235ce@wayne>... > 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). > > Wayne Regier > Intuitive Solutions >