i am writing a stored procedure in DB2 which returns a resultset with values from different tables.
i want to access this stored procedure.How do i do it?( DB 2 users cursors to get the resultset)
Also should the cursor be left in open state in DB stored procedure?. Should i have the resultset as outparameter or will be directly be assigned to resultset when i execute the stored procedure from
java application.