Howdy,
I've got an application that pulls data from an Oracle database to an IBM
DB/2 database. For the IBM database, if the data I'm pulling contains all
zeros or all spaces, they want me to insert a NULL into that field.
When selecting from Oracle I use a decode statement:
decode (thisfield, '0000000000', 0);
When inserting into IBM DB/2 I bind the variable before inserting it:
$sth = $dbh->prepare('INSERT INTO FOO (THATFIELD) VALUES (?)");
$sth->execute($thisfield);
Unfortunately, I can't figure out how to tell it to insert a NULL. The
word 'NULL' is interpreted as a character string and he cannot accept
zeros.
How do I tell DBD::DB2 that I want to insert a NULL into a field when
using binding params?
Thanks!
--
Chris Fuhrman | Twenty First Century Communications
[EMAIL PROTECTED] | Software Engineer
(W) 614-442-1215 x271 |
(F) 614-442-5662 | PGP/GPG Public Key Available on Request
