UDB calling mainframe SP Problem

[login to unmask email]

UDB calling mainframe SP Problem
We have a problem that on one server there is a JDBC prepared statement
call to a mainframe (OS/390 MVS) COBOL SP returns only one result set where
there are actually eight setup. The UDB version on this Unix box is 7.2.4.

The same code on a different Unix box with UDB version 7.2.7 is only
returning one result set. Is there something in the UDB setup that might
only allow one result set. Either box is connecting to the same mainframe
box/SP.

Dean J. Burchill
248-576-8319
(8) 776-8319

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Abhijit Sinha

Re: UDB calling mainframe SP Problem
(in response to DB46@DAIMLERCHRYSLER.COM)
After getting the first resultset, are you issuing: pstmt.getMoreResults()
and then rs = pstmt.getResultSet() , where pstmt is the PreparedStatement
object instance and rs is the ResultSet object instance ?

Abhijit

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: Wednesday, January 07, 2004 11:25 AM
To: [login to unmask email]
Subject: UDB calling mainframe SP Problem


We have a problem that on one server there is a JDBC prepared statement
call to a mainframe (OS/390 MVS) COBOL SP returns only one result set where
there are actually eight setup. The UDB version on this Unix box is 7.2.4.

The same code on a different Unix box with UDB version 7.2.7 is only
returning one result set. Is there something in the UDB setup that might
only allow one result set. Either box is connecting to the same mainframe
box/SP.

Dean J. Burchill
248-576-8319
(8) 776-8319

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can
be reached at [login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm