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 URT 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.
For more information
about URTs, see the appropriate CA-Datacom/DB documentation.
SAS 5 URTs work with
the SAS 8 and higher interface with the following exceptions:
-
SAS 5 URTs probably have the UPDATE= parameter set to NO. This fails if you open a
view descriptor for update in SAS 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 SAS 8 and higher,
because additional commands are required
to support the engine specifications. Change any existing URTs to ACCESS=RANSEQ.
-
The AUTODXC=NO parameter fails
beginning in SAS 8 and higher. With the SAS locking requests, it tends
to exceed CA-Datacom/DB limits on the number of records locked.