The parse exit routine is similar to a request exit. It allows a customer-written exit routine to alter SQL text received from the DB2 UDB Option for CICS clients before the SQL statements are passed to DB2 UDB. By altering the SQL text, your routine can customize SQL commands for a particular database or a specific purpose.
There are several potential uses for this option. For example, you can use a parse exit routine to limit the scope of client access by restricting client SQL statements to select statements only. Also, you can use the parse exit routine to modify the qualifiers for DB2 object names to provide additional security restraints on accessing mainframe data.
This section explains how to write a parse exit routine. It is organized around the following tasks, which are performed by the programmer:
A section containing the definitions for the fields that pass values to and from your routine is included in “CICS common area fields”.
