Variable List

FROM

PATHS

Joins

Alias

Keywords

FORMAT

Column References

Column Formats

GROUP BY

ON

ORDER BY

OUTER

UNION

WHERE

Subqueries

 

Headings and Footings

Grouping and Totalling

SUBTOTAL

Break and Subtotal Columns

TOTAL

PRINT and WRITE

 

CONNECT TABFILE

CREATE ATTRIBUTE

CREATE SYNONYM

DISCONNECT

DROP

END

GET

Execution Statement

Database Parameters

Tabfile Parameters

Environment Parameters

 

List of connected databases

Database structure

Create tabfile

Connect tabfile

List of connected tabfiles

Tabfile structure

Indexes

Create index

Select

From

What

Where

Order by

Group by

Verify tabfile

Export tabfile

Backup tabfile

Restore tabfile

 

INSERT INTO

UPDATE

 

Column Data types

Column Options

CREATE INDEX

Permissions

GRANT

REVOKE

EXPORT

VERIFY

BACKUP TABFILE

RESTORE TABFILE

DISPLAY JOURNAL

 

$DBDOC - Database Documentation

$DBSTATS - Database Statistics

$INDEX - Tabfile Index Definitions

$INDEXCOL - Tabfile Index Column Definitions

$PASSWORD - Group User Names

$REC - Database Record Schema

$SECURITY - Tabfile and Table Permissions

$SORTID - Sort Id Variables

$TAB - Tables

$TFSTATS - Tabfile Statistics

$TRANGE - Tabfile Column Ranges

$VALLABEL - Database Value Labels

$VALUE_LABEL - Tabfile Value Labels

$VALVALUE - Database Valid Values

$VAR - Database Variables

$VARLABEL - Database Variable Labels