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