Home Starting Environment DBMS VisualPQL Procedures SQL Forms Host/API Index Database Contents

1 Introduction	Overview Keys Defining Variables Variable Formats Variable Quality Control Variable Label
2 Schema	Modifying Database Definitions Format of Commands Order of Commands Example Record Specification CREATE DATABASE CONNECT DATABASE DISCONNECT DATABASE SET DATABASE JOURNAL ON|OFF PASSWORD SECURITY PURGE SIR FILE DELETE SCHEMA CASE ID COMMON SECURITY COMMON VARS DATA FILES DATABASE LABEL DOCUMENT ENCRYPT MAX INPUT COLS MAX KEY SIZE MAX REC COUNT MAX REC TYPES N OF CASES N OF RECORDS READ SECURITY RECS PER CASE RECTYPE COLS SYSTEM SECURITY TEMP VARS WRITE SECURITY ACCEPT REC IF CAT VARS CHARACTER COMPUTE CONTROL VARS DATA LIST DATE VARS DOCUMENT END SCHEMA IF INPUT FORMAT INTEGER KEY FIELDS MAX REC COUNT MISSING VALUES OBSERVATION VARS REAL REC SECURITY RECODE RECORD SCHEMA REJECT REC IF SCALED VARS STANDARD SCHEMA STANDARD VARS TIME VARS VALID VALUES VALUE LABELS VARIABLE LIST VAR DOC VAR LABEL VAR RANGES VAR SECURITY CREATE DBINDEX SIR SCHEMA LIST WRITE SCHEMA
3 Schema Modification	Database Restructure DELETE SCHEMA
4 Data	Batch Data Input Specifications ADD REC EVICT REC READ INPUT DATA REPLACE REC UPDATE REC SIR FILE DUMP SIR FILE LIST SIR SPREADSHEET
5 Backup	IMPORT EXPORT SIR SUBSET UNLOAD FILE UPLOAD ITEMIZE FILE LIST STATS JOURNAL RESTORE JOURNAL ROLLBACK VERIFY FILE DOWNLOAD SIR MERGE RELOAD FILE
6 Tabfiles and Tables	CONNECT TABFILE CREATE TABFILE CREATE INDEX VERIFY TABFILE
7 Tuning and Efficiency	Disk Space Processing Efficiency Efficient Batch Processing Database Internal Structure Block Organisation Loading Factor Size Estimating