tableBASE command categories by TSR access

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.

Table 66. tableBASE commands categorized by direct TSR access

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

Table 67. tableBASE commands categorized by linked VTS-TSR access

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