Command summary

Table 94 is a summary of the commands available in TBEXEC, listed in alphabetical order. Subsequent sections provide details of their use.

Table 94. TBEXEC commands

Command

Description

Parameters

CHANGE

Change table characteristics.

Option 1: Change the definition of a table.

EXPFACTR, GEN, ISZ/RSZ, KSZ, KLOC, LIB, LOWERDEN, MAXGEN, MTHD, ORG, INDEX, PSWD, RPSWD, SMC, TBL†, TTYPE, UCOMMENT, UPPERDEN, WPSWD

Option 2: Change an Alternate Index definition.

ALT†, BASENAME, KSZ, KLOC, LIB, MTHD, ORG

CLEAR

Clear or empty a table.

GEN, LIB, PSWD, TBL†, TTYPE

COPY

Copy a table, table generation, or a library:

Option 1: Copy a table generation.

GEN, LIB, NEWID, NEWNAME, PSWD, REPLACE, TBL†, TO†, TTYPE, WPSWD

Option 2: Copy all generations of a table.

ALLGEN†, NEWID, NEWNAME, PSWD, REPLACE, TBL†, TO†, TTYPE, WPSWD

Option 3: Copy a tableBASE Library.

FROM†, NEWID, REPLACE, TO† EXCLUDE, EXCLFILE, TTYPE

DEFINE

Initialize a new library, define a new table, define an Alternate Index:

Option 1: Initialize a new tableBASE Library.

NEWLIB†

Option 2: Define a new table.

EST, EXPACTR, ISZ/RSZ, KSZ, KLOC, LIB, LOWERDEN, MAXGEN, MTHD, ORG, INDEX, PSWD, RPSWD, SMC, TBL†, TTYPE, UCOMMENT, UPPERDEN, WPSWD

Option 3: Create an Alternate Index definition.

ALT†, BASENAME†, KSZ, KLOC, LIB, MTHD, ORG

DELETE

Delete one or more table generations:

Option 1: Delete one generation of a table.

GEN, LIB, PSWD, TBL†, TTYPE

Option 2: Delete all generations of a table.

ALLGEN†, LIB, PSWD, TBL†, TTYPE

EXPAND

Expand / increase size of a tableBASE library.

LIB, NEWLIB†

EXPORT

Convert a tableBASE library or table to a sequential dataset.

Option 1: Convert a library or table to a sequential dataset.

LIB†, PSWD, TO†

Option 2: Convert a table to a sequential dataset

LIB†, PSWD, TBL†, TO†, TTYPE

IMPORT

Copy an exported sequential dataset into a tableBASE library.

FROM†, LIB, REPLACE

LOAD

Load a table generation from a sequential dataset.

DUP, FROM†, GEN, LIB, PSWD, RECCOUNT, STARTBYT, STARTREC, TBL†, TTYPE

PRINT

Prints information about a directory, table generation, and/or table contents.

Option 1: List Directory.

DETAIL, LIB

Option 2: Print Table Information.

DEF†, LIB, TTYPE

Option 3: Print Table Contents.

BTYCOUNT, GEN, LIB, LINSIZ, PRNT, PSWD, RECCOUNT, STARTBYT, STARTREC, TBL†, TTYPE

RENAME

Rename table generations.

LIB, NEWNAME†, PSWD, TBL†, TTYPE

SET

Establishes default values for keywords.

LIB, LINSZ, PRNT, PSWD

UNLOAD

Write a specified table generation to a sequential dataset.

GEN, LIB, PSWD, RECCOUNT, STARTBYT, STARTREC, TBL†, TO†, TTYPE

UPDATE

Update a table from an input dataset.

GEN, LIB, PSWD, REMOVE*, TBL†, TTYPE, WITH*

† = required parameter; * = at least one of these parameters

Note:
  1. TBEXEC commands are specified in control statements read by TBEXEC from a file identified by the DDNAME CNTLCARD.
  2. A TBEXEC command sequence consists of a command and a list of parameters specified by keyword and value combinations terminated by a semicolon (;).
  3. Each command has the following appearance:

    COMMAND  KEYWORD1=VALUE KEYWORD2=VALUE;

    KEYWORD=VALUE is the representation of a keyword-value combination and may be repeated for each parameter of the command.

  4. Any input statement starting with an asterisk (*) in column one is treated as a comment.

The following rules apply to TBEXEC:

  1. Each command sequence must start on a new line.
  2. A command sequence must be terminated by a semicolon (;). Anything following a semicolon is ignored.
  3. The command and each keyword-value combination must be followed by at least one blank.
  4. Keyword-value combinations may appear in any order.
  5. Columns 73-80 of a statement are ignored.
  6. Blanks may occur freely, provided that they do not break up commands, keywords, or value fields.
  7. The character set for unquoted fields is limited to alphanumeric characters 0-9 and uppercase A-Z.
  8. Values that contain special characters must be enclosed in quotes (‘).

TBEXEC terminates when end of file is reached on the input CNTLCARD file.