Control SQL cursor scoping within SQL procedures, triggers, and functions

Using the CLOSQLCSR option to create SQL code bodies that use *ENDMOD

From the developerWorks archives

Scott Forstie and Sue Romano

Date archived: January 13, 2017 | First published: March 27, 2007

A new i5/OS® SQL set option for use with DB2 enables better control of SQL cursor scoping. Learn about the new CLOSQLCSR option, why it is important, and how to use it. Also discover pointers to SQL procedures, triggers, and functions (PTFs) that you can use to run the new option.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=204456
ArticleTitle=Control SQL cursor scoping within SQL procedures, triggers, and functions
publish-date=03272007