How do I use Result set returned from SP to calling program?

DB2Hero · #1 (**permalink**) 04-06-09, 15:10

Hi.

I am new to programming with DB2. I need to return a result set to the calling program but I do not know how to declare the locators to point to the
result set returned by the SP. I declared the cursor as WITH RETURN.

I have been reading the SQL reference book but it does not have an example to initialize the locators. It jiust said to DESCRIBE the SP the associate the LOCATORS. The example shows:

ASSOCIATE RESULT SET LOCATORS (:RS1) WITH PROCEDURE proc_name

What goes into the host variable RS1?

Any help will be much appreciated. thanks!