I think you must not insert a blank value in the date field, instead you
must insert a 'null'
regards

Ricardo Derbes
Altec SE
Albarrac�n 157 - San Carlos de Bariloche
+54-2944-426892
[EMAIL PROTECTED]
----- Original Message -----
From: "Stephane Legault/Quebec/IBM" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 2:35 PM
Subject: how to insert a blank field in a date field


> I'am parsing a text field delimited by ; (see example belown). I split the
> file into multiple variable ($) and then execute the request. When the NO
> is blank: no problem the record is write inside DB but when de DATE is
> blank I receive a message from DB telling me that the format of the date
is
> not good!!!
>
> I'am using DB2 all the field in the table can be null. Someone can help
> me???
>
> Thanks
>
>
>
> TEXT FILE
> no;date;text;blablabla

Reply via email to