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
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.