CONTENTS Title Page Copyright Page Preface 1 Overview The Non-SQL Data Server ( NSDS ) 2 Installing the DEC DB Integrator Gateway for DSM Software Required Operating System Components Installation Overview Registering Required Licenses DEC DB Integrator Gateway for DSM Installation Procedure Installing the DSM Software Common Components Disk Space Required VMS Privileges Required Unlocking Process Account Password Installing the Common Components Installing Common Component Images as Shared Using Different Versions of Common Components Installing SQL Services Installing NSDS Notes for Installing PC Access and ODBC Rdb Driver 3 Setting Up the DEC DB Integrator Gateway for DSM Software Setting Up Your DEC DB Integrator Gateway for DSM System Defining Databases Enabling DECdtm Services Setting Up SQL Services Modifying VMS Process Quotas Attaching to Databases Precompiled Subqueries Security and Access Control for PC Clients Using DSM Transaction Processing 4 Using DASL with the DEC DB Integrator Gateway for DSM Software DASL Setup for Queries DASL Table Access DASL Data Types DASL Access Paths Skipping Records DASL Setup for Database Updates Table Hierarchy Pointer Fields Output Transforms Indexes Counter Fields 5 Using FileMan with the DEC DB Integrator Gateway for DSM Software Overview of the FileMan Interface Setting Up the FileMan Interface Installing the SQL Files Editing the SQL Files Using the SQL PROFILE File Using the SQL PRESENTATION File Creating Initialization Routines 6 User Defined Databases Writing Your Own Routines Writing Metadata and Data Access Routines Debug Flags