CONTENTS Title Page Copyright Page Preface 1 Release Notes for DEC RdbExpert for VMS 1.1 Using RdbExpert Effectively 1.2 Installation Considerations 1.2.1 Temporary RdbExpert Installations 1.2.2 ENQLM in User Account Quotas 1.3 Memory Usage by RdbExpert 1.3.1 Virtual Memory Usage in a Statistical Scan 1.3.2 Systems With Limited Memory 1.4 Uniform Page Areas Containing Sorted Indexes 1.5 Multinational Character Set Not Supported 1.6 New Database Design Directory Not Visible If First 1.7 Pending Delete Mode Not Set in Workload and Volume Windows 1.8 Main Directory Window Hangs 1.9 System Environment Window 1.10 OUTPUT DESIGN Procedure 1.11 SQL-Related Information 1.11.1 Parsing SQL Expressions 1.11.2 Arithmetic Expressions in SQL 1.11.3 Error Parsing SET TRANSACTION Statement 1.12 Importing Data 1.12.1 Performance Suggestion for Schema Import 1.12.2 Translating a DECtrace Workload to SQL Source Code 1.12.3 Checking Workload Syntax Before an Import 1.12.4 Importing Tables with Over 255 Columns 1.12.5 Importing a Workload from DECtrace 1.12.5.1 Constraints and Triggers in a DECtrace Workload 1.12.5.2 DBKEY Clause in Requests Imported from DECtrace 1.12.5.3 Importing Database Statistics for a DECtrace Workload 1.12.5.4 Importing a Workload from DECtrace and SQLMOD Applications 1.12.5.5 Importing a Workload from DECtrace and Dynamic/4GL Applications 1.12.5.6 Importing a Workload from SQLMOD Files 1.12.5.7 Requests Bypassed During Import of DECtrace Workload 1.13 Documentation Errors 1.13.1 RDBX$DEBUG_FLAGS 1.13.2 Defining the Maximum Physical Memory Available 1.13.3 ENQLM in User Account Quotas