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