TBDRIVER (DK1TDRV) is the tableBASE driver command processor for Batch/TSO. DK1TDRV can be invoked in a batch job (see JCL for DK1TDRV), or interactively through the TSO CLIST TBDR, or the tablesONLINE/ISPF menu. The TBDRIVER (DK1TDRV) program accepts tableBASE-like commands from a terminal or a file and invokes tableBASE to execute them. TBDRIVER also has additional commands (referred to as macros) created to make long tasks easier such as PRINT TABLE (PR).
Command name |
Format / Description |
||||||||
---|---|---|---|---|---|---|---|---|---|
AB12 |
AB |
||||||||
Abend with 0C7 (Used to force a TBDRIVER dump) |
|||||||||
AL |
AL,ddname,DSNAME,disp |
||||||||
Allocate an existing library
|
|||||||||
AR,tablename |
|||||||||
Open base table and invoke all associated alternate indexes. |
|||||||||
BN |
BN |
||||||||
Display installation’s banner and display tableBASE version |
|||||||||
CA |
CA,alttablename,datatable,org,method,keycount,keyloc,keysize |
||||||||
Create Alternate Index definition
|
|||||||||
CD14
|
CD,tablename,org,method,type,smc,rpwsd,wpswd,rowsize, keysize,keyloc,rowestimate,numgens,expandfactor, lowdensity,hidensity,viewversion,viewname,comment,locklatch |
||||||||
Change table definition
|
|||||||||
CG |
CG,tablename,wpswd,gennumber |
||||||||
Change number of table generations retained in library |
|||||||||
CL14 |
CL,tablename,locklatch |
||||||||
Close table |
|||||||||
CN |
CN,tablename,newtablename,locklatch |
||||||||
Change table name in TSR
|
|||||||||
CS |
CS,aweot |
||||||||
Change status switches See the “Change Status (CS)” command in Chapter 3 of the tableBASE Programming Guide for a full description of status switches |
|||||||||
DC |
DC,tablename,count,locklatch |
||||||||
Delete row by count |
|||||||||
DE |
DE |
||||||||
Disengage libraries (Close all library files) |
|||||||||
DG |
DG,tablename,wpswd,gennumber |
||||||||
Delete a table generation
|
|||||||||
DK |
DK,tablename,key,rowlengthoverride,locklatch |
||||||||
Delete row by key
|
|||||||||
DL |
DL,ddname |
||||||||
Define library
|
|||||||||
DR12 |
DR,ddname |
||||||||
List next 10 library entries (uses NX and GD) (For interactive, hit <RETURN>; for batch, enter a blank line.) |
|||||||||
DT |
DT,tablename,org,method,type,smc,rpswd,wpswd,rowsize,keysize, keyloc,rowestimate,numgens,expandfactor,lowdensity,highdensity, viewversion,viewname,comment,locklatch |
||||||||
Define table |
|||||||||
DV14 |
DV,tablename,DDNAME,locklatch |
||||||||
Divert table to a library where table does not exist |
|||||||||
DW14 |
DW,tablename,DDNAME,locklatch |
||||||||
Divert table to a library where table exists |
|||||||||
FC |
FC,tablename,count,rowlengthoverride |
||||||||
Fetch row by count |
|||||||||
FG |
FG,tablename,KEY,rowlengthoverride,partialkeylength FG,tablename,PARTIALKEY*,rowlengthoverride FG,tablename,*,rowlengthoverride |
||||||||
Fetch row using generic key
|
|||||||||
FK |
FK,tablename,key,rowlengthoverride |
||||||||
Fetch row by key
|
|||||||||
FN |
FN,tablename,key,rowlengthoverride |
||||||||
Fetch row or next highest (lowest) by key
|
|||||||||
GD,tablename,gennumber |
|||||||||
Get table definition |
|||||||||
GF |
GF,tablename,rowlengthoverride |
||||||||
Get first table row |
|||||||||
GL |
GL,tablename,rowlengthoverride |
||||||||
Get last table row |
|||||||||
GN |
GN,tablename,rowlengthoverride |
||||||||
Get next table row |
|||||||||
GP |
GP,tablename,rowlengthoverride |
||||||||
Get previous table row |
|||||||||
HP12 |
|
||||||||
Help about command(s) |
|||||||||
IA13 |
IA,alttablename,datatable,org,method,keycount,keyloc,keysize, locklatch |
||||||||
Invoke Alternate Index
|
|||||||||
IC |
IC,tablename,count,rowdata,rowlengthoverride,locklatch |
||||||||
Insert row by count
|
|||||||||
IK |
IK,tablename,rowdata,rowlengthoverride,locklatch |
||||||||
Insert row by key
|
|||||||||
LD16 |
LD,tablename,ddname,tablenamemask,dirtype |
||||||||
List directory (Create a table from directory contents)
|
|||||||||
LG12 |
LG,tablename,key,rowlengthoverride,partialkeylength LG,tablename,partialkey*,rowlengthoverride LG,tablename,*,rowlengthoverride |
||||||||
List rows using generic key
|
|||||||||
LL |
LL |
||||||||
List library search order |
|||||||||
LS |
LS |
||||||||
List status switches See the “Change Status (CS)” command in Chapter 3 of the tableBASE Programming Guide for a full description of status switches |
|||||||||
LT14 |
LT,howmany,startfrom |
||||||||
List tables currently open in the TSR
|
|||||||||
LV |
LV |
||||||||
List VTS settings |
|||||||||
ML |
ML,LIB1,LIB2,,LIB10 |
||||||||
Modify library search order
|
|||||||||
MT |
MT,tablename,locklatch |
||||||||
Empty table (erase contents in TSR) |
|||||||||
NX |
NX,tablename,ddname,s |
||||||||
Return next tablename in library
|
|||||||||
OA,tablename |
|||||||||
Open Any. If table is a base table, open table for read. If table is an alternate, open base table and invoke the alternate. Supports initial loading of tables in VTS-TSRs. |
|||||||||
OR13 |
OR,tablename,password,gennumber,indiropen |
||||||||
Open table for read
|
|||||||||
OW13 |
OW,tablename,wpswd,gennumber,indiropen,locklatch |
||||||||
Open table for write
|
|||||||||
PR,tablename,startrow,endrow,rowlengthoverride PR,tablename,*,,rowlengthoverride PR,tablename,startrow,*,rowlengthoverride |
|||||||||
List next 10 table rows (default command)
|
|||||||||
QR12 |
QR,tablename,password,gennumber,indiropen |
||||||||
Open View for read
|
|||||||||
QW12 |
QW,tablename,wpswd,gennumber,indiropen,locklatch |
||||||||
Open View for write
|
|||||||||
RC |
RC,tablename,count,rowdata,rowlengthoverride,locklatch |
||||||||
Replace row by count
|
|||||||||
RF14 |
RF,tablename |
||||||||
Refresh a table that is opened for read in TSR (or VTS-TSR)
|
|||||||||
RK |
RK,tablename,rowdata,rowlengthoverride,locklatch |
||||||||
Replace row by key
|
|||||||||
RL14 |
RL,tablename,locklatch |
||||||||
Release table (Change open status from write to read) |
|||||||||
RN |
RN,tablename,newtablename,wpswd |
||||||||
Rename table in library
|
|||||||||
SI |
SI,criterion |
||||||||
Set indirect table search criterion |
|||||||||
SK |
SK,tablename,key |
||||||||
Search row by Key
|
|||||||||
SP12 |
|
||||||||
SS12 |
|
||||||||
Set VTS name (TB-SUBSYSTEM) in TB-PARM |
|||||||||
ST14 |
ST,tablename,locklatch |
||||||||
Store table |
|||||||||
UL |
UL,DDNAME |
||||||||
Unallocate a library |
|||||||||
VE12 |
VE |
||||||||
Show version of DK1TDRV. |
|||||||||
VS12 |
SS,VTSName |
||||||||
Synonym for SS – Note that this is a different command from the tableBASE VS command. |
|||||||||
XT |
XT,tablename,wpswd |
||||||||
Eliminate all generations of a table from library |
An asterisk (*) may be used as a wildcard character in the table name. An asterisk can only be used on its own or at the end of a string. A standalone asterisk denotes all table names. An asterisk at the end of a string denotes zero or more characters. Any characters after the first asterisk will be ignored. For example:
OR,* opens all tables
OR,B* opens all tables beginning with the letter B
OR,*S* opens all tables; characters after the first asterisk are ignored
OR,F*T* opens all tables beginning with the letter F.
The input command is processed against all the tables matching the table name mask. For example, when the close table (CL) command is issued to table HOWARD* the command closes all the tables and alternates with HOWARD in the first six characters of the name. While wildcard commands are in progress, libraries in the library search list (LIB-LIST) should not be updated, otherwise results returned will be unpredictable.