CONTENTS Title Page Copyright Page Preface Acknowledgment 1 Data Dictionary Define Data Names Option References Piece Extract Groups Pointers Data Types Data-Name Attributes Transforms Triggers Cross References Comments Screen Edit Data Names (BRIEF) Option Define Templates Option Data Dictionary Utilities Print Data Name Definitions Option Print Template Definitions Option Compare Data Names Option Search Data Names Option Search Templates Option Data Name Usage Report Option 2 Screen Driver Define Data Screens Option Screen Attributes 132 BATCH BOX CHECKPT NOPAD PERM SCROLL TIMEOUT Fields Field Attributes BLINK BOLD DEFAULT DEMAND FULL KEY LCASE LCASEQ NOBACK NOECHO NOFILTER REQUIRED REVERSE SPACEL SPACES SPACET TALL TERM UNDER WIDE Validations COND DATE DATEN DO INTEGER LOGICAL LOOKUP NAME NUMERIC PATTERN TABLE TABLEM TABLEX TIME XECUTE Actions ASSIGN COUNT DISPLAY DO DONP ERASE ERROR EVAL EVALS EXIT FILE FILES HANG KILL LOCK LOG LOGDMP LOGOFF LOGON MUMPS NXTFLD NXTSCN QUIT REPAINT RESET SCROLL SET TCOMMIT TSTART UNLOCK XECUTE Display Designer Scroll Regions Screen Driver Variables Batch Screens Transaction Processing Define Option Screens Option Command Mode Define Text Screens Option Screen Driver Utilities Compile Screens Option Run Screens Option Compare Screens Option Compare Field to DDN Defaults Option Print Screen Definitions Option Print Option Structure Option Print Field Branching Logic Option Print Data Screen DO/DONP Usage Option Search/Edit Data Screens Option Search Multiple Data Screens Option 3 Report Driver Define Reports Option Collection Specifications Sort Lists Format Group Specifications Print Items Report Driver Functions $AVE $COUNT $DATE $LINE $MAX $MED $MIN $NOLINE $PAGE $PAGEC $PAGEN $QUITREP $REPEAT and $ENDREP $REQUIRE $SECTION $SETPAGE $STD $TIME $TOTAL Report Driver Macros Report Driver Variables Report Driver Comments Format Descriptors Compile Reports Option Run Reports Option Copy Report Group Level Option Calling Reports from Data Screens and Option Screens Report Driver Utilities Print Report Definitions Option Compare Reports Option Search/Edit Reports Option Search Multiple Reports Option Print Report Literal Strings Option Print Report MUMPS Routine Calls Option Print Report Macro Calls Option 4 Query Driver Define Query Option SELECT Statement SELECT Clause FROM Clause WHERE Clause GROUP BY Clause HAVING Clause Value Expressions Query Driver Functions AVG COUNT MAX MIN SUM Search Conditions Comparison Predicates BETWEEN Predicate IN Predicate LIKE Predicate NULL Predicate Define System Queries Option Define Tables Option Query Driver Utilities Run Query Option Print Query Definitions Option Print Table Overview Option Print Table Definitions (Full) Option Display Table Definitions Option Display Schema Diagram Option Print Schema Diagram Option Build Table Cross-Reference Option Delete Generated Query Routines Option Compile Queries Option 5 Development Environment Development Dictionaries Option Group Dictionary Option Device Type Dictionary Option Error/Event Code Dictionary Option Privilege Code Dictionary Option Set Parameters Option Application Parameters Option Site Parameters Option Key Definitions Option Print Development Reports Option Development Utilities Option Edit Application Copyright Option Edit VAX DSM Routines Option Transfer %Commands Option Mapped Section Utility Option Build Cross-Reference Indexes Option Save DASL Definitions Option Screen and Report Creator Option DASL Language Utilities DASL Language Utilities Menu Choose Multinational Characters Option Translate DASL Messages Option Choose Current Language Option Print DASL Messages Option Delete Language Option Portable Run-Time DASL Utilities Portable Run-Time DASL Utilities Menu Translate VAX DSM Code Option Add Entries to Translation Table Option Define Target Save Set Option Print Target Save Set Definitions Option Print Code Translation Table Option 6 Application Environment Security System Option Classification Dictionary Option User Dictionary Option Device Dictionary Option Device Specifications Device Attributes Device Ports System Status Dictionary Option Inquiry Mode System Control Option Security Reports Option Classification Dictionary Listing Device Dictionary Listing Privilege Dictionary Listing System Status Dictionary Listing User Dictionary Listing User Dictionary Listing by Class User Statistics Report Command Listing System Monitor Report Edit User Password Option Edit Installation Name Option Report Directory Option Message Center Option Send System Messages Option Read System Messages Option Event Logging Option Assign Event Logging Device Option Print System Event Log Option Purge System Event Log Option Query Database Option A ASCII and Multinational Character Sets B Entry Points C Function Keys D SQL Keywords EXAMPLES 1-1 Data Name Definitions Report 1-2 Template Definitions Report 1-3 Data Names Comparison Report 1-4 Search Data Names Report 1-5 Search Templates Report 1-6 Data Name Usage Report 2-1 Screen Comparison Report 2-2 Compare Field to DDN Defaults Report 2-3 Data Screen Definitions Report 2-4 Option Screen Definitions Report 2-5 Option Structure Report 2-6 Field Branching Logic Report 2-7 DO/DONP Usage Report 2-8 Search Multiple Data Screens Report 3-1 Report Definition Report 3-2 Report Comparison Report 3-3 Search Multiple Reports Report 3-4 Report Literal Strings Report 3-5 Report Routine Calls Report 3-6 Report Macro Calls Report 4-1 Query Definitions Report 4-2 Table Contents Listing 4-3 Print Table Definitions Report 5-1 Print DASL Messages Report 5-2 Print Target Save Set Definitions Report 5-3 Print Code Translation Table Report 6-1 Classification Dictionary Listing 6-2 Device Dictionary Listing 6-3 Privilege Dictionary Listing 6-4 System Status Dictionary Listing 6-5 User Dictionary Listing 6-6 User Dictionary Listing by Class 6-7 User Statistics Report 6-8 Command Listing 6-9 System Monitor Report 6-10 System Event Log FIGURES 1-1 Data Dictionary Menu 1-2 Define Data Names Screen #1 1-3 Define Data Names Screen #2 1-4 Comments Screen 1-5 Edit Data Names (Brief) Screen 1-6 Define Templates Option Screen 2-1 Screen Driver Menu 2-2 Define Data Screens Screen #1 2-3 Define Data Screens Screen #2 2-4 Display Designer Keypad 2-5 Scroll Region in MEET Screen 2-6 Define Option Screens Screen #1 2-7 Define Option Screens Screen #2 2-8 Command Definition Screen 2-9 Define Text Screens Screen 3-1 Report Driver Menu 3-2 Define Reports Screen #1 3-3 Define Reports Screen #2 3-4 Report Structure 3-5 Copy Report Group Level Screen 3-6 NAME Field of the ADKSEL Screen 3-7 CQ Field of the ADBKSEL Screen 3-8 Calling Report ADBKALL from an Option Screen 3-9 Option Screen OSCN Calls USPRT 3-10 USPRT - Field SORT Defines %RPNAME 3-11 USPRT - Field CHECK Calls %UDEV 4-1 Query Driver Menu Screen 4-2 Define Query Screen 4-3 Syntax of the SELECT Statement 4-4 Schema Showing Pointers in WHERE Clause 4-5 Logical Operators: AND 4-6 Logical Operators: OR 4-7 Define Tables Screen #1 4-8 Define Tables Screen #2 4-9 Display Table Definitions Screen 4-10 Schema Diagram Screen 5-1 Development Environment Menu 5-2 Development Dictionaries Menu 5-3 Group Dictionary Screen 5-4 Device Type Dictionary Screen 5-5 Error/Event Code Dictionary Screen 5-6 Privilege Code Dictionary Screen 5-7 Set Parameters Menu 5-8 Application Parameters Screen 5-9 Site Parameters Screen 5-10 Function and Gold Key Map 5-11 Key Definitions Screen 5-12 Print Development Reports Menu 5-13 Development Utilities Menu 5-14 Edit Application Copyright Screen 5-15 Edit VAX DSM Routines Screen 5-16 Transfer %Commands Screen 5-17 Build Cross-Reference Indexes Screen 5-18 Screen and Report Creator Screen 5-19 DASL Language Utilities Menu 5-20 Choose Multinational Characters Screen 5-21 Translate DASL Messages Screen 5-22 DASL Applications at Run Time 5-23 Porting DASL Applications to a Target Device 5-24 Structure of USE Subroutine 5-25 Portable Run-Time DASL Utilities Menu 5-26 Translate VAX DSM Code Screen 5-27 Add Entries to Translation Table Screen 5-28 Define Target Save Set Screen 6-1 Application Environment Menu 6-2 Security System Menu Options 6-3 Location of Security System Dictionaries 6-4 Relationship of Security System Privilege Dictionaries 6-5 Function of the System Mask 6-6 Classification Dictionary Screen 6-7 User Dictionary Screen 6-8 Device Dictionary Screen 6-9 System Status Dictionary Screen 6-10 System Control Screen 6-11 Security Reports Menu 6-12 Edit User Password Screen 6-13 Report Directory Screen 6-14 Message Center Options 6-15 Event Logging Menu Options 6-16 Query Database Screen A-1 ASCII Character Set A-2 DEC Multinational Character Set A-3 ISO Latin-1 Character Set TABLES 1-1 Information for Data Name Definition 1-2 DASL Fields that Allow Extended Global Syntax 1-3 Piece and Extract References 1-4 Pointer Chain Syntax 1-5 DASL Data Types 1-6 DASL Data-Name Attributes 1-7 Cross-Reference Types 2-1 Screen Definition Information 2-2 DASL Screen Attributes 2-3 Field Definition Information 2-4 DASL Field Attributes 2-5 DASL Validations 2-6 Standard Date Input Formats 2-7 Standard Date Output Characters 2-8 DATEN Partial Date Interpretations 2-9 Pattern Code Characters 2-10 Standard Time Input Formats 2-11 Standard External Time Characters 2-12 DASL Actions 2-13 Summary of EVALS/KEY Syntax 2-14 EXIT Processing 2-15 Summary of FILES/KEY Syntax 2-16 ACID Properties of Transactions 2-17 DASL Commands Within Transactions 2-18 Display Designer Keys 2-19 DASL Scroll Region Actions 2-20 DASL Screen Driver Variables 2-21 References to Screen Driver Variables 2-22 Option Screen Definition Information 2-23 Option Information 2-24 Command Definition Information 2-25 Text Screen Definition Information 3-1 Information for Collection and Sorting 3-2 Information for Defining Report Output 3-3 Collection Qualifier Forms 3-4 Standard Format Groups 3-5 Data-Name Qualifiers 3-6 Report Driver Formatting Functions 3-7 Report Driver Statistical Functions 3-8 Data Types and Statistical Functions 3-9 DASL Report Driver Variables 3-10 Format Descriptors 3-11 Report Device Selection Information 3-12 Variables for %UDEV Screen 4-1 Information for Defining Queries 4-2 Arithmetic Operators 4-3 Query Driver Functions 4-4 Operators Within Predicates 4-5 Comparison Operators 4-6 Information for Defining Tables 4-7 Information for Defining Columns 5-1 Basic DASL Device Attributes 5-2 Basic DASL Error and Event Codes 5-3 Application Parameters 5-4 Site Parameters 5-5 Key Definitions Information 5-6 Routine Identification Information 5-7 Screen and Report Creator Definition 5-8 Multinational Character Information 5-9 DASL Translation Information 5-10 DASL Work Areas and Portability Tasks 5-11 Translation Table of VAX DSM Code Information 5-12 Information for the Add to Translation Table Screen 5-13 Information for the Define Target Save Set Screen 6-1 Classification Dictionary Information 6-2 User Dictionary Information 6-3 Device Dictionary Information 6-4 Device Attributes 6-5 System Status Information 6-6 Report Directory Information B-1 DASL Entry Points C-1 DASL Function Keys D-1 SQL Keywords Not Allowed as Column or Table Names