![]()
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