Skip Headers
Oracle® Migration Workbench Reference Guide for Informix Dynamic Server Migrations
Release 10.1.0 for Microsoft Windows 98/2000/NT/XP and Linux x86
Part No. B16022-01
  Go To Index
Index

Next
Next
 

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
What You Should Already Know
How This Reference Guide is Organized
Related Documents
Conventions

1 Overview

Introduction
Product Description
Features
Glossary

2 Oracle and Informix Dynamic Server Compared

Database Security
Database Authentication
Database as a Logical Partition
Users
Schema Migration
Schema Object Similarities
Schema Object Names
Informix Dynamic Server Database-level Privileges
Migrating Multiple Databases
Table Design Considerations
Data Types
IMAGE and TEXT Data Types (Binary Large Objects)
Check Constraints
Foreign Key Constraint ON DELETE Option
Schema Migration Limitations for Informix Dynamic Server
Data Types
BYTE
CHAR(n)
Collation Order
Multibyte Character Sets
Comparison Sematics
Empty Strings
CHARACTER(n)
CHARACTER VARYING(m,r)
COLLECTION
Mapping Comparison
DATE
DATETIME
Oracle DATE Arithmetic
DECIMAL
DECIMAL(p) floating point
DECIMAL(p,s) fixed-point
INT
INTEGER
Range Boundaries
Storage
Inserting Fractions
INTERVAL
Manipulating Oracle DATE with Informix Dynamic Server INTERVAL Values
MONEY(p,s)
NCHAR(n)
Collation Order
Aside
NVARCHAR(m,r)
SMALLINT
Range Boundaries
Storage
Inserting Fractions
SERIAL
Additional Oracle Sequence Options for Informix Dynamic Server SERIAL Migrations
Resetting the Start Value
Some Exceptional Cases
How to examine current Informix Dynamic Server SERIAL values
VARCHAR(m,r)
Comparison Semantics
Collating VARCHAR
Aside
Data Storage Concepts
Recommendations
Data Storage Concepts Table

3 Triggers, Packages, and Stored Procedures

Triggers
Mapping Triggers
Mutating Tables
Packages
Stored Procedures
NULL as an Executable Statement
Parameter Passing
Oracle Parameter Passing Modes
Input Parameters
Output Parameters
Individual SPL Statements
Returning Section
DOCUMENT Clause
GLOBAL Variable Declarations
LIKE and MATCHES Comparison Conditions
FOR LOOP Constructs
FOREACH LOOP Constructs
Compound LET Statements
Converting CONTINUE Statements
Converting RETURN WITH RESUME Statements
Built-in Functions
Converting the SYSTEM Statement
Converting TRACE Statements
Set Up Tasks for the DEBUG Procedure
SELECT Statements as Conditions
Exception Blocks
RAISE EXCEPTION Statements
Error Handling within Stored Procedures
DDL Statements in SPL Code
Creating Temporary Tables
DROP TABLE Statements
Using Keywords as Identifiers
Issues with Converting SPL Statements
Oracle Migration Workbench Multibyte Issue
Multibyte Issue Example
Handling Extra Spaces in Stored Procedures

4 Distributed Environments

Distributed Environments
Accessing Remote Databases in a Distributed Environment
Oracle and Remote Objects
Informix Dynamic Server and Remote Objects
Application Development Tools

5 The ESQL/C to Oracle Pro*C Converter

Introduction to E/SQL and Pro*C
Using the ESQL/C to Oracle Pro*C Converter
Example Capture of ESQL/C Source Files
Example Code:
Oracle Pro*C Conversion
Manual Changes to the Oracle Pro*C File
Syntactical Conversion Issues
Application Conversion Issues
The Oracle Pro*C Preprocessor
Conversion Errors and Warnings
ESQL/C to Oracle Pro*C Converter Errors
ESQL/C to Oracle Pro*C Warnings
Restrictions
Renaming Reserved Words
Header Files
Using Multiple Connections For Different Transactions
Using Demonstration Code

6 Disconnected Source Model Loading

Generating Database Metadata Flat Files
Flat File Generation Scripts
Running the Script

A Code Samples

OMWB_Emulation Utilities Package

Index