RE: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-10-31 Thread Martin J. Evans
On 28-Sep-2006 Stephen More wrote: > Environment: >RHEL 4 >perl-5.8.5-24.RHEL4 >perl-DBI-1.40-8 >perl-DBD-ODBC-1.13-1 >unixODBC-2.2.11-3.FC4.1 >iSeriesAccess-5.4.0-1.0.i386.rpm > > I am trying to call a simple stored procedure on an iSeries / AS400: > >#!/usr/bin/perl -w

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Stephen More
On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: Do you know where I can get the DB2 ODBC driver for Linux. I have not got a rpm based system but I could probably unpack the rpm and manually install it. The rpm can be downloaded from: http://www.ibm.com/eserver/iseries/access/linux/ If yo

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Martin J. Evans
On 29-Sep-2006 Stephen More wrote: > On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: >> Stephen. I would try correcting your code which calls bind_param >> incorrectly: >> >> $sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a ); >> $sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b ); >

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Stephen More
On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: Stephen. I would try correcting your code which calls bind_param incorrectly: $sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a ); $sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b ); I changed my code with: $sth->bind_param(1, $a );

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Martin J. Evans
On 28-Sep-2006 Martin J. Evans wrote: > Stephen More wrote: >> Environment: >> RHEL 4 >> perl-5.8.5-24.RHEL4 >> perl-DBI-1.40-8 >> perl-DBD-ODBC-1.13-1 >> unixODBC-2.2.11-3.FC4.1 >> iSeriesAccess-5.4.0-1.0.i386.rpm >> >> I am trying to call a simple stored procedure on an iSeries / AS

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-28 Thread Martin J. Evans
Stephen More wrote: Environment: RHEL 4 perl-5.8.5-24.RHEL4 perl-DBI-1.40-8 perl-DBD-ODBC-1.13-1 unixODBC-2.2.11-3.FC4.1 iSeriesAccess-5.4.0-1.0.i386.rpm I am trying to call a simple stored procedure on an iSeries / AS400: #!/usr/bin/perl -w use strict; $ENV{PERL_DL_NONLAZY}=1; u

Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-28 Thread Stephen More
Environment: RHEL 4 perl-5.8.5-24.RHEL4 perl-DBI-1.40-8 perl-DBD-ODBC-1.13-1 unixODBC-2.2.11-3.FC4.1 iSeriesAccess-5.4.0-1.0.i386.rpm I am trying to call a simple stored procedure on an iSeries / AS400: #!/usr/bin/perl -w use strict; $ENV{PERL_DL_NONLAZY}=1; use DBD::ODBC; my( $d