Export data from Informix-SQL 2.10.00 on Altos/UNIX????
Sven Hazejager needed to export three tables (about 15,000 rows) from Informix-SQL 2.10.00 on an old Altos UNIX system to Windows/Access as CSV. Michael Krzepkowski said UNLOAD produces pipe-delimited text and tr can convert it to tabs. Jonathan Leffler warned tr works only if data has no pipes or tabs, and DBDELIMITER=',' adds no quotes and may not exist in that version. Sven planned to try it.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi group, I've stumbled upon an ancient Altos i386 UNIX system with a database in Informix-SQL 2.10.00 installed. The owner would like to transfer the database data (three tables with some 15,000 rows) to a Windows machine (ie., Access). Question: how do I export the data from the database to, say, a CSV file? I've read the Informix FAQ and saw something about the UNLOAD SQL command. Will this work? Thanks for help! Sven Hazejager -- Toen in de schemer van Le Bistroquet Ons kabinet in elkaar werd gezet Was dat geen exempel van noest negotieren Maar veeleer een vluggertje van twee heren
Hi! Unload will give you a file delimited by pipe symbol (vertical bar |). You should be able to read this as text into access. You can also use tr to replace | by TAB and you have tab delimited which most windows programs can read. HTH Michael Sven Hazejager wrote: > Hi group, > > I've stumbled upon an ancient Altos i386 UNIX system with a database in > Informix-SQL 2.10.00 installed. The owner would like to transfer the > database data (three tables with some 15,000 rows) to a Windows machine > (ie., Access). Question: how do I export the data from the database to, > say, a CSV file? I've read the Informix FAQ and saw something about the > UNLOAD SQL command. Will this work? > > Thanks for help! > > Sven Hazejager > > -- > Toen in de schemer van Le Bistroquet > Ons kabinet in elkaar werd gezet > Was dat geen exempel van noest negotieren > Maar veeleer een vluggertje van twee heren
Great! I'll look into it. Sven Michael Krzepkowski wrote: > Hi! > > Unload will give you a file delimited by pipe symbol (vertical bar |). > > You should be able to read this as text into access. > You can also use tr to replace | by TAB and you have tab delimited > which most windows programs can read. > > HTH -- Toen in de schemer van Le Bistroquet Ons kabinet in elkaar werd gezet Was dat geen exempel van noest negotieren Maar veeleer een vluggertje van twee heren
Sven Hazejager wrote: > Great! I'll look into it. > > Michael Krzepkowski wrote: > > Unload will give you a file delimited by pipe symbol (vertical bar |). > > > > You should be able to read this as text into access. > > You can also use tr to replace | by TAB and you have tab delimited > > which most windows programs can read. If your data doesn't contain either pipe or tab characters, tr will work. If you want CSV, you can try setting DBDELIMITER="," but that does not put quotes around strings. There is also a chance that DBDELIMITER is newer than this version of ISQL (2.10.00 on Altos for those without the original article).. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>