Index
A B C D E F I K L M N O P R S T U V W
Symbols
- %
- wildcard operators, 3-17
- ?
- wildcard operators, 3-17
- ^
- wildcard operators, 3-17
- _
- wildcard operators, 3-17
A
- accessing remote databases, 4-2
- Application Conversion Issues, 5-13
- application development tools, 4-3
- Arithmetic, 2-23
B
- BEGIN WORK
- statements, 3-40
- BLOBs, 2-7
- built-in functions, 3-30
C
- Capture of ESQL/C Source Files, 5-2
- Capture Wizard, 1-3
- check constraints, 2-8
- clauses
- DOCUMENT, 3-13
- when MATCHES are not converted, 3-18
- column names, 2-4
- column-level CHECK constraint, 2-8
- Common Outstanding Issues
- Header Files, 5-23
- Renaming Reserved Words, 5-23
- Using multiple connections for different transactions, 5-23
- comparison conditions
- LIKE, 3-17
- MATCHES, 3-17
- compound LET
- statements, 3-24
- constructs, 3-20
- FOR EACH LOOP, 3-20
- FOR LOOP, 3-18
- CONTINUE
- statements, 3-26
- converting, 3-53
- CREATE TEMP TABLE
- statements, 3-49
- creating temporary tables, 3-49
D
- data storage concepts, 2-32
- data type mappings, 2-11
- data types, conversion considerations, 2-5
- DATETIME data type, 2-5
- DDL statements, 3-47
- DEBUG procedure
- configuring, 3-37
- DEBUG proedure
- overview, 3-37
- destination database, 1-3
- Disconnected Source Model Load, 6-1
- distributed environments, 4-2
- DOCUMENT
- clause, 3-13
- DROP TABLE
- statements, 3-50
- DUAL tables, 3-41
E
- error handling
- stored procedures, 3-47
- E/SQL, an Introduction to, 5-1
- ESQL/C to Oracle Pro*C Parser Errors, 5-14
- ESQL/C to Oracle Pro*C Warnings, 5-15
- ESQL/C to Pro*C Converter, Using the Converter, 5-2
- exception blocks, 3-42
F
- features, 1-2
- Flat File Generation Scripts, 6-1
- FOR EACH LOOP, 3-20
- FOR LOOP
- constructs, 3-18
- FOREACH . . SELECT. . INTO
- statements, 3-21
- FOREACH CURSOR
- statements, 3-22
- FOREACH execute procedure
- statements, 3-23
I
- IMAGE data type, 2-7
- Informix 4GL, 4-4
K
- keywords
- not supported by the Migration Workbench, 3-51
- used as identifiers, 3-51
L
- LIKE
- comparing, 3-17
M
- mapping
- triggers, 3-2
- MATCHES
- comparing, 3-17
- metadata flat files
- generating, 6-1
- Migration Wizard, 1-3
- modes
- IN, 3-8
- IN OUT, 3-8
- OUT, 3-8
- parameter passing, 3-7
- mutating tables, 3-4
N
- NULL
- executable statement, 3-6
O
- object names, 2-4
- Oracle Model, 1-3
- Oracle Pro*C Conversion, 5-4
- overview, 3-2, 3-5
- triggers, 3-2
P
- packages, 3-4
- utilities, 3-30
- paragraph tags
- PT PrefaceTitle, ix
- parameter passing
- logical parts, 3-7
- Oracle modes, 3-7
- parameters
- input, 3-8
- output, 3-9
- Pro*C, an Introduction to, 5-1
- product description, 1-1
- PT PrefaceTitle, ix
R
- RAISE EXCEPTION
- statements, 3-45
- remote objects
- Informix Dynamic Server, 4-3
- Oracle, 4-2
- repository, 1-4
- RETURN WITH RESUME
- statements, 3-27
- returning section, 3-10
- ROLLBACK WORK
- statements, 3-41
S
- savepoints, 3-40
- schema migration, 2-3
- SELECT
- statements, 3-41
- SET DEBUG FILE
- statements, 3-39
- SHELL stored procedures, 3-32
- set-up tasks for configuring, 3-32
- source database, 1-3
- Source Model, 1-4
- SPL statements, 3-10, 3-53
- statement
- NULL, 3-6
- statements
- BEGIN WORK, 3-40
- compound LET, 3-24
- CONTINUE, 3-26
- converting TRACE, 3-35
- CREATE TEMP TABLE, 3-49
- DDL statements, 3-47
- DROP TABLE, 3-50
- FOREACH execute procedure, 3-23
- issues with converting SPL statements, 3-53
- RAISE EXCEPTION, 3-45
- RETURN WITH RESUME, 3-27
- ROLLBACK WORK, 3-41
- SELECT, 3-41
- SELECT within IF condition, 3-41
- SET DEBUG FILE, 3-39
- SPL statements, 3-10
- SYSTEM, 3-31
- TRACE, 3-35
- WITH RESUME, 3-11
- statements, FOREACH . . SELECT. . INTO, 3-21
- statements, FOREACH CURSOR, 3-22
- stored procedures, 3-5
- error handling, 3-47
- overview, 3-5
- SHELL, 3-32
- subprograms, 3-2
- Syntactical Conversion Issues, 5-9
- ANSI Code, 5-10
- CURSOR Declaration, 5-12
- DECLARE CURSOR Statement, 5-12
- Double '=' in WHERE Clause, 5-10
- EXEC SQL Statement, 5-9
- FETCH Clause, 5-11
- FOR UPDATE Option, 5-13
- Header Files SQLNOTFOUND, 5-12
- INCLUDE Files, 5-10
- OUTER JOIN Syntax, 5-11
- UNIQUE Keyword in the SELECT Clause, 5-11
- UPDATE Statement, 5-10
- SYSTEM
- statements, 3-31
T
- table design considerations, 2-5
- table-level CHECK constraint, 2-8
- tables
- DUAL, 3-41
- temporary table usage, 5-1
- temporary tables
- creating, 3-49
- TEXT data type, 2-7
- The Pro*C Preprocessor, 5-14
- TRACE
- statements, 3-35
- Triggers, 3-2
- triggers
- mapping, 3-2
- mutating tables, 3-4
- overview, 3-2
U
- Using Demo Code, 5-24
- utilities package, 3-30
V
- variables, global, 3-14
W
- wildcard operators
- , 3-17
- %, 3-17
- ?, 3-17
- ^, 3-17
- _, 3-17
- enclosed characters, 3-17
- WITH RESUME
- procedure contains, 3-12
- procedure does not contain, 3-11
