CA Datacom Datadictionary › Multiple Databases Definitions › User Requirements Table Requirements

User Requirements Table Requirements

CA Datacom/AD User Requirements Tables (URTs) are required for each program that will access the database. The purpose of the URT is to define which tables in which databases the program will require access, whether the access is R/O or R/W, sequential or random access, SQL or native call, and so forth. URTs are assembled and link edited then included with the executable program or dynamically called at execution.

URTs have three formats:

• Batch
• CICS
• SQL

For batch, there can be several URTs. Often, there is one URT per program.

For CICS, the URT is named DBURTnnnn where nnnn is the database ID. A CICS PPT entry is required for this name. Some CA using products dynamically build the URT, and for those products this step is not necessary.

SQL URTs do not contain specific tables and DBIDs hardcoded in them. These requirements are determined from the items found in the SQL statements and are dynamically built into the URT at execution time from the PLAN information that is stored in the DDD database.

URTs are generally provided as part of the CA using product post-installation process. For more information about installation jobs that compile and link edit the URTs, see the CA using product documentation.