Index

A B C D E F I K L M N O P R S T U V W

Symbols

wildcard operators, 3.3.3.4

A

accessing remote databases, 4.1.1

Application Conversion Issues, 5.2.1

application development tools, 4.2

Arithmetic, 2.3.7.1

B

BEGIN WORK

statements, 3.3.3.13.3

BLOBs, 2.2.5.2

built-in functions, 3.3.3.10

C

Capture of ESQL/C Source Files, 5.1.2

Capture Wizard, 1.4

check constraints, 2.2.5.3

clauses

DOCUMENT, 3.3.3.2

when MATCHES are not converted, 3.3.3.4

column names, 2.2.2

column-level CHECK constraint, 2.2.5.3

Common Outstanding Issues

Header Files, 5.4.2

Renaming Reserved Words, 5.4.1

Using multiple connections for different transactions, 5.4.3

comparison conditions

LIKE, 3.3.3.4

MATCHES, 3.3.3.4

compound LET

statements, 3.3.3.7

constructs, 3.3.3.6

FOR EACH LOOP, 3.3.3.6

FOR LOOP, 3.3.3.5

CONTINUE

statements, 3.3.3.8

converting, 3.3.7

CREATE TEMP TABLE

statements, 3.3.5.1

creating temporary tables, 3.3.5.1

D

data storage concepts, 2.4

data type mappings, 2.3

data types, conversion considerations, 2.2.5.1

DATETIME data type, 2.2.5.1.1

DDL statements, 3.3.5

DEBUG procedure

configuring, 3.3.3.13.1

overview, 3.3.3.13

destination database, 1.4

Disconnected Source Model Load, 6

distributed environments, 4.1

DOCUMENT

clause, 3.3.3.2

DROP TABLE

statements, 3.3.5.2

DUAL tables, 3.3.3.14

E

error handling

stored procedures, 3.3.4

E/SQL, an Introduction to, 5.1

ESQL/C to Oracle Pro*C Parser Errors, 5.3.1

ESQL/C to Oracle Pro*C Warnings, 5.3.2

ESQL/C to Pro*C Converter, Using the Converter, 5.1.1

exception blocks, 3.3.3.15

F

features, 1.3

Flat File Generation Scripts, 6.1.1

FOR EACH LOOP, 3.3.3.6

FOR LOOP

constructs, 3.3.3.5

FOREACH . . SELECT. . INTO

statements, 3.3.3.6.1

FOREACH CURSOR

statements, 3.3.3.6.2

FOREACH execute procedure

statements, 3.3.3.6.3

I

IMAGE data type, 2.2.5.2

Informix 4GL, 4.2

K

keywords

not supported by the Migration Workbench, 3.3.6

used as identifiers, 3.3.6

L

comparing, 3.3.3.4

M

mapping

triggers, 3.1.1

MATCHES

comparing, 3.3.3.4

metadata flat files

generating, 6.1

Migration Wizard, 1.4

modes

IN, 3.3.2.1

IN OUT, 3.3.2.1

OUT, 3.3.2.1

parameter passing, 3.3.2, 3.3.2.1

Multibyte Issue, 3.3.8

mutating tables, 3.2

N

NULL

executable statement, 3.3.1

O

object names, 2.2.2

Oracle Model, 1.4

Oracle Pro*C Conversion, 5.1.3

overview, 3.3

triggers, 3.1

P

packages, 3.2

utilities, 3.3.3.10

parameter passing

logical parts, 3.3.2

Oracle modes, 3.3.2, 3.3.2.1

parameters

input, 3.3.2.2

output, 3.3.2.3

Pro*C, an Introduction to, 5.1

product description, 1.2

R

RAISE EXCEPTION

statements, 3.3.3.16

remote objects

Informix Dynamic Server, 4.1.1.2

Oracle, 4.1.1.1

repository, 1.4

RETURN WITH RESUME

statements, 3.3.3.9

returning section, 3.3.3.1

ROLLBACK WORK

statements, 3.3.3.13.4

S

savepoints, 3.3.3.13.3

schema migration, 2.2

SELECT

statements, 3.3.3.14

SET DEBUG FILE

statements, 3.3.3.13.2

SHELL stored procedures, 3.3.3.11

set-up tasks for configuring, 3.3.3.11.1

source database, 1.4

Source Model, 1.4

SPL statements, 3.3.3, 3.3.7

statement

NULL, 3.3.1

statements

BEGIN WORK, 3.3.3.13.3

compound LET, 3.3.3.7

CONTINUE, 3.3.3.8

converting TRACE, 3.3.3.12

CREATE TEMP TABLE, 3.3.5.1

DDL statements, 3.3.5

DROP TABLE, 3.3.5.2

FOREACH execute procedure, 3.3.3.6.3

issues with converting SPL statements, 3.3.7

RAISE EXCEPTION, 3.3.3.16

RETURN WITH RESUME, 3.3.3.9

ROLLBACK WORK, 3.3.3.13.4

SELECT, 3.3.3.14

SELECT within IF condition, 3.3.3.14

SET DEBUG FILE, 3.3.3.13.2

SPL statements, 3.3.3

SYSTEM, 3.3.3.11

TRACE, 3.3.3.12

WITH RESUME, 3.3.3.1.1

statements, FOREACH . . SELECT. . INTO, 3.3.3.6.1

statements, FOREACH CURSOR, 3.3.3.6.2

stored procedures, 3.3

error handling, 3.3.4

multibyte issues, 3.3.8

overview, 3.3

SHELL, 3.3.3.11

subprograms, 3

Syntactical Conversion Issues, 5.2

ANSI Code, 5.2

CURSOR Declaration, 5.2

DECLARE CURSOR Statement, 5.2

Double '=' in WHERE Clause, 5.2

EXEC SQL Statement, 5.2

FETCH Clause, 5.2

FOR UPDATE Option, 5.2

Header Files SQLNOTFOUND, 5.2

INCLUDE Files, 5.2

OUTER JOIN Syntax, 5.2

UNIQUE Keyword in the SELECT Clause, 5.2

UPDATE Statement, 5.2

SYSTEM

statements, 3.3.3.11

T

table design considerations, 2.2.5

table-level CHECK constraint, 2.2.5.3

tables

DUAL, 3.3.3.14

temporary table usage, 5.1

temporary tables

creating, 3.3.5.1

TEXT data type, 2.2.5.2

The Pro*C Preprocessor, 5.2.2

TRACE

statements, 3.3.3.12

Triggers, 3.1

triggers

mapping, 3.1.1

mutating tables, 3.2

overview, 3.1

U

Using Demo Code, 5.5

utilities package, 3.3.3.10

V

variables, global, 3.3.3.3

W

wildcard operators

%, 3.3.3.4

?, 3.3.3.4

^, 3.3.3.4

_, 3.3.3.4

enclosed characters, 3.3.3.4

WITH RESUME

procedure contains, 3.3.3.1.2

procedure does not contain, 3.3.3.1.1