Previous Topic: Planning the User EnvironmentNext Topic: Assembling and Linking Each URT


Coding the URT Macros

The CICS region in which an online application is executing must have at least one URT available which can satisfy each request to CA Datacom/DB.

Online URT Macros

An online URT begins with a DBURSTR Start macro, includes one or more DBURTBL Entry macros (if not an SQL URT) and ends with a DBUREND End macro. The SQL URT must have at least one DBURTBL, and that one can have the bypass open option (BYPOPEN=YES in the DBURTBL macro) in it. The SQL URT is also composed of the DBURSTR and DBUREND macros. For non-SQL URTs, the Start macro passes its parameters to each included Entry macro.

Global URTs

Beginning with CA Datacom CICS Services r11, support was added for global URTs. A global URT is a URT from CA Datacom/DB r10 or higher that either has multiple MUFs support or DBID remapping support, that is to say, either the DBURSTR macro uses the SIDNAME= parameter or the DBURTBL macro uses the DBIDMUF= parameter.

In a multiple MUF environment, it is necessary to code the SIDNAME= parameter on the DBURSTR macro in order for the URT to request service from a MUF other than the default or first MUF defined by a DBCSID macro. Any URT can only reference one MUF.

Also beginning with CA Datacom CICS Services r11, support has been added for DBID remapping. If you want to use this feature, you must code the DBIDUSER= in the DBURTBL macro to match the DBID specified in the request and also code the DBIDMUF= parameter of the DBURTBL macro to specify the DBID that is actually passed to the MUF in the request. Following is an example:

        TITLE 'GLOBAL URT'
        PRINT GEN
        DBURSTR SIDNAME=DBSIDPR
        DBURTBL DBIDUSER=1,DBIDMUF=100,TBLNAM=PAY
        DBUREND SYSTEM=OS
        END

Note: For more information about defining URTs, see the CA Datacom/DB Database and System Administration Guide.