|
View previous topic :: View next topic
|
| Author |
Message |
suman_236
New User
Joined: 18 Nov 2005
Posts: 11
Location: Chennai
|
|
|
|
hi . . we are writing some Cobol/Db2 subroutines. The cursors in the subroutines are declared in the linkage section instead of Working storage section. The routines are tested and working fine. Do you see any problem with declaring the cursors in Linkage section?
Thanks for your replies! |
|
| Back to top |
|
 |
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008
Posts: 107
Location: New York
|
|
|
|
No Suman.
There will not be any issues.
CURSOR Declarations are something like a Working Storage Variable declaration. It is not an executable statement.
If you check the COBOL compile listing for the same, the CURSOR declaration will be commented. Usually SQL statements will be replaced with corresponding COBOL call during compilation. Only OPEN CURSOR statement is executable and not DECLARE Statement.
I have tested this with DB2 Stored procedure and it worked fine.
Suggestions are welcome. |
|
| Back to top |
|
|
|
|
