Command summary

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