tableBASE commands can further be classified into three categories based on what type of TSR access they require: (a) those that read from the TSR, (b) those that write to or update the TSR and (c) those that do not access the TSR at all.
These categories are especially useful when implementing applications for use with VTS Gate, since security restrictions may limit the type of access allowed on a VTS-TSR. In addition, a VTS-TSR can now have its generation number increased and tableBASE commands that actually access a VTS must have the field, START-TBUOW, in the COMMAND-AREA set in order to access the current generation of the VTS. For more information on START-TBUOW, please refer to 16. START-TBUOW (1 byte).
There are two methods in which a VTS-TSR can be accessed by a tableBASE command. A VTS can be accessed directly, in place of the local TSR, or indirectly, as a linked VTS. For more information on methods for accessing a VTS-TSR, please refer to The VTS User.
Table 66 classifies the TSR access category for each tableBASE command when either the local TSR or a VTS-TSR is being accessed directly.
Table 67 classifies the TSR access category for each tableBASE command when a VTS-TSR is being accessed as a linked VTS.
|
tableBASE command group |
Requires read access to TSR |
Requires write/update access to TSR |
Does not require any access to TSR |
|---|---|---|---|
|
Retrieval commands (SK, FK, FC, FG, FN, GF, GL, GN, GP) |
SK, FK, FC, FG, FN, GF, GL, GN, GP – if table is already open in TSR |
SK, FK, FC, FG, FN, GF, GL, GN, GP – if table is not open in TSR and the implicit open switch in the SWITCHES run-time option is on |
– |
|
Update commands (DK, IK, RK, DC, IC, RC, MT) |
– |
DK, IK, RK, DC, IC, RC, MT |
– |
|
Table Control commands (OR, OW, CL, RL, RF, ST, GD, DD, DT, CD, DV, DW, CN, DU, CA, IA) |
Only GD, DD without generation number, DU and CA |
OR, OW, CL, RL, RF, ST, DT, CD, DV, DW, CN, IA |
– |
|
Library maintenance commands (DG, XT, CG, RN, NX, LD, DL) |
DG, XT, CG, RN |
LD |
NX, DL |
|
System Control commands (ML, LL, CS, LS, LT, LV, BN, DE, AL, UL, SI, VS, VV, XX) |
LT, VS |
VV |
ML, LL, CS, LS, LV, BN, DE, AL, UL, SI, XX |
|
tableBASE command group |
Requires read access to linked VTS-TSR |
Requires write/update access to linked VTS-TSR |
Does not require any access to linked VTS-TSR |
|---|---|---|---|
|
Retrieval commands (SK, FK, FC, FG, FN, GF, GL, GN, GP) |
SK, FK, FC, FG, FN, GF, GL, GN, GP – if table is not open in local TSR and the implicit open switch in the SWITCHES run-time option is on |
– |
– |
|
Update commands (DK, IK, RK, DC, IC, RC, MT) |
– |
DK, IK, RK, DC, IC, RC, MT – userids with UPDATE access to the linked VTS will receive error 13-5 |
– |
|
Table Control commands (OR, OW, CL, RL, RF, ST, GD, DD, DT, CD, DV, DW, CN, DU, CA, IA) |
OR, DU, GD, DD – if table is not open in the local TSR |
OW, RL, RF, ST, CD, DV, DW, CN – userids with UPDATE access to the linked VTS will receive error 13-5 |
CL, DT, CA, IA – CA does not work with a linked VTS and will return error 40-4 – IA does not work if the base table is opened from a linked VTS and will return error 80-2 |
|
Library maintenance commands (DG, XT, CG, RN, NX, LD, DL) |
– |
– |
DG, XT, CG, RN, NX, LD, DL – DG, CG, RN, XT will return error 9-1 with a linked VTS – NX returns error 40-1 or 40-3 with a linked VTS – LD creates a temporary table with no rows for linked VTS |
|
System Control commands (ML, LL, CS, LS, LT, LV, BN, DE, AL, UL, SI, VS, VV, XX) |
VS |
– |
ML, LL, CS, LS, LT, LV, BN, DE, AL, UL, SI, VV, XX |