Yes I use undef $variable;
But I also need to use
$sth2->execute( $test1, $test2, $test3, $test4, $test5 );
else
$sth2->execute( "$test1", "$test2", "$test3", "$test4", "$test5" ); which
not work with field date, time, interger (I did not check other type of
fields) but work with var type field!!!
Thansk to all
"RMD"
<[EMAIL PROTECTED] Pour : Stephane
Legault/Quebec/IBM@IBMCA
> cc :
Objet : Re: how to insert a blank
field in a date field
09/08/2002 06:24
PM
Hi
Did it work, undefining the variable (setting it to 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