Home page
Release Information
Reality on the Web
MultiValue Compatibility
Documentation Overview
Installation Guides
User's Reference
English Reference
About this Section
Contents
Introducing English
English Sentences
Dictionaries and Data Definition Items

Terminology Changes
Data Definition Item
Attribute 8 Codes
Attribute 7 Codes
File Specifier/Dynamic Q-pointer
Values and Value Strings

References
Conventions

Introduction to English
Overview
The Inquiry Language
The Dictionary

Summary of English Features

The English Sentence
Sentence Structure
Optional Clauses
Outline Syntax
Syntax Elements
Macros
USING Clause
Options
Print Limiters
Example of an English Sentence

General Rules for English Sentences
Entering a Sentence
Line Continuation
Action by the System
Generating English Reports
Reserved Words and Symbols

English Commands
Frequently Used Commands
Other Commands
Modifying Files
Generating Implicit Lists

File Specifiers and Modifiers
File Specifiers
File Modifiers
Syntax
Syntax Elements
Default to Master Dictionary
Example

Item Lists
Types of Item List
Explicit Item-id List
Implicit Item-id List
Item-id Selection Clause
Value Strings
Relational Operators
Logical Connectives
BETWEEN Connective
Examples

Selection Criteria
Sort Criteria
Single Value Sort Connectives
Multivalue Sort Connectives
Subvalue Sort Connectives
Default Sort Order
Sort Order of Left-aligned Data
Sort Order of Right-aligned Data
Multiple Key Sort
Sorting Single Valued Attributes
Sorting Multivalued Attributes
Sorting Subvalued Attributes

Output Specification
TOTAL, MIN and MAX Connectives
BREAK-ON Connective
Controlling and Dependent Attributes
Format Specification
HEADING and FOOTING Modifiers
GRAND-TOTAL Modifier
Combining TOTAL, GRAND-TOTAL, and BREAK-ON
Subtotals and Cumulative Total with DET-SUPP
USING Clause
Options for Commands
Throwaway Connectives
Indexing
Using SELECT-INDEX and ISELECT
Implicit Use of Indexes by English
Rules for Implicit Use of an Index
Examples of Implicit Use of Indexes

English Commands
BSELECT, BSSELECT
CHECK-SUM
COUNT
EDELETE
ESEARCH
GENML, SGENML
I-DUMP
LIST
LISTCONN
LISTDICTS
LIST-ITEM
LIST-LABEL
LIST-SPREAD
REFORMAT
S-DUMP
SELECT
SORT
SORT-ITEM
SORT-LABEL
SORT-SPREAD
SSELECT
STAT
SUM

List Processing Commands
Introduction
Overview
List Generating Commands
List Processing Commands
Types of List
Active List
Saved List in POINTER-FILE
Default List (List with No Name)

Examples

AND-ITEMS
AND-LISTS
CLEAR-LIST
COPY-LIST
DELETE-LIST
EDIT-LIST
FORM-LIST
GET-LIST
NEW-GET-LIST
NEW-SAVE-LIST
NEW-SORT-LIST
NSELECT
OR-ITEMS
OR-LISTS
QSELECT
SAVE-LIST
SORT-LIST
XOR-ITEMS
XOR-LISTS
XSELECT

File and Data Definition Items
Database File Hierarchy
Creating a File
General Procedure
Creating a Data Section
Examples

File Definition Item
Sublists - V Code
Data Definition Item
Column Headings
S D/CODE
Default Output Specification
X D/CODE
Data Definition Item Examples
Special Attribute Mark Counts
A/AMC = 0 Item-id
A/AMC = 9998 Line Count/NI Operand
A/AMC = 9999 Item Size/NL Operand

Predefined Data Definition Items

Conversion Codes
Attribute 8 Versus Attribute 7 Processing
Data Formats
Attribute 8 (Pre-processor)
Attribute 7 (Input/output Processor)
Input Conversions
Multiple Codes

Processing Stages
Detail Line Processing
Selection Processing
Sort Processing
TOTAL Connective Processing
BREAK-ON Connective Processing
Conversion Code Reference
Processing Code Summary
A Code - Algebraic Functions
Overview
Summary of A and AE Formats
Operators
Arithmetic Operators
Relational Operators
Logical Operators
Concatenation Operator

Summary of Operands
Operand Attribute Number (AMC)
Operand Attribute Name
Operand Literals
Operand System Parameters
Operand Special Functions
Integer Function
Remainder Function
Summation Function
Substring Function

Format Codes
IF Statement
Multivalues
A Code Example

C Code - Concatenation
CALL Code - Call Subroutine
D Code - Date Conversion
D1 and D2 Codes - Controlling and Dependent Attributes
F Code - Mathematical Functions
Overview
Overview of Operators
Order of Operations
The Pushdown Stack

Push Operators
Arithmetic Operators
Miscellaneous Operators
Relational Operators
Logical Operators
Scaler
Multivalues
The S Operator
Format Codes
Examples of Stack Operations
F Code Examples

G Code - Group Extraction
L Code - Length
MC Codes - Mask Character
Overview
Changing Case
Extracting Characters
Replacing Characters
Converting Character Codes
Converting Numeric Values

MD Code - Mask Decimal without Alignment
MK Code - Mask Metric
ML and MR Codes - Mask Decimal with Alignment
Overview
Decimal Precision and Scaling
Suppressing Leading Zeros
Specifying the Thousands Separator
Specifying the Credit Indicator
Specifying a Currency Symbol
Specifying a Format Mask
Examples

MP Code - Masked Packed Decimal
MT Code - Mask Time
P Code - Pattern Matching
R Code - Range Check
S Code - Substitution
S Code - SOUNDEX
T Code - Text Extraction
Tfile Code - Translation
U Code - User Exit
XT Code – Generate HTML

English Macros
General Rules for Macros
USING Clause
Call to Another Macro
Macro Names
Comment Lines

Macro to Replace a Default Output Specification
Creating a Default Definition Item Macro
Example

Creating a Macro
Macro Examples

MultiValue Compatibility
B Conversion Code - Call Subroutine
Division using A and F Conversion Codes
Date Format
Changing Case
Predefined Data Definition Items

DataBasic Reference
Proc Reference
Editors
Resilience
SQL for Reality
UNIX-Connect
External Interfaces
Other Documents