The second command, DBURTBL, generates an entry for a CA Datacom/DB table you are accessing in the submitted requests. Enter the DBURTBL function multiple times between DBURSTR and DBUREND to generate a User Requirements Table with access to multiple tables.
►►─ DBURTBL DBID=n,TBLNAM=t ─┬─────────────────────────┬──────────────────────► └─ ,AUTODXC= ─┬─ YES ◄ ─┬─┘ └─ NO ────┘ ►─┬───────────────────────┬─┬───────────────────────┬────────────────────────► └─ ,BYOPEN= ─┬─ NO ◄ ─┬─┘ └─ ,ELMCHG= ─┬─ NO ◄ ─┬─┘ └─ YES ──┘ └─ YES ──┘ ►─┬────────────────────────┬─┬──────────────────────┬────────────────────────► └─ ,GBMAXR= ─┬─ 255 ◄ ─┬─┘ └─ ,GETBLK= ─┬─ 0 ◄ ─┬─┘ └─ x ─────┘ └─ y ───┘ ►─┬───────────────────────┬─┬────────────────────────┬───────────────────────► └─ ,SEQBUFS= ─┬─ 0 ◄ ─┬─┘ └─ ,SYNONYM= ─┬─ NO ◄ ─┬─┘ └─ z ───┘ └─ YES ──┘ ►─┬───────────────────────┬──────────────────────────────────────────────────►◄ └─ ,UPDATE= ─┬─ NO ◄ ─┬─┘ └─ YES ──┘
Command
Generates an entry for a CA Datacom/DB table you are accessing in the submitted requests.
Required Keywords
Specifies the identifier of the database being accessed.
DATACOM-ID of the database
(No default)
Specifies the DATACOM-NAME of a table in the database specified in the DBID= parameter.
DATACOM-NAME of a table in the database
(No default)
Optional Keywords
Specifies whether GETIT, GSETL, GETPS, RDUNX, RDUNK, RDUBR, and RDUNE commands automatically drop exclusive control established by any previous command from the same request area.
NO or YES
YES
Specifies whether the table defined in this function is to be bypassed during open and close processing.
NO or YES
NO
Specifies whether the element list for sequential operations can be changed between GETIT or GETPS commands. Specifying NO improves execution time because verification of the element list is not required between commands. If you assign a value other than zero to GETBLK=, the value for ELMCHG= must be NO.
NO or YES
NO
Specifies the maximum number of entries allowed in the blocked GETIT buffer. If UPDATE=YES is specified, the value of this parameter cannot exceed the value specified for the MUF startup option EXCTLNO (see the CA Datacom/DB Database and System Administration Guide).
An integer value from 2 through 255
255
(MUF only.) Specifies the buffer size used for blocking GETIT or GETPS commands. The buffer must be large enough to contain at least two request areas and two work areas. If you assign a value other than zero to GETBLK=, the value for ELMCHG= must be NO, and the value for AUTODXC= must be YES.
The integer value 0, or an integer value from 4096 through 61440
0
Specifies the number of data buffers the program can use for single block or multiple block read-ahead sequential processing. Use only positive numbers.
An integer value of 0 or from 2 through 128
0
Specifies whether other tables with the same name are included in other DBURTBL entries in this User Requirements Table generation. If you enter YES, all requests made for this table must include the database identifier in the request area.
NO or YES
NO
Specifies update authorization. Although you cannot use maintenance commands with the test utility, UPDATE=YES is required if you intend to test commands that acquire exclusive control.
NO or YES
NO
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|