UDB calling mainframe SP Problem ?

[login to unmask email]

UDB calling mainframe SP Problem ?
Yes, again on a different server with three (guess) more fixpacks, only one
is being returned using the same code.

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



"Sinha, Abhijit"
<[login to unmask email] To: [login to unmask email]
.COM> cc:
Sent by: DB2 Data Subject: Re: UDB calling mainframe SP Problem
Base Discussion
List
<[login to unmask email]
ORG>


01/07/2004 11:41
AM
Please respond to
DB2 Database
Discussion list
at IDUG






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

---------------------------------------------------------------------------------
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