Hi All!

Any help towards the subject is wellcome: HOW-TO, tips and tricks, etc...

Thanks a lot in advance,
Sergei

En Serge Moisseyev va escriure el dia  2 Oct 2001, a les 12:00:

I supose Oracle DUM file = ascii flat file with a <LF> by row.
If this it's correc you can use dbload:

See Informix migration guide for more detailed help.

---------------------------------------
 Isidre PONS ROCA
 BASE - Gesti d'Ingressos Locals
 (Diputacio de Tarragona)
 Servei de Sistemes d'Informacio
 Av President Lluis Companys 12-C
 43005 - Tarragona
 SPAIN
 Tel # +34 977 236731
 Fax # +34 977 227302
 http://www.base.es

---------------------------------------

I suppose you are talking about an oracle export.
You will need to change the export file into a delimited file
Never done it, but I would try the following:
1: exp with option compress=N
The result is not completely a comma delimited file, but has to be cleaned
2: Look with head and tail what the file looks like
3: Use awk to clean it (sed might also do it and perl certainly can. If not
too big you could use an editor)
4: Load it into Informix with dbload.

Joachim.
--

WWW http://www.xs4all.nl/~jcdverha/  (Science Jokes)