JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Enterprise Database Server Data and Structure Definition Language (DASDL) Programming Reference Manual
Introduction to the Language Components of DASDL
Sidebar
Prev
|
Up
|
Next
Expression
Arithmetic Expression
Boolean Expression
An expression can be either arithmetic or Boolean.
Contents
Search
Introduction to the Basic Concepts of the Enterprise Database Server
Documentation Updates
What's New?
Overview of Enterprise Database Server Software Components
DASDL Overview
Accessroutines
Audit and Recovery
Application Program Interfaces
Database Reorganization
Control File
DMSUPPORT Library
Overview of Enterprise Database Server Database Components
Data Sets
Sets
Subsets
Data Items
Global Data
Introduction to the Language Components of DASDL
Character Set
Comment
Expression
Arithmetic Expression
Boolean Expression
Family Name
Identifier
Integer and Unsigned Integer
Number and Unsigned Number
Remark
String
Introduction to the Major Syntax Elements of DASDL
Syntax Elements for Defining a Database
Examples of Defining a Database
Using the MODEL and UPDATE Options
MODEL Option
UPDATE Option
Using the Defaults Specification
Preparing for Open Disk Technology
Specifying Database Defaults
Examples of Using the Defaults Specification
Using the Initialize Statement and the Options and Parameters Specifications
Initialize Statement
Options Specification
Examples of Using the Options Specification
Parameters Specification
Using the Code File Specifications
Accessroutines Specification
DMSUPPORT Specification
DMReorganization Specification
Recovery Specification
Data Recovery Specification
Reconstruct Specification
Reorganization Specification
RMSUPPORT Specification
DMCONTROL Specification
DMUTILITY Specification
LOBUTILITY Specification
Using the Audit Trail and Control File Specifications
Audit Trail Specification
Examples of Using the Audit Trail Specifications
Remote Database Backup with VSS-2 or VSS-3
Controlling Audit File Size
Control File Specification
Data Set Declaration
Preparing for Open Disk Technology
Defining the Data Set
Record Description
Record Size
Embedded Structures
Control Items
Data Item Types
Filler Data Items
Group Data Items
Link Data Items
Variable-Format Part
Verify Condition
Data Set Logical Option
Data Set Physical Options
ALLOCATE Option
AREAS and AREASIZE Options
AVERAGE RECORD SIZE Option
BLOCKSIZE Option
BUFFERS Option
CCSVERSION Option
CHECKSUM Option
DATAENCRYPT Option
DATAEXCHANGE Option
DATAMASK Option
DIGITCHECK Option
Disk/Pack Option
DUMPENCRYPT Option
DUMPSTAMP Option
EXTENDED Attribute
ILOB COMPRESSION Option
MEMORY RESIDENT Option
LOCK TO MODIFY DETAILS Option
LOGACCESS Option
LOGACCESSDMVERBS Option
OPEN PARTITIONS Option
PARTITION Option
POPULATION Option
POPULATIONINCR Option
POPULATIONWARN Option
REBLOCK and REBLOCKFACTOR Options
RECORDCOUNT Option
SECTIONS Option
SECURITYGUARD Option
STRENCRYPT Option
SUBBLOCKSIZE Option
VSSWARN Option
VSS2OPTIMIZE Option
VSS3OPTIMIZE Option
Example of Data Set Physical Options
16BITALIAS Option
Database Global Items and Physical Specifications
Database Global Data Items
Database Physical Specifications
Sets, Subsets, and Accesses
Preparing for Open Disk Technology
Sets
Set Name
Data Set Name
REORGANIZE Clause
Set Type
Key Clause
BINARY, LOGICAL, and EQUIVALENT Comparison Options
DUPLICATES Option
Key Data Option
Set Declaration Example
Subsets
Subset Name
Data Set Name
REORGANIZE Clause
Where Condition
Subset Type
Key Clause
BINARY, LOGICAL, and EQUIVALENT Comparison Options
DUPLICATES Option
Key Data Option
Set Name Identifier
Subset Declaration Examples
Scope Rules for Manual Subsets
Set and Subset Physical Options
AREAS and AREASIZE Options
BUFFERS Option
CHECKSUM Option
Disk/Pack Option
DUMPENCRYPT Option
DUMPSTAMP Option
LOADFACTOR Option
MODULUS Option
NOFTLOCK Option
OPEN PARTITIONS Option
POPULATION Option
PRIME Option
RECORDCOUNT Option
SECURITYGUARD Option
TABLESIZE Option
MEMORY RESIDENT Option
16BITALIAS Option
SECTIONS Option
PHYSICAL SECTIONS Option
Section Bounds Specification
VSSWARN Option
VSS2OPTIMIZE Option
VSS3OPTIMIZE Option
Set and Subset Physical Options Example
Accesses
Access Name
Data Set Name
Key Clause
DUPLICATES Option
MODULUS Option
SECTIONS Option
Section Bounds Specification
Access Examples
Using Remaps and Logical Databases for Security and Data Independence
Remaps Specification
Remap Record Description
Remap Count Items
Remap Population Items
Remap Record Type Items
Remap Aggregate Items
Remap Data Item
Remap Filler Item
Remap Group Item
Remap Link Item
Remap Reference
Remap Regrouping
Remap Set-Subset-Access
Virtual Item
Remap Variable-Format Part
SELECT/VERIFY Condition
Global Data Remap
Logical Database
Performing Updates
Understanding the Procedure for Performing Updates
Examples of the Update Process
Performing Reorganizations
Performing Garbage Collections
Performing File Format Conversions
Procedure for Performing File Format Conversions
Example for Changing Data Set Physical Options
Example for Changing the Set-Subset Physical Options
Example for Changing the MODULUS Attribute on an Access
Performing Record Format Conversions
Procedure for Performing Record Format Conversions
Example for Changing the Data Set Record Format
Example for Changing the Data Set Record Format of a Remap
Example for Deleting Embedded Structures
Example for Deleting a Link Item
Example for Changing Global Data
Reorganizing Hierarchies
Using the AUTOREORG Option
Using the INITIALIZENEW Option
Performing Modeling
Understanding the Procedure for Performing Modeling
Modeling with the Update or Reorganization Process
Reorganizing a Modeled Database
Reorganizing a Modeled Database Using DMREORG reorganization
Reorganizing a Modeled Database Using the USEREORGDB Option
Reorganizing a Modeled Database Using DMREORG reorganization along with the USEREORGDB Option
Update, Reorganization, and Modeling Capabilities and Limitations
Altering Database Default Options
Altering Database Options
Altering Database Parameters
Altering Audit Trail Specifications
Altering Control File Specifications
Altering Data Set Descriptions
Describing Data Set Alterations
Altering Aggregate Items
Altering Count Items
Altering Record Type Items
Altering Data Items
Altering Filler Items
Altering Group Items
Altering Link Items
Altering Population Items
Altering the Variable-Format Part
Altering Global Items
Altering the Data Set Logical Option
Altering Data Set Physical Options
Altering Item Types and Sizes
Allowable Sign Changes
Effect of Changing an Occurs Clause
Effect of Changing a Boolean Value in a Field
Changing Compact, VERIFY Condition, and SELECT Condition Items
Translating Alpha or Group Items to Number, Real, Field, or Boolean Items
Translating Number, Real, Field, or Boolean Items to Alpha or Group Items
Truncation
Altering Sets, Subsets, and Accesses
Altering Sets
Altering Subsets
Altering Set and Subset Physical Options
Altering Accesses
Altering Remaps and Virtual Information
Altering Remaps
Altering Remap Options
Altering Remap Aggregate Items
Altering Remap Count Items
Altering Remap Record Type Items
Altering Remap Data Items
Altering Remap Filler Items
Altering Remap Group Items
Altering Remap Link Items
Altering Remap Population Items
Altering Remap References
Altering Remap Sets, Subsets, and Accesses
Altering the Remap Variable-Format Part
Altering the Global Data Remap
Altering Virtual Count Items
Altering Virtual Data Items
Altering Virtual Group Items
Altering Virtual Population Items
Altering Logical Databases
DASDL Compiler
Compiler Files
Input Files
Output Files
DASDL Source Input Format
Initiating DASDL Compilations
Initiating DASDL Compilations Using WFL
Initiating DASDL Compilations Using CANDE
Compiler Control Statements
Boolean Options
Parameter Options
System Options
WFL Job File Inputs
WFL Job Examples
ACRDISPLAY Compiler Control Option
ACRINFO Compiler Control Option
ZIPFILE Compiler Control Option
Tailored File-Naming Conventions
Audit Files
AUTOREORG Parameter File
Control File
Database Files
Global Data
Data Sets
Sets and Subsets
Partitioned Structures
Description File
INITIALIZE Parameter File
Recovery File
DMSUPPORT Library
RMSUPPORT Library
Structure Formats
Common Features
File Format Levels
Database I/O
DUMPSTAMP Option
CHECKSUM Option
ADDRESSCHECK Option
Common Word Layouts
One-Way Chain of Available Blocks
Two-Way Chain of In-Use Blocks
Data Sets
Structure Format Changes for XE Features
Data Set Record Format
File Formats
Record Formats
Alignment Rules
Compact Data Sets
Direct Data Sets
Ordered Data Sets
Random Data Sets
Restart Data Sets
Standard Data Set (Fixed Format)
Standard Data Set (Variable Format)
Unordered Data Sets
Sets and Subsets
Key Entries
Bit Vector
Index Random Sets and Subsets
Index Sequential Sets and Subsets
Logically Sectioned Index Sequential Set
Physically Sectioned Index Sequential Sets
Ordered List Sets and Subsets
Unordered List Sets and Subsets
Designing Enterprise Database Server Databases
Approach
Summary
Representing Data Sets
Retrieval Keys
Update Anomalies
Modification Anomalies
Insertion Anomalies
Deletion Anomalies
Avoiding Anomalies
Relationships on Data Sets
One-To-One Relationships
One-To-N Relationships
M-To-N Relationships
Additional Relationship Information
Networks
Disjoint Versus Embedded Structures
Links and Manual Subsets
Controlling Structure Size to Optimize Database Performance
DASDL to Host Language Conversion
DASDL Limitations
Understanding Railroad Diagrams
Railroad Diagram Concepts
Paths
Constants and Variables
Constraints
Following the Paths of a Railroad Diagram
Railroad Diagram Examples with Sample Input
Search Highlighter (On/Off)
