|
View previous topic :: View next topic
|
| Author |
Message |
nkothako
Active User
Joined: 26 Nov 2008
Posts: 125
Location: chennai
|
|
|
|
1) Currently in my cobol+Db2 pgms, we are using simple sql statments, in this case coding stored procedures are suggestable are not.
| Code: |
ex : EXEC SQL
SELECT DISTINCT CURRENT TIMESTAMP
INTO :WS-CURR-TIMESTAMP
FROM WW_INDUSTRY
END-EXEC.
EXEC SQL
UPDATE WW_COMMIT_DATA
SET DESCRIPTION_TX = :DESCRIPTION-TX
WHERE APPLICATION_ID = :APPLICATION-ID
AND PARAMETER_ID = :PARAMETER-ID
END-EXEC. |
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. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
|
|
