You are here:
- Home
- Computing/Technology
- Databases
- Ingres
- data exporting from ingres
Ingres/data exporting from ingres
Advertisement
Question
How do i export data to flat file or spreadsheet from ingres visual dba gui
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
-
Related Articles
- Quicken QIF - How to Use Quicken QIF Data Export
- Exploring Text Files and String Processing
- Upload a file to your server and add it's details to MySQL - SQL Upload File
- How to Export Your Outlook Contacts to a CSV File - About Email
- How to Export Your Mac OS X Mail Address Book Contacts to a CSV File - About Email
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) - Ingres 9.x, Ingres 10.x - 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
Education/Credentials
Computing bachelor (1989)
Past/Present Clients
More than 100 customers during my 6 years of CA has an Ingres consultant, all around France and Africa (Togo, Cameroon, Morrocco, ...)
©2012 About.com, a part of The New York Times Company. All rights reserved.