Hi,

I'm a newbie in Informix and therefore my next questions may appear too simple. I would appreciate any kind of help.

I would like to know if there is any way to export an Informix Schema to a flat file and export data to another, separetely!
And what is the syntax for those two cases.

Thanks.

Master Aucrun

If you use dbexport, this tool will create a directory with an sql inside like the name of database and that sql as the schema. The data will be in files separated each one as its table.

Hi Luis,

Thanks for your response.
By other words you say that with the usage of DBExport, I will manage to have both schema and data in separate files?

For instance, an example where I have two tables (TABLE_1 and TABLE_2):
- If I understood correctly, I would have three files:
- Database Schema with TABLE_1, TABLE_2, Indexes, Views, ...
- Data from TABLE_1
- Data from TABLE_2
Is that right?

When using DBExport the data files are generated automatically, right? Is there any way of identifying any character delimeter for fields?
For instance to get me the same result of the following sentence: "UNLOAD to flatfilename DELIMITER ',' SELECT * FROM TABLENAME"

Thanks!

Hi aucrun,

You can read the reference Informix site at:

IBM Informix Dynamic Server v10 Information Center

About the delimiter for default is pipe "|", but you can specify one-other using DELIMITER yes. You have to set one Informix variable for export with that.

Luís.

Thanx.

I've gathered the Export files from DBexport, and they look like exactly as you've told, with "|" separating the fields.
Now, reading it onto an Oracle table should be easy with SQL Loader, right?

Thanks!