Database Access
Table of Contents
Index
Chapter 10: SQL Option for DB2
10.1 Overview
10.2 SQL Option Components
10.3 XDB Server
10.3.1 Server Configuration Utility
10.3.2 Server Administration Options
10.4 SQL Wizard
10.4.1 Managing System Security and Priorities
10.4.2 Managing Locations, Tables and Queries
10.4.3 Creating and Running SQL Queries
10.4.4 Entering Data Directly into a Table
10.4.5 Importing and Exporting Data
10.4.5.1 Import/Export NLS Considerations
10.4.6 Running Batch Scripts
10.5 Migrate Utility
10.6 Execute SQL Option
10.7 Declaration Generator Utility
10.8 Options Utility
10.9 Bind Utility
10.10 Gateway Profile Utility
10.11 SQL Option Preprocessor
10.11.1 SQL Communications Area (SQLCA)
10.11.2 SQL Descriptor Area (SQLDA)
10.11.3 Support for Object Oriented COBOL Syntax
10.11.4 Security
10.11.5 DSNTIAR Facility
10.11.6 Migration Considerations
10.11.6.1 Invoking the Preprocessor
10.11.6.2 Directives in Comments
10.11.6.3 Ambiguous References
10.11.6.4 Debug Files
10.11.6.5 Maximum number of SQL statements
10.11.6.6 Setting Additional Directives under IDE
10.11.7 XDB Directive
10.11.8 Error Messages
10.11.9 Linking
10.11.10 Distributing Your Application
10.12 SQL Option NLS Environment
10.13 Using Existing XDB Data
10.14 Tips