tableBASE Commands

The tableBASE software has five command groups that perform the functions required to maintain and access tables, they are:

  • Retrieval Commands—provide the facility to retrieve entries from a table by key or by entry count
  • Update Commands—allow for modification of the contents of the table either by key or by entry count
  • Table Control Commands—provide the facility to open, close, store, define tables, and the ability to change the definition of individual table generations
  • Directory Maintenance Commands—provide the facility to alter information in the directory about individual tables
  • System Control Commands—specify how tableBASE handles error conditions, contention situations, and the library search order
Table 53. Retrieval Commands

Command   

Description

SK

Search by Key

FK

Fetch by Key

FC

Fetch by Count

FG

Fetch Generic

FN

Fetch Next by key

GF   

Get First

GL   

Get Last

GN

Get Next

GP

Get Previous

Table 54. Update Commands

Command   

Description

DK

Delete by Key

IK

Insert by Key

RK

Replace by Key

DC

Delete by Count

IC

Insert by Count

RC

Replace by Count

MT   

eMpty Table

Table 55. Table Control Commands

Command   

Description

OR

Open table for Read

OW   

Open table for Write

CL   

Close Table

ST   

Store Table

RL   

ReLease table (previously opened for write)

DT

Define Table

CD   

Change table Definition

GD

Get a table Definition

DV   

DiVert table to a library where it doesn’t exist

DW

Divert table to a library where it does exist

CN   

Change Name (in region)

DU

DUmp table contents

CA   

Create Alternate table definition

IA   

Invoke Alternate table definition

Table 56. Directory Maintenance Commands

Command   

Description

DG   

Delete Generation

XT

eliminate Table (on library)

CG

Change Generations to be kept

RN

ReName table (on library)

NX

get NeXt table name

DL

Define new tableBASE Library

LD

List Directory

Table 57. System Control Commands

Command   

Description

ML   

Modify Library search order

LL

List Libraries in use

CS   

Change tableBASE processing Switches

LS

List tableBASE processing Switches

LT

List open Tables

BN

BaNner retrieval

SI   

Set Indirect

DE

DisEngage library

AL

Allocate Library

UL   

Un-allocate Library

VS

set Virtual System