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 Edit Global Reference Option Build Global Node Cross-Reference Option 2 Screen Driver Define Data Screens Option Screen Attributes Fields Field Attributes Validations Actions 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 Copy Fields Across Screens Option Screen Driver Commands 132 ASSIGN BATCH BLINK BOLD BOX CHECKPT COND COUNT DATE DATEN DEFAULT DEMAND DISPLAY DO DONP ERASE ERROR EVAL EVALS EXIT FILE FILES FKEY FULL HANG INTEGER KEY KILL LCASE LCASEQ LOCK LOG LOGDMP LOGICAL LOGOFF LOGON LOOKUP MUMPS NAME NOBACK NOECHO NOFILTER NOPAD NUMERIC NXTFLD NXTSCN PATTERN PERM QUIT REPAINT REQUIRED RESET REVERSE SCROLL Action SCROLL Screen Attribute SET SPACEL SPACES SPACET TABLE TABLEM TABLEX TALL TCOMMIT TERM TIME TIMEOUT TSTART UNDER UNLOCK WIDE XECUTE 3 Report Driver Define Reports Option Collection Specifications Sort Lists Format Group Specifications Print Items Report Driver Functions 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 Report Driver Commands $AVE $COUNT $DATE $LINE $MAX $MED $MIN $NOLINE $PAGE $PAGEC $PAGEN $QUITREP $REPEAT and $ENDREP $REQUIRE $SECTION $SETPAGE $STD $TIME $TOTAL 4 Query Driver Define Query Option SELECT Statement Value Expressions Query Driver Functions Search Conditions Define System Queries Option Define Tables Option Callable Queries 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 Query Driver Commands AVG Function BETWEEN Predicate Comparison Predicates COUNT Function FROM Clause GROUP BY Clause HAVING Clause IN Predicate LIKE Predicate MAX Function MIN Function NULL Predicate SELECT Clause SUM Function WHERE Clause 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 Date and Time Parameters Option Key Definitions Option Print Development Reports Option Development Utilities Option Edit Application Copyright Option Edit 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 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 Callable Query Program 4-2 Query Definitions Report 4-3 Table Contents Listing 4-4 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 Classification 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 Define Data Names Screen #3 1-5 Comments Screen 1-6 Edit Data Names (Brief) Screen 1-7 Define Templates Option Screen 1-8 Edit Global Reference 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 2-10 Copy Fields Across 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 ADBKSEL 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 AND Logical Operator 4-5 OR Logical Operator 4-6 Define Tables Screen #1 4-7 Define Tables Screen #2 4-8 Display Table Definitions Screen 4-9 Schema Diagram Screen Sample 4-10 Schema Showing Pointers in WHERE Clause 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 Dictionary Screen 5-7 Set Parameters Menu 5-8 Application Parameters Screen 5-9 Site Parameters Screen 5-10 Date/Time Parameters Screen 5-11 Function and Gold Key Map 5-12 Key Definitions Screen 5-13 Print Development Reports Menu 5-14 Development Utilities Menu 5-15 Application Copyright Screen 5-16 DSM Routines Screen 5-17 Transfer %Commands Screen 5-18 Build Cross-Reference Indexes Screen 5-19 Screen/Report Creator Screen 5-20 DASL Language Utilities Menu 5-21 Choose Multinational Characters Screen 5-22 Translate DASL Messages Screen 5-23 DASL Applications at Run Time 5-24 Porting DASL Applications to a Target System 5-25 Structure of USE Subroutine 5-26 Portable Run-Time DASL Utilities Menu 5-27 Translate DSM Code Screen 5-28 Add To Translation Table Screen 5-29 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 Information for Global Reference Definition 1-3 Information for Transforms Definition 1-4 DASL Fields That Allow Extended Global Syntax 1-5 Piece and Extract References 1-6 Pointer Chain Syntax 1-7 DASL Data Types 1-8 DASL Data Name Attributes 1-9 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 DASL Actions 2-7 Display Designer Keys 2-8 DASL Scroll Region Actions 2-9 DASL Screen Driver Variables 2-10 References to Screen Driver Variables 2-11 Option Screen Definition Information 2-12 Option Information 2-13 Command Definition Information 2-14 Text Screen Definition Information 2-15 Standard Date Input Formats 2-16 Standard Date Output Characters 2-17 DATEN Partial Date Interpretations 2-18 Summary of EVALS/KEY Syntax 2-19 EXIT Processing 2-20 Summary of FILES/KEY Syntax 2-21 Key Mnemonics for FKEY 2-22 Special Variables or FKEY Attribute 2-23 Pattern Code Characters 2-24 Standard Time Input Formats 2-25 Standard External Time Characters 2-26 ACID Properties of Transactions 2-27 DASL Commands Within Transactions 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 Information for Defining Tables 4-6 Information for Defining Columns 4-7 Comparison Operators 5-1 Basic DASL Device Attributes 5-2 Basic DASL Error and Event Codes 5-3 Application Parameters 5-4 Site Parameters 5-5 Date and Time Parameters 5-6 Key Definitions Information 5-7 Routine Identification Information 5-8 Screen and Report Creator Information 5-9 Multinational Character Information 5-10 DASL Translation Information 5-11 DASL Work Areas and Portability Tasks 5-12 Files for Portable Run-Time DASL Examples 5-13 Information for the Translate DSM Code Screen 5-14 Information for the Add to Translation Table Screen 5-15 Information for the 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