retrieving stored procedure result sets with embedded SQL

[Frank Swarbrick]

I've been trying the following in DB2/LUW since version 8.2 (9.1 and now
9.5) and I've never been able to get this to work. (Not this exact SP,
which didn't exist prior to version 9, but just any SP that returns result
sets.)

Take the following COBOL program:

IDENTIFICATION DIVISION.
PROGRAM-ID. DBLOAD.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
SPECIAL-NAMES.
CONSOLE IS CONSOLE

[Serge Rielau]

Frank Swarbrick wrote:

I've been trying the following in DB2/LUW since version 8.2 (9.1 and now
9.5) and I've never been able to get this to work. (Not this exact SP,
which didn't exist prior to version 9, but just any SP that returns result
sets.)

Have you ever considered opening a PMR?
What development doesn't know, development can't fix....
(I do not count as development btw)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Frank Swarbrick]

>>On 1/23/2008 at 1:06 PM, in message
<5v*************@mid.individual.net>,
Serge Rielau<sr*****@ca.ibm.comwrote:

Frank Swarbrick wrote:

>I've been trying the following in DB2/LUW since version 8.2 (9.1 and now
9.5) and I've never been able to get this to work. (Not this exact SP,
which didn't exist prior to version 9, but just any SP that returns

result

>sets.)

Have you ever considered opening a PMR?
What development doesn't know, development can't fix....
(I do not count as development btw)

Yes, but I was first wondering if anyone had every actually made something
like this work.

(If I could open a PMR myself I'd do it. When I have to get someone else
involved I prefer to do other things first.)

Frank