AllExperts > Ingres 
Search      
Ingres
Volunteer
Answers to thousands of questions
 Home · More Ingres Questions · Answer Library  · Encyclopedia ·
More Ingres Answers
Question Library

Ask a question about Ingres
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

 
   

You are here:  Experts > Computing/Technology > Databases > Ingres > data exporting from ingres

Ingres - data exporting from ingres


Expert: Jean-Pierre Zuate - 6/12/2006

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)

Hope this help,
Jean-Pierre ZUATE
-  

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.