Bug #12081 for DBD-DB2: SQL_PARAM_INPUT

Wed Mar 30 17:04:51 2005 Guest - Ticket created

Subject:

SQL_PARAM_INPUT_OUTPUT not defined

1. Perl version: This is perl, v5.8.6 built for MSWin32-x86-multi-thread 2. OS: Windows XP Professional (SP2 not installed) 3. Error info: C:\Perl\DBD-DB2-0.78>nmake test Microsoft (R) Program Maintenance Utility Version 7.10.3077 Copyright (C) Microsoft Corporation. All rights reserved. C:\Perl\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib\lib', 'blib\arch')" t\base. t t\main.t t\base....install_driver(DB2) failed: Your vendor has not defined DBD::DB2::Constants macro SQL_PARAM_INPUT_OU TPUT at C:\Perl\DBD-DB2-0.78\blib\lib/DBD/DB2.pm line 40 Compilation failed in require at (eval 1) line 3. at t\base.t line 16 t\base....dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t\main....ok Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t\base.t 255 65280 5 4 80.00% 4-5 Failed 1/2 test scripts, 50.00% okay. 2/6 subtests failed, 66.67% okay. NMAKE : fatal error U1077: 'C:\Perl\bin\perl.exe' : return code '0xff' Stop.

Wed Oct 25 14:58:03 2006 opendev [...] us.ibm.com - Correspondence added

Hi, We have newly taken over DBD::DB2 and were trying to resolve tihs bug. Do you still face this problem or has it been resolved in later versions of DBD::DB2/DBI?

Wed Oct 25 14:58:04 2006 The RT System itself - Status changed from 'new' to 'open'

Mon Feb 09 03:26:36 2009 mikeodba [...] yahoo.com - Correspondence added

I have the same problem, in 2009, with ActiveState Perl 5.8.5 build 822, and DBD::DB2 v1.3, and UDB-developer-edition 9.1 fixpack 6, and Visual-C++ 2003 Standard fixpack 1, on Windows-XP-Pro-service-pack-3. However, I notice that if I install the module (regardless of nmake test failing), then the "test.pl" file supplied with DBD:DB2 runs all 5 tests successfully. Any information from IBM on this?

Wed Feb 11 16:28:53 2009 opendev [...] us.ibm.com - Correspondence added

On Mon Feb 09 03:26:36 2009, mor wrote: Show quoted text

> I have the same problem, in 2009, with ActiveState Perl 5.8.5 build 822, > and DBD::DB2 v1.3, and UDB-developer-edition 9.1 fixpack 6, and > Visual-C++ 2003 Standard fixpack 1, on Windows-XP-Pro-service-pack-3. > > However, I notice that if I install the module (regardless of nmake test > failing), then the "test.pl" file supplied with DBD:DB2 runs all 5 tests > successfully. > > Any information from IBM on this? >

Hi Thanks for Reporting this bug. I was able to reproduce this and seems some problem with the Makefile. I would try to fix this for the next release. However, you can safely ignore the nmake test and go ahead with the install. The SQL_PARAM_INPUT_OUTPUT would work just fine. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Thu Feb 12 08:27:45 2009 mikeodba [...] yahoo.com - Correspondence added

Thank you for the reply confirming that IBM recreated the symptom. I confirm that the module appears to run OK in 32bit mode with ActiveState Perl 5.8.8 Build 622 on Win-XPPro SP3 when built with MS VC++ 2003 SP1, and using IBM DB2 UDB v9.1 SP6. --Mike On Wed Feb 11 16:28:53 2009, IBMTORDB2 wrote: Show quoted text

> On Mon Feb 09 03:26:36 2009, mor wrote:

> > I have the same problem, in 2009, with ActiveState Perl 5.8.5 build 822, > > and DBD::DB2 v1.3, and UDB-developer-edition 9.1 fixpack 6, and > > Visual-C++ 2003 Standard fixpack 1, on Windows-XP-Pro-service-pack-3. > > > > However, I notice that if I install the module (regardless of nmake test > > failing), then the "test.pl" file supplied with DBD:DB2 runs all 5 tests > > successfully. > > > > Any information from IBM on this? > >

> > Hi > > Thanks for Reporting this bug. I was able to reproduce this and seems > some problem with the Makefile. I would try to fix this for the next > release. However, you can safely ignore the nmake test and go ahead with > the install. The SQL_PARAM_INPUT_OUTPUT would work just fine.

Sat Mar 07 11:10:24 2009 opendev [...] us.ibm.com - Taken

Sat Mar 07 11:12:03 2009 opendev [...] us.ibm.com - Correspondence added

Thanks for confirming this. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Sat Mar 07 11:12:04 2009 opendev [...] us.ibm.com - Status changed from 'open' to 'resolved'

Bug #12081 for DBD-DB2: SQL_PARAM_INPUT_OUTPUT not defined