1) Currently in my cobol+Db2 pgms, we are using simple sql statments, in this case coding stored procedures are suggestable are not.
ex : EXEC SQL
SELECT DISTINCT CURRENT TIMESTAMP
SET DESCRIPTION_TX = :DESCRIPTION-TX
WHERE APPLICATION_ID = :APPLICATION-ID
AND PARAMETER_ID = :PARAMETER-ID
for the above statements coding a stored procedure are suggestable
2) Can we replace with a stored procedure instead of a cursor in cobol+DB2 pgm. which is most efficient to use. in this
kindly let me know how to receive more than one result from SP to calling cobol pgm.