Expert: Jean-Pierre Zuate Date: 6/12/2006 Subject: data exporting from ingres
Question How do i export data to flat file or spreadsheet from ingres visual dba gui
Answer Hello,
For Ingres R3 and following.
From Ingres Visual Manager try to right-click and choose Ingres Export Assistant
From Ingres Visual DBA, right-click on a table name and choose copydb. You will then make the sql files (see in your II_TEMPORARY location) to copy out and copy in your table. Then you can use the following syntax (from DOS or Unix prompt) : sql yourdb < copy.out
copy.out (or .in) is just a collection of SQL orders that do the copy (COPY TABLE .... INTO 'file'). So by modifying this file you can :
- choose the format of each data and separator (see doc about this)
- choose the file name (in your case add the .csv extention)
