Index
A B C D E F G I L M N O P R S T V
A
- add-in programs, 2-20
- application
- extending, 3-4
- migrating manually, 3-4
- architecture
- Oracle, 3-2
- AS/400 operating system, 1-2
B
- back-up facility, 2-5
- BIGINT numeric type, 2-15
- BLOB data type, 2-11
C
- CHAR data type, 2-10
- CHAR FOR BIT DATA data type, 2-10
- CHAR VARYING data type, 2-10
- CHAR VARYING FOR BIT DATA data type, 2-10
- CHARACTER data type, 2-10
- CHARACTER FOR BIT DATA data type, 2-10
- CHARACTER VARYING data type, 2-10
- CHARACTER VARYING FOR BIT DATA data type, 2-11
- CLOB data type, 2-11
- collection mappings
- table design considerations, 2-8
D
- data storage concepts
- IBM DB2/400 V4R3, 2-2
- overview, 2-1
- data type mappings, 2-10
- database security
- authorities, 2-19
- overview, 2-18
- user profiles, 2-19
- date date types, 2-18
- DB2/400 V4R3 Architecture, 3-1
- DBCLOB data type, 2-11
- DECIMAL numeric type, 2-17
- DOUBLE numeric type, 2-16
E
- extending, application, 3-4
F
- file types, 2-4
- logical files, 2-4
- physical files, 2-4
- FLOAT numeric type, 2-16
G
- GRAPHIC data type, 2-11
I
- implicit transaction model, 3-3
- INTEGER numeric type, 2-15
L
- library
- IBM DB2/400 V4R3, 2-2
- object name, 2-2
- object type and subtype, 2-2
- user profile, 2-4
- limitations
- parsable objects, 2-9
- privileges, 2-9
- schema migration, 2-8
- logical files
- file types, 2-4
- LONG VARCHAR data type, 2-11
- LONG VARGRAPHIC data type, 2-11
M
- manual migration, 3-4
- migrating
- manual, 3-4
- preparation, 3-3
N
- NUMERIC numeric type, 2-17
- numeric types, 2-15
O
- offline data loading, 3-4
- extract_nn add-n program, 3-4
- generating extract scripts, 3-6
- script directory structure, 3-6
- using the extract scripts, 3-7
- Oracle architecture, 3-2
P
- physical files
- file types, 2-4
R
- REAL numeric type, 2-17
- referential integrity constraints
- table design considerations, 2-7
S
- schema migration, 2-5
- schema naming convention, 2-3
- schema object names
- overview, 2-7
- schema objects, 2-6
- sequences, 3-3
- SQL/400, 1-2
- stored procedures, 3-3
- strings
- bit data, 2-12
- character strings, 2-12
- fixed-length character strings, 2-12
- graphic strings, 2-14
- mixed data, 2-12
- single byte character set data, 2-12
- varying-length character strings, 2-13
- SYSTEM tablespace, 2-1
T
- table design considerations, 2-7
- collection mappings, 2-8
- referential integrity constraints, 2-7
- tablespaces
- overview, 2-1
- transactions, implicit model, 3-3
- triggers, 3-3
V
- VARCHAR data type, 2-10
- VARCHAR FOR BIT DATA data type, 2-10
- VARGRAPHIC data type, 2-11
