Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

How This Reference Guide is Organized

How to Use This Reference Guide

Documentation Accessibility

Accessibility of Code Examples in Documentation

Related Documentation

Conventions

1 Overview

Introduction

Product Description

Features

Glossary

2 Oracle and Informix Dynamic Server Compared

Database Security

Database Authentication

Schema Migration

Schema Object Similarities

Schema Object Names

Informix Dynamic Server Database-level Privileges

Migrating Multiple Databases

Table Design Considerations

Data Types

BYTE

CHAR(n)

CHARACTER(n)

NCHAR(n)

VARCHAR(m,r)

CHARACTER VARYING(m,r)

NVARCHAR(m,r)

DATE

DATETIME

INTERVAL

DECIMAL

MONEY(p,s)

INTEGER

INT

SMALLINT

SERIAL

Data Storage Concepts

Recommendations

Data Storage Concepts Table

3 Triggers, Packages, and Stored Procedures

Introduction

Triggers

Mapping Triggers

Mutating Tables

Packages

Stored Procedures

NULL as an Executable Statement

Parameter Passing

Individual SPL Statements

Error Handling within Stored Procedures

DDL Statements in SPL Code

Using Keywords as Identifiers

Issues with Converting SPL Statements

4 Distributed Environments

Distributed Environments

Accessing Remote Databases in a Distributed Environment

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

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

A Code Samples

OMWB_Emulation Utilities Package

Index