Database		Table of Contents

1 Introduction	Overview Keys Defining Variables Variable Formats Variable Quality Control Variable Labels
2 Schema	Format of Commands Order of Commands Example Record Specification CREATE DATABASE CONNECT DATABASE DISCONNECT DATABASE SET DATABASE PASSWORD SECURITY PURGE SIR FILE DELETE SCHEMA CASE ID COMMON SECURITY COMMON VARS DOCUMENT 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 SEQUENCE CHECK TIME VARS VALID VALUES VALUE LABELS VARIABLE LIST VAR LABELS VAR RANGES VAR SECURITY CREATE DBINDEX SIR SCHEMA LIST WRITE SCHEMA
3 Schema Modification	Modifying Data Types Dynamic Restructuring Database Restructure MODIFY SCHEMA 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 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