Yes. The sql works fine against the DB directly. It's a stored procedure with output variables. I can run the contents of the stored proc within my perl code, but not the proc itself. I'm wondering if it's a driver issue.
Peter W Schwartz Vice-President IB Technology - Prime Brokerage / JP Morgan Chase (973) 793-7407 _____ From: [email protected] [mailto:[email protected]] On Behalf Of Paul Rogers Sent: Wednesday, May 06, 2009 9:18 PM To: [email protected] Subject: RE: Win32::ODBC Have you attempted to execute this SQL code in DB2 prior? In other words skip the perl middleman altogether and see if it's something with your SQL statement. Paul --- From: [email protected] [mailto:[email protected]] On Behalf Of Schwartz, Peter (JPMC) Sent: Wednesday, May 06, 2009 5:45 PM To: Paul Rogers; [email protected] Subject: RE: Win32::ODBC Nope. The results are the same error. Could it have to do with the stored procedure having output variables? Peter W Schwartz Vice-President IB Technology - Prime Brokerage / JP Morgan Chase This email is confidential and subject to important disclaimers and conditions including on offers for the purchase or sale of securities, accuracy and completeness of information, viruses, confidentiality, legal privilege, and legal entity disclaimers, available at http://www.jpmorgan.com/pages/disclosures/email.
_______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
