Re: Informix Export
>
>Hello,
>
>We're not using Informix, but we're dealing with a company that is.
>They can send us a copy of their Informix database by doing a database
>"export".
>
>My question: What does/will this export look like? Is it an SQL script
>that can be loaded into another SQL DBMS?
>
>Thanks,
>
>Russ Wakelin
>
Hi Russ,
AFAIK, the Informix program "dbexport" generates an sql file that
can be run in Informix to recreate the database, plus a data file
for each table. The sql script will probably need some modification
to be used with another RDBMS, but it should be "do-able". The data
files are delimited woth pipe signs between the columns, and newline
characters between the rows.
If you get hold of Informix, all you need to do is run "dbimport"
from the command line - much easier, and you'll have a decent
database to work with in future :-)
If I've missed anything, I'm sure somebody will correct me!
Cheers,
Richard.
-----------------------------------------------------------------
| _ '\\ | Richard Thomas |
| \\ 0_ | r.thomas@csl.gov.uk |
| \\ / | |
| oo/ | "20 Regal and a four-pack, |
| / \\ | I guess I'm set for the night" |
| \\_/ | - "TV Tan" The Wildhearts |
-----------------------------------------------------------------