Previous Topic: Using the Standard URT Selection LogicNext Topic: Multiple URT Mode

Using Exit Programs › URT Selection (DCCTFPR) › Using the Standard URT Selection Logic › SQL Requests

SQL Requests

If you have multiple URTs defined for use with SQL requests, you may have only one open at a time. CA Datacom CICS Services uses this open SQL URT to satisfy any SQL request to CA Datacom/DB. If there is no SQL URT open, the requesting application receives a 36 return code (192 internal return code). CA Datacom CICS Services does not open an AUTO URT for an SQL request.

CA Datacom CICS Services does not support a global (or non-global) URT for the SQL URT. That is to say, the SQL URT must point to the default MUF.