Information for the Database Administrator

User Requirements Table (URT)

A User Requirements Table (URT) is a load module that is required by CA-Datacom/DB. The URT is loaded by the interface view engine and passed to CA-Datacom/DB when a table is opened. It contains information about how the table is to be accessed. Various values in the URT, such as number and size of buffers, can affect performance.

You can specify a URT in various ways; these are given below. The interface view engine looks for a URT in the order of the situations described. Note that a specific URT always overrides a generic or a default URT.

You can designate a specific URT with a data set option when you run a SAS program. For details, see the DDBURT= data set option in Data Set Options.
You can designate a specific URT by saving its name in the view descriptor.

Note: ACCESS=SEQ is not used. Use ACCESS=RANSEQ. The engine never alters the type of ACCESS that you specify in a URT. Also, AUTODXC=NO is not used in a URT. [cautionend]

For more information about URTs, see the appropriate CA-Datacom/DB documentation.

Version 5 URTs work with the Version 8 and higher interface with the following exceptions:

Version 5 URTs probably have the UPDATE= parameter set to NO. This will fail if you open a view descriptor for update in Version 8 and higher. For security reasons, the interface view engine does not upgrade UPDATE=NO to UPDATE=YES. However, the interface view engine does downgrade UPDATE=YES to UPDATE=NO if appropriate in order to prevent possible problems.
The ACCESS=SEQ parameter in a URT is not supported beginning in Version 8 and higher, because additional commands are required to support the engine specifications. Change any existing URTs to ACCESS=RANSEQ.
The AUTODXC=NO parameter will fail beginning in Version 8 and higher. With the SAS locking requests, it tends to exceed CA-Datacom/DB limits on the number of records locked.

Top of Page