Re: Pulling data out of informix tables

B. Wippermann wrote: > > 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 If your database has dates you might also wish to consider using a DBDATE setting of DMY4/ (or MDY4/ - it's up to you) to ensure you get the century extracted OK. This is important if you have, say, dates of birth going back before 1900. Make sure that you use the same value on both the UNLOAD and the LOAD, otherwise the ordure is likely to encounter the air conditioning :-) Regards, Tim Kelly