Re: error number -1263.
And what version of Informix Database Engine are you running???
I ask because this is probably the one instance when you can't.
If at all possible check out DBLOAD or the HPL (Jack Parker's personal Fav).
Jack even has info on his web site (www.artentech.com/downloads.htm)
Shameless plug I know but maybe Jack will buy me a beverage when I see him
next. Can you say "Aqua al diente"? (sp?)
Rob
> Rob:
> load from "filename" into
> table1, is the tool>
> regards
>
>
> ***********************************
> Juan I Carbajal R.
> AUDITOR DE FRAUDE INTERNACIONAL
> INTERNATIONAL FRAUD AUDITOR
> RADIOMOVIL DIPSA SA de CV
> AV Ej'rcito NAL #488 Col. Polanco
> 011(52)55-56253700 ext 2489
> ----- Original Message -----
> From: "Rob Vorbroker" <robv@dns1.vcicentral.com>
> To: <jcarbajal@mail.telcel.com>
> Cc: <informix-list@iiug.org>
> Sent: Tuesday, May 13, 2003 4:37 PM
> Subject: Re: error number -1263.
>
>
>> Blame it on my mood but do you ever just want to answer 'YES' to one
>> of these.
>>
>> Seriously Yes but how depends on what tool you are using to load rows
>> into your table. Please supply this forum with a bit more
>> information. Are you using dbload, hpl, c/esql, dbaccess and load from
>> "filename" into table1, etc.
>>
>> Rob "SMARTASS TODAY"
>>
>> > Hello:
>> > is there anyway to filter rows that fail to satisfy column type so
>> my load transaction doesn't stop?
>> > regards
>> >
>> >
>> > ***********************************
>> > Juan I Carbajal R.
>> > AUDITOR DE FRAUDE INTERNACIONAL
>> > INTERNATIONAL FRAUD AUDITOR
>> > RADIOMOVIL DIPSA SA de CV
>> > AV Ej'rcito NAL #488 Col. Polanco
>> > 011(52)55-56253700 ext 2489