On 11 Oct, Naveen Prabhakar wrote: > I get this kind of error when I try to execute after > binding parameters. > DBD::DB2::st execute failed: [IBM][CLI Driver] > CLI0109E String data right truncation. SQLSTATE=22001 > at ./dbinit2.pl line 326, <USERDATA> chunk 1.
That error occurs when you have a char or varchar field of a given length, and you try to put a longer string into it. You have to truncate the string in Perl (substr can be used for this), before trying to use it as a placeholder. DBD::DB2 doesn't have an automatic truncation feature that i know of. -johnnnnnnnnnnn