Table services
Services that Affect an Entire Table - TBCLOSE
- Closes a table and saves a permanent copy if the table was opened.
- TBCREATE
- Creates a new table and opens it for processing.
- TBEND
- Closes a table without saving it.
- TBERASE
- Deletes a permanent table from the table output file.
- TBOPEN
- Opens an existing permanent table for processing.
- TBQUERY
- Obtains information about a table.
- TBSAVE
- Saves a permanent copy of a table without closing it.
- TBSORT
- Sorts a table.
- TBSTATS
- Provides access to statistics for a table.
Services that Affect Table Rows
- TBADD
- Adds a new row to the table.
- TBBOTTOM
- Sets CRP to the last row and retrieves the row.
- TBDELETE
- Deletes a row from the table.
- TBEXIST
- Tests for the existence of a row (by key).
- TBGET
- Retrieves a row from the table.
- TBMOD
- Updates an existing row in the table. Otherwise, adds a new row
to the table.
- TBPUT
- Updates a row in the table if it exists and if the keys match.
- TBSARG
- Establishes a search argument for use with TBSCAN. Can also be
used in conjunction with TBDISPL.
- TBSCAN
- Searches a table for a row that matches a list of argument variables,
and retrieves the row.
- TBSKIP
- Moves the CRP forward or backward by a specified number of rows,
and then retrieves the row at which the CRP is positioned.
- TBTOP
- Sets CRP to TOP, ahead of the first row.
- TBVCLEAR
- Sets to null dialog variables that correspond to variables in
the table.