Re: LOAD DATA

Posted in 2001

Colin McGrath — Mon, 29 Jan 2001 10:37:28 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

Is it in CSV format or is it pipe-delimited? If CSV, do you want to get rid of the quotes around the character fields before you load? What's wrong with dbload? smithj48@my-deja.com wrote: > > Does anyone know of another way to load tables other than using DBLOAD? > > I have data from Oracle in CSV format ("|" delimited) being loaded into > IFX 9 > > Cheers > > James -- Colin

↪ replying to Colin McGrath

smithj48@my-deja.com — Mon, 29 Jan 2001 16:37:21 GMT — source: Informix-list mailing list archive (1991-1998)

It is pipe-delimited. I am having problems with dbload it keeps compaining about a bad eof. There is nothing after the last peice of data (That I can find. The files are being produced from an Oracle DB). I also have problems with one piece of data. It is that last entry on each row (money field), and is a defined as Money in the table but when I try loading it complains about unable to convert the type. I have tried using decimal but I get the same error, but if I use Char it loads!!! In article <95439e$cj7$1@news.xmission.com>, Colin McGrath <cmm@trac3000.ueci.com> wrote: > > Is it in CSV format or is it pipe-delimited? > If CSV, do you want to get rid of the quotes around the character fields > before you load? > > What's wrong with dbload? > > smithj48@my-deja.com wrote: > > > > Does anyone know of another way to load tables other than using DBLOAD? > > > > I have data from Oracle in CSV format ("|" delimited) being loaded into > > IFX 9 > > > > Cheers > > > > James > > -- > Colin > Sent via Deja.com http://www.deja.com/