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
