Welcome
Product Information
       Key Features
       What's new in this release
       MS-Export or IBM OLEDB versus Scriptoria or Scriptoria
       Operating Requirements
Developer Guide
       Installation
             Operating Requirements
             Setup Options
             Registering the Scriptoria Add-in
             Using Remote Databases
             Installation Notes
             Starting Scriptoria
       Pre-Migration Tools
             Important Migration Guidelines
             Tables Without Primary Keys
                   Add Primary Keys
                   Tables w/o Primary Keys Report
             Creating QueryDefs from Record Sources
             Where-Used List Builder
             Case Sensitivity
                   Case Sensitivity Assistant
                   Case-Sensitivity Detailed Information
                   Enforce Case Rules Form
             High Overhead Queries
             Migrating Linked Access databases
       Overriding Default Assignmnets
             Assign DB2 Names
                   DB2 Naming Assignments
                   Table Name Assignments
                   Column Name Assignments
             Assign DB2 Data Types
                   Default DB2 Data Type Assignments
                   Date Type Assignments
                   Memo data Type Assignments
                   Equivalent DB2 Data Types
                   Assign DB2 Data Types to Individual Columns
                         Assign DB2 Data Types to Individual Columns
                         Character (Text) Data Type Pop-up Form
                         DataLink Features Data Type Pop-up Form
                         Decimal Data Type Pop-up Form
                         Identity Data Type and Properties Pop-up Form
                         Long Object Data Type Pop-up Form
                   Additional Data Type Information
             Assign Table Spaces
                   Assign Table Spaces
             User Error Messages
       Main Form
             Scriptoria for DB2 Main Menu
             Table Selection
             Query Selection
             List Selection
             Linked Data Stores
             Setting Options
                   Choosing Scriptoria Options
                   General Options
                         Schema Assignment
                         User-Defined Function Options
                         Development Modes
                         DB2 Compile Options
                         Include Object Types for Migration
                         DB2 Naming Options
                   Data Transfer Options
                         Data Population Options
                   Query Options
                         Query Options
                         Assign Owner/Schema Names to External Tables
                         Parameter Table Options
                   Error Handling Options
                         Error Handling Options
             DB2 Update Status Page
       Forms Page
             Getting Started
             Forms Conversion
             WebForm Options
             WebForm Layout Generation
             WebForm Code-Behind Generation
             WebForms
             Extended Navigation Bar
       Reports Page
             Conversion Tips
             Reports Conversion
             Default Options
             Individual Report Options
             Report Troubleshooting
       Post-Migration Tools
             Create DB2 Application
                   Create DB2 Application
                   Inherited Access Properties
             Access to DB2 Security Wizard
                   Security Wizard
                   Example
       Tools Menu
             DB2 Database Connection Form
                   DB2 Database Connection Form
                   DB2 Database Options
                   DB2 Authentication
                   DB2 Databases and Schemas
             Import DB2 Database
                   Import DB2 Database
                   Import Options
                   Import Output Log
             DB2 Command Interface
                   Ad-Hoc Queries
                   QueryDef Conversion/Execution
             DB2 Viewer
                   Overview
                   Tables Page
                   Views Page
                   Triggers Page
                   Foreign-keys Page
                   Functions Page
                   Procedures Page
                   System Catalog
       Extended Alterations
             DB2 Table Rebuild Required
             Extended Alterations - Access Vs. DB2 Table Definition Form
             Extended Table Alterations Form
             Extended Alterations - Data Type Changes
             Changing Table Space Assignments
             Reasons for Extended Alterations
             Consequences for Extended Table Alteration
       Query Conversions
             Client-Server Disposition Options
                   Client-Server Global Options
                   Assign Options to Individual Queries
             When to convert Access QueryDefs to Oracle
             Query Formulation Tips
             Query Conversion Details
                   Query Conversion Overview
                   QueryDef Conversion/Execution
                   VBA Built-In Function Handling
                   VBA Built-In Function Details
                   Intrinsic Constants
                   Extended Pattern Matching
                   Operators
       Cataloging Remote (Internet) DB2 Databases
             Prerequisites
             DB2 Client Configuration Assistant
             Add New Database
             Supply System Information
             Supply TCP/IP Address
             Supply Database Alias
             Register ODBC Data Source
             Test Database Connection
       Technical Details
             DB2 to Access Translation Details
                   Assigning Access Names
                   Data Type Conversion
                   Defaults
                   Check Constraints
                   NOT NULL to Required
                   Primary Keys and Indexes
                   Relationships
             Access to DB2 Translation Details
                   DB2 Version Dependent Names
                   Assign DB2 Data Types
                   Primary and Unique Keys
                   Declarative versus Explicit constraints
                   Indexes
                   Default Values
                   Validation Rules
                   Required Property
                   Relationships
                   VB Built-in Function Substitutions
       Troubleshooting
             Case Sensitivity
             Inconsistent Data Types
             Unique Rows
             DATES - caveats with date arithmetic
             Numeric Overflow
             User Temporary Table Space - insufficient page size
             System Temporary Table Space - insufficient page size
             Naming Conventions
             Index - maximum columns exceeded
             ODBC #DELETED# Problems
                   When Inserting Rows
                   Double-Precision Unique Keys
             Erratic behavior with linked tables and queries
             Relationship Not Generated
             UDF_MEM_SZ Error
             MS-Access Indexes Missing from DB2
       Suggested Reading
             Suggested Reading
       Tutorials
             Part 1 - the Database
             Part 2 - the Application
             Sample Basic Code
Ongoing Enhancements and Maintenance
       Ongoing Enhancements and Maintenance