Index
A B C D E F G H I J K L M N O P Q R S T U V W Z
A
- accessing AS/400 file members, 7.5
- Advanced Security, 1.2.1.3
- agent trace files
-
- Oracle net feature, A.2
- system changes when installing gateway, 1.8.1
- ALL_CATALOG view, description, C.1
- ALL_COL_COMMENTS view, description, C.2
- ALL_CONS_COLUMNS view, description, C.3
- ALL_CONSTRAINTS view, description, C.4
- ALL_DB_LINKS data dictionary view, examining available database links, 7.1.6
- ALL_IND_COLUMNS view, description, C.5
- ALL_INDEXES view, description, C.6
- ALL_OBJECTS view, description, C.7
- ALL_SYNONYMS view, description, C.8
- ALL_TAB_COLUMNS view, description, C.9
- ALL_TAB_COMMENTS view, description, C.10
- ALL_TABLES view, description, C.11
- ALL_USERS view, description, C.12
- ALL_VIEWS view, description, C.13
- ALTER SESSION CLOSE DATABASE LINK statement, 7.1.3
- ANO (Advanced Networking Option), gateway advantages, 1.2.1.3
- API (applications program interface), distributed processing, 5.1
- application development, database link, 9.1.1
- application server support, 1.2.1.3
- applications, SQL*Plus, 1.2.5
- architecture, gateway, 1.7
- array
-
- definition, 9.2
- processing
-
- array block size, 6.2
- tuning the gateway, 9.2
- ARRAY BLOCK SIZE parameter
-
- fetch reblocking, 9.2.1
- setting optional parameters, 6.2
- AS/400 database, accessing file members, 7.5
- AUTOCREATE CONTROLLER parameter, 5.3.3
B
- background processes in gateway, 1.7
- bequeath mechanism, TCP/IP, 5.4
- binary literal notation, restriction, 2.4.2.2
- bind variables
-
- Oracle bind variables become DB2/400 parameter markers, 9.11.1
- restriction
-
- binary literal notation, 2.4.2.2
- columns defined with RAW data, 2.4.2.4
- Oracle bind variables, 2.4.3.1
- BLOCKSIZE data area
-
- retrieving data, array processing, 6.2.1
- setting optional parameters, array processing, 6.2
- buffer size, ORA-28528 error, buffer too small for LONG data type, 2.4.3.4
C
- CCSID
-
- data conversion, 6.2.2
- NLS considerations, B.3
- supported character sets, B.3.1
- supported languages, B.3.2
- supported territories, B.3.2
- CFGTCP command, 5.7
- changes to the system upon installation, 1.8.1
- CHAR format, 9.8.5
- character set
-
- CCSID, data conversion, 6.2.2
- CHGORATUN command, B.2.1
- DB2/400 CCSID considerations, B.3
- DB2/400 GRAPHIC support, setting NLS_LANG, 9.8.1, B.6
- DBCS, double byte character set, 9.8.2
- GRAPHIC constants in SQL commands, 2.4.1.9
- NLS
-
- character settings must be compatible, B.1
- NLS_LANG specifies a single-byte character set, 9.8
- supported character sets, B.3.1
- server and client configuration, B.4
- SQL command to check character set of existing database, B.4
- CHARACTER SET parameter, B.4
- character strings
-
- converting data types, 9.8.4
- processing, 9.8.3
- CHECKSUM command
-
- Advanced Security, 1.2.1.3
- CHGGTWDBG command
-
- command description, 6.1.6
- purpose, 6.1
- CHGORANET command
-
- assigning a port number, 5.4.2
- changing parameter values in ORA(SQLNET), 5.1.5
- changing parameters, A.1.2.1
- purpose, 6.1
- trace files, 5.1.5.1
- CHGORAPJE command
-
- command description, 6.1.4
- prestarted jobs, 6.1.2
- purpose, 6.1
- CHGORATUN command
-
- changing default BLOCKSIZE, 6.2.1
- command description, 6.1.5
- data conversion, 6.2.2
- gateway configuration, B.2
- language specification, B.2.1
- number of DB2/400 cursors, 7.2
- purpose, 6.1
- CHGRECOPRF command
-
- caution to synchronize recovery password, 6.1.8, 8.8
- command description, 6.1.8
- password for recovery user profile, 6.1.2
- purpose, 6.1
- CHGUSRPRF command, password for recovery user profile, 6.1.2
- clauses
-
- CONNECT BY, example of when not supported, 9.10.1
- CONNECT TO, gateway security, 8.8
- FOR UPDATE
-
- SELECT statements without FOR UPDATE, 9.10.1
- with no column names, 9.10.2
- USING, creating a database link, 7.1.1
- WHERE, split processing, 9.10.1
- CLRPFM FILE command, clearing LOG file LISTENER member, A.1.1
- code examples
-
- accessing AS/400 file members, 7.5
- accessing data through database links, 7.1.4
- bind variable restrictions, 2.4.3.1
- checking authority of QWTSETP program in QSYS library, 4.4
- commands to give authority to gateway ID, 4.4
- CONNECT TO user ID provides implicit qualification for unqualified tables, 7.1.4
- converting character string data types, 9.8.4
- copying data from DB2/400 to Oracle, 7.9
- copying data with SQL*Plus commands, 7.8.2
- date and time operations, 9.8.5
- distributed query, SQL command one, 7.6.1.1
- distributed query, SQL command two, 7.6.1.2
- dropping database links, 7.1.5
- executing stored procedures, 9.4.1
- gateway appearance to application programs, 9.1
- INSERT statement
-
- from ASCII client, double-byte character support, 9.8.2.1
- with FORCE_SB option, 9.8.2.1
- interpreting gateway message formats, 10.1.2
- journaling, 4.5.3
- numeric data type operations, 9.8.7
- Oracle bind variables, statement fragments not allowed, 9.11.1
- passthrough function, 9.7.2
- retrieving results sets through passthrough, 9.7.4.1
- SQL expressions NOT supported for date arithmetic, 2.4.1.7
- SQL*Plus command to check character set of an existing database, B.4
- starting and stopping the gateway, 8.3.2
- streams code for simple table replication, 8.9
- to find primary authorization ID being used by gateway, using DB2/400 special registers, 9.12.2
- triggers for updating non-Oracle data, 7.8.1
- using the SQL*Plus COPY command, 7.8.2
- coded character set identifier (CCSID), B.3
- co-existence between gateways, 4.1
- COLUMN_PRIVILEGES view, description, C.14
- columns
-
- DECIMAL, 9.8.7
- INTEGER, 9.8.7
- NUMERIC, 9.8.7
- PACKED, 9.8.7
- ROUTINE_NAME, 9.4.1
- ROUTINE_SCHEMA, 9.4.1
- SMALLINT, 9.8.7
- commands
-
- summary of gateway commands, 6.1
- CFGTCP, troubleshooting TCP/IP configuration, 5.7
- CHGGTWDBG
-
- command description, 6.1.6
- purpose, 6.1
- CHGORANET
-
- assigning port number, 5.4.2
- command description, 6.1.3
- purpose, 6.1
- trace files, 5.1.5.1
- CHGORANET, changing parameter values in ORA(SQLNET), 5.1.5
- CHGORAPJE
-
- command description, 6.1.4
- purpose, 6.1
- CHGORATUN
-
- changing BLOCKSIZE, 6.2.1
- command description, 6.1.5
- data conversion, 6.2.2
- gateway configuration, B.2
- language specification, B.2.1
- purpose, 6.1
- CHGRECOPRF
-
- caution to synchronize recovery password, 6.1.8, 8.8
- purpose, 6.1
- CLRPFM FILE, clearing LOG file LISTENER member, A.1.1
- COPY
-
- general restrictions, 2.4.1.5
- note regarding limitations, 7.8.2
- CREATE COLLECTION, setting Instance Name parameter during gateway installation, 4.4.3.2
- CREATE MATERIALIZED VIEW, automatically and asynchronously copy DB2/400 server data, 7.9
- CREATE MATERIALIZED VIEW, copying DB2/400 server data, 7.9
- CREATE TABLE, copying DB2/400 server data, 7.9
- CRTLF, accessing OS/400 file members, 7.5
- CRTORADDB
-
- command description, 6.1.7
- purpose, 6.1
- CRTORAGTWI, purpose, 6.1
- CRTUSRPRF, message queue created in QUSRSYS library, 1.8.1
- DSPLIND, displaying line description parameters, 5.3.3
- DSPPGM, verifying installation and version of gateway, 4.5.2
- ENDSBS, starting and stopping the gateway, 8.3
- examples of codes and commands
-
- see code examples
- EXECUTE, using Oracle stored procedures, 1.2.3.1
- INSERT, copying data from DB2/400 server, 7.9
- JOIN, accessing tables in multiple databases, 9.1.3
- ORAMON
-
- gateway architecture, 1.7
- starting the Oracle Gateway Monitor, 8.2
- PING, verifying host name, 5.4.4
- RUNSQLSTM, required for cloning an instance, 3.2.1
- SBMJOB, removing IBM observability, 4.5.6
- SQL*Plus
-
- COPY, DB2/400 Server to Oracle server, 7.9
- COPY, limitation when copying to the DB2/400 server, 7.8.2
- COPY, Oracle server to DB2/400 Server, 7.8
- INSERT, not supported to copy tables from Oracle server to gateway, 7.8.2
- SQL, creating database links using Oracle Net, 7.1.2
- STRORALSN, starting TCP/IP listener manually, 5.4.5
- STRSBS, OS/400 command to start gateway, 1.7
- WRKTRCLOG, make sure instance library is in library list before using this command, A.1.3
- commit confirm protocol, 1.3
- commit point site, in distributed transactions, 7.6.2
- COMMIT_POINT_STRENGTH setting, 7.6.2
- commitment control
-
- considerations for using stored procedures with DB2/400, 9.4.2
- journaling default setting, 4.5.1
- compatible SQL functions, defined, 9.9
- compensated SQL functions, defined, 9.9
- CONCAT translated SQL function, 9.9
- concurrent connections, TCP/IP, memory, 3.1.2
- CONNECT BY clause
-
- limitation, 9.10.1
- not supported in SQL, 2.4.3.2
- CONNECT TO clause
-
- accessing data through database links, 7.1.4
- accessing the gateway, 7.4
- creating database links, 7.1.1
- gateway security, 8.8
- connection errors, 5.6
- conventions for code input and output, Preface
- convert SQL to make compatible with DB2/400 server, 1.8.2
- COPY command
-
- from Oracle server to DB2/400 Server
-
- compared with triggers, 7.8
- examples, 7.8.2
- general restrictions, 2.4.1.5
- note regarding limitations, 7.8.2
- copying
-
- data
-
- from the DB2/400 server, 7.9
- from the Oracle Database Server, 7.8.2
- to DB2/400 server, 7.8
- the gateway instance, CRTORAGTWI command, 6.1.2
- CREATE COLLECTION command, installation procedure, setting required parameters, 4.4.3.2
- CREATE DATABASE LINK command, and define a path to the gateway, 7.1.1
- CREATE MATERIALIZED VIEW
-
- command, automatically and asynchronously copy DB2/400 server data, 7.9
- complete refresh, propagate a complete copy or a subset, 7.9
- CREATE SNAPSHOT command, replaced by CREATE MATERIALIZED VIEW command, 7.9
- CREATE TABLE command
-
- copy data from DB2/400 server to Oracle Database server, 7.9
- passthrough and native DB2/400 SQL, 1.2.2.1
- CRTLF command, accessing OS/400 file members, 7.5
- CRTORADDB command
-
- description, 6.1.7
- purpose, 6.1
- CRTORAGTWI command
-
- description, 6.1.2
- instructions, 6.1.2
- purpose, 6.1
- CRTUSRPRF command, creating user profile, message queue created in QUSRSYS library, 1.8.1
- cursor stability, journaling, 4.5.1
- cursors for DB2/400, maximum number, 7.2
D
- data control language (DCL), issue native DCL from Oracle environment, 1.2.2.1.2
- data conversion, setting optional parameters, 6.2.2
- data definition language (DDL), Oracle applications use native DDL, 1.2.2.1.1
- data dictionary
-
- create gateway, installation panel option, 6.1.2
- creating views, batch job, 6.1.7
- emulation in DB2/400 server, 9.12
- installation and support, 4.4.3.2
- post-installation steps, of gateway, 4.5
- tables, restriction with v4 gateways, 2.4.1.3
- using, 9.12.1
- views
-
- ALL_CATALOG, description, C.1
- ALL_COL_COMMENTS, description, C.2
- ALL_CONS_COLUMNS, description, C.3
- ALL_CONSTRAINTS, description, C.4
- ALL_DB_LINKS, examining available database links, 7.1.6
- ALL_IND_COLUMNS, description, C.5
- ALL_INDEXES, description, C.6
- ALL_OBJECTS, description, C.7
- ALL_SYNONYMS, description, C.8
- ALL_TAB_COLUMNS, description, C.9
- ALL_TAB_COMMENTS, description, C.10
- ALL_TABLES, description, C.11
- ALL_USERS, description, C.12
- ALL_VIEWS, description, C.13
- augmenting DB2/400 database catalogs, 9.12
- COLUMN_PRIVILEGES, description, C.14
- DBA_DB_LINKS, accessible only to users with DBA authorization, 7.1.6
- DICTIONARY, description, C.15
- DUAL, description, C.16
- examining available database links, 7.1.6
- OTGREGISTER, description, C.17
- OTGREGISTER, finding primary authorization ID being used by gateway, 9.12.2
- TABLE_PRIVILEGES, description, C.18
- USER_CATALOG, description, C.19
- USER_COL_COMMENTS, description, C.20
- USER_CONS_COLUMNS, description, C.21
- USER_CONSTRAINTS, description, C.22
- USER_DB_LINKS, examining available database links, 7.1.6
- USER_INDEXES, description, C.23
- USER_OBJECTS, description, C.24
- USER_SYNONYMS, description, C.25
- USER_TAB_COLUMNS, description, C.26
- USER_TAB_COMMENTS, description, C.27
- USER_TABLES, description, C.28
- USER_USERS, description, C.29
- USER_VIEWS, description, C.30
- data types
-
- conversion
-
- for Oracle tools, 9.8
- from DB2/400 to Oracle, B.6
- Oracle to DB2/400 data types, 9.8
- converting character strings, 9.8.4
- DATE, performing Date and Time operations, 9.8.5
- DB2/400 GRAPHIC, 9.8.1
- IBM DATE, Oracle DATE data types and IBM DATE data types are mapped to each other, 9.8.5
- LONG
-
- converting character string data types, 9.8.4
- known restriction, 2.4.3.4
- LONG VARCHAR, 9.8.4
- Oracle DATE, Oracle DATE data types and IBM DATE data types are mapped to each other, 9.8.5
- restrictions, 9.8
- TIME, performing Date and Time operations, 9.8.5
- TIMESTAMP, performing Date and Time operations, 9.8.5
- VARCHAR, DB2 data type converted to Oracle VARCHAR2 data type, 9.8.4
- zoned decimal, 9.11.2
- DATABASE DOMAIN parameter, 6.1.5
- database link
-
- accessing data, 7.1.4
- behavior, 7.1
- closing, 7.1.3
- connecting to DB2/400 databases, 9.1.1
- creating, 7.1.1
- data dictionary views
-
- ALL_DB_LINKS, 7.1.6
- DBA_DB_LINKS, 7.1.6
- USER_DB_LINKS, 7.1.6
- dropping links, 7.1.5
- examining, 7.1.6
- function in the gateway, 1.8
- limiting, 7.1.7
- using Oracle Net, 7.1.2
- database triggers, extended database services, 1.2.1.2
- date and time operations, Oracle and DB2/400, 9.8.5
- date arithmetic, restriction, 2.4.1.7
- DATE data type, performing Date and Time operations, 9.8.5
- dates
-
- 21st century
-
- main topic, 9.8.6
- TO_DATE function, 9.8.6
- DB_DOMAIN parameter, Oracle Database Server, 2.4.2.5
- DB2/400
-
- Application Server, 1.7
- cursors, maximum number, 7.2
- database
-
- read, 9.1
- write, 9.1
- differences from Oracle server, 9.11
- executing stored procedures, 9.4.1
- GRAPHIC data type support and NCHAR, 9.8.1
- native SQL, 1.2.2.1
- native stored procedures
-
- journal the ORACLE2PC table, 1.2.3.2
- using DB2/400 stored procedures with the gateway, 9.4
- server
-
- compatibility with SQL form, 1.8.2
- triggers, 7.8.1
- VALUE function, SQL differences, 1.8.2
- DBA_DB_LINKS data dictionary view, 7.1.6
- DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 9.7
- DCL, issue native DCL from Oracle environment, 1.2.2.1.2
- DD basic tables
-
- restriction, 2.4.2.1
- DDL, Oracle applications use native DDL, 1.2.2.1.1
- debugging parameters, changing, 6.1.6
- DECnet protocol, 1.2.1.1
- default configuration of gateway as commit point site, 1.3
- DELETE clause, Oracle server cannot post-process, 9.10.2, 9.10.2
- design, gateway architecture, 1.7
- developing applications, 9.1
- diagnosing errors, 10.1.3
- dictionary mapping, 1.2.1.4
- DICTIONARY view, description, C.15
- distributed
-
- database, Oracle Net, 5.1.2
- processing, Oracle Net, 5.1.1
- queries, 7.6
- documentation
-
- errors, 10.3.1
- requirements, 3.3
- domain name, configuring TCP/IP, defining host name, 5.4.3
- double-byte character support, 9.8.2.1
- DROP DATABASE LINK statement, example, 7.1.5
- DSPLIND command, displaying line description parameters, 5.3.3
- DSPPGM command, verifying gateway installation and version, 4.5.2
- DUAL view, description, C.16
E
- EDTOBJAUT command, to check authority, 4.4
- EMPDB2 synonym, using the synonym feature, 7.3
- ENDSBS command
-
- authorization to stop a gateway, 8.3
- stopping a gateway, 8.3.2
- error
-
- ORA-1017, invalid user ID or password, caution to synchronize recovery password, 6.1.8
- ORA-12154 connection error, resolving connection problems, 5.6.5
- ORA-2068 connection error, resolving connection problems, 5.6.2.1
- ORA-28500
-
- file not journaled, 4.5.3
- resolving connection problems, 5.6.4
- ORA-28509, connection error, resolving connection problems, 5.6.2
- ORA-28511, connection error, resolving connection problems, 5.6.3
- ORA-28528, example - buffer too small for LONG data type, 2.4.3.4
- ORA-3114, connection error, resolving connection problems, 5.6.2.1
- SQL0105, "Mixed or Graphic String Constant Not Valid.", 9.8.2.1
- errors
-
- diagnosing via categories, 10.3
- mapping DB2/400 messages to Oracle, 10.1.1
- messages, diagnosis, and reporting, 10
- reporting
-
- documentation, 10.3.1
- external Oracle error messages, 10.3.3
- incorrect output, 10.3.2
- performance, 10.3.4
- examples
-
- conventions for code input and output, Preface
- examples of codes and commands
-
- see code examples
- gateway security, example code lines, 4.4
- EXECUTE command, beginning a PL/SQL routine, 1.2.3.1
F
- fetch reblocking, array processing, 9.2.1
- file
-
- INIT.ORA
-
- GLOBAL_NAMES initialization parameter, 2.4.2.5
- initialization parameter notes, 6.1.5
- TNSNAMES.ORA
-
- creating a database link, 7.1.1
- need SID for TCP/IP, 5.2.2
- file members, accessing, 7.5
- flat files, accessing, 7.5.1
- FOR BIT DATA option, binary literal notation, 2.4.2.2
- FOR UPDATE clause
-
- NOWAIT option, 9.10.2
- SELECT without FOR UPDATE clause, 9.10.1
- FORCE_SBCS, string to force double-byte character support, 9.8.2.1
- functions
-
- CONCAT, translated SQL function, 9.9
- DB2/400 VALUE, SQL differences, 1.8.2
- DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 9.7, 9.7, 9.7.3
- NVL, SQL differences, 1.8.2
- SQL
-
- column, 9.9
- compensated, 9.9
- scalar, 9.9
- translated, 9.9
- SQL differences, converting Oracle Database server NVL function to VALUE, 1.8.2
- SUBSTR, always post-processed by Oracle server, 1.8.2
- SUBSTR, not same in Oracle server and other database servers, 1.8.2
- TO_DATE, dates in the 21st century, 9.8.6
- TRANSLATE, translated SQL function, 9.9
- VALUE, translated SQL function, 9.9
G
- gateway
-
- access, 7.4
- advantages
-
- main topic, 1.2.1
- migration and coexistence, 1.5
- multisite transactions, 1.3
- security, 1.6
- site autonomy, 1.4
- two-phase commit and multisite transactions, 1.3
- architecture, 1.7
- array processing, 9.2
- call stack, displaying, 8.5
- changes made to the AS/400 system, 1.8.1
- co-existence with previous gateways, 4.1
- commands
-
- main topic, 6.1
- CHGGTWDBG, isolating cause of suspected gateway problem, 6.1.6
- CHGORANET, changing language settings, B.2
- CHGORANET, changing network parameters, 6.1.3
- CHGORANET, changing parameters, A.1.2.1
- CHGORAPJE, changing prestarted job parameters, 6.1.4
- CHGORATUN, changing BLOCKSIZE default value, 6.2.1
- CHGORATUN, changing initialization parameters, authority required, 6.1.5
- CHGORATUN, changing language settings, gateway configuration, B.2
- CHGRECOPRF, changing recovery user password, 6.1.2
- CHGUSRPRF, changing recovery user password in OS/400, 6.1.2
- CRTORAGTWI, creating a gateway instance copy, 6.1.2
- menu to access, 6.1.1
- running, 6.1.1
- summary of commands, 6.1
- components
-
- DB2 server, 1.7
- Oracle Database 10g Server, 1.7
- transparent gateway, 1.7
- default configuration as commit point site, 1.3
- development applications, 9.1
- how it works, 1.8
- initialization parameters, 6.1.5
- job locks, 8.6
- jobs, 7.4.1
- known restrictions, 2.4
- library files, A.1.1
- multiple copies, 6.1.2
- NLS configuration, B.2
- no continuously running background processes, 1.7
- post-installation, 4.5
- raising priority level, 4.5.7
- removing observability, 4.5.6
- retrieving data, 6.2.1
- security, 8.8
- setting optional parameters, 6.2
- starting, 8.3.2
- stopping, 8.3.2
- transparency levels, 1.2.1.1
- two-phase commit processing
-
- protocol limitation in distributed transaction, 7.6.2
- using Oracle stored procedures with the gateway, 9.3
- using Oracle stored procedures, 9.3
- verifying the version, 4.5.2
- gateway monitor
-
- see Oracle gateway monitor
- GATEWAY NATIONAL LANGUAGE parameter, 6.1.5
- GENERAL linkage convention, 9.4.2
- GENERAL WITH NULLS linkage convention, 9.4.2
- GLOBAL_NAMES, known restrictions, 2.4.2.5
- GO CMDORAGTW command, invoking main menu, 6.1.1
- GRAPHIC data type, support for DB2/400, B.6
H
- hanging condition, connection problems, 5.6
- hardware requirements, 3.1
- heterogeneous services
-
- enhanced integration capabilities, 1.2
- initialization parameters, known restrictions for DB2/400, 2.4.2.5
- host name, TCP/IP configuration, 5.4.3
- HS= parameter, mandatory keyword, using TCP/IP connect descriptor, 5.2.1
- HS_DB_DOMAIN, Heterogeneous Services initialization parameter, 2.4.2.5
- HS_RPC_FETCH SIZE parameter, 9.2.1
- HS_RPC_FETCH_REBLOCKING parameter, 9.2.1
I
- IBM DATE data type, 9.8.5
- implicit protocol conversion, 1.2.1.3
- incorrect output, errors, 10.3.2
- Incremental Materialized View refresh, gateway restriction, 2.4.3.3
- inherit mechanism, TCP/IP, 5.4
- initialization parameters
-
- changing, 6.1.5
- GLOBAL_NAMES, 2.4.2.5
- INIT.ORA file
-
- GLOBAL_NAMES initialization parameter, 2.4.2.5
- initialization parameter notes, 6.1.5
- INSERT clause, Oracle server cannot post-process, 9.10.2, 9.10.2
- INSERT command
-
- copy data from DB2/400 server to Oracle Database server, 7.9
- not supported to copy tables, 7.8.2
- restriction, 2.4.1.5
- INSERT statement, example for double-byte character support, 9.8.2.1
- installation
-
- before installing, pre-installation steps, 4.3
- checking distribution kit, 3.4
- completion, 4.4.5
- mount product tape, 4.4.1
- required parameters, 4.4.3
- set required parameters, 4.4.3
- start process, 4.4.2
- starting the gateway subsystem, 4.4.6
- verify, 4.4.4
- INTEGER column, performing numeric data type operations, 9.8.7
- Integrated File System
-
- system changes when installing the gateway, 1.8.1
- internal process communication, 5.4
- Internet support, gateway advantages, 1.2.1.3
- isolation level
-
- journaling 4.5.1, 4.5.1
- using passthrough statements to create tables, 9.7.3
- isolation level, journaling, default setting, 4.5.1
J
- job locks, working with gateway job locks, 8.6
- job logs, finding gateway version, RUNORAGxxx job, 4.5.2
- JOBCTL special authority, 4.4
- jobs, viewing, 7.4.1
- JOIN capability, distributed capabilities, 1.2.1.2
- JOIN command, accessing tables in multiple databases, 9.1.3
- journaling
-
- AS/400 files, 4.5.3
- cursor stability, 4.5.1
- definition, 4.5.1
- error messages, 9.7.3
- isolation level, default, 4.5.1
- new tables, 9.7.3
- ORACLE2PC file, 4.5.4
- requirements, 4.5.1
- Julian dates, restriction, 2.4.1.8
K
- known problems, 2.3
- known restrictions
-
- date arithmetic, 2.4.1.7
- DB2/400
-
- components, 2.4.2
- GLOBAL_NAMES initialization parameter, 2.4.2.5
- OCI, 2.4.2.3
- snapshots, 2.4.1.4
L
- Languages, gateway architecture, 1.2.4
- libraries
-
- created as a SQL collection, journaling, 4.5.3
- data dictionary created in library OTGDB2, 4.4.3.2
- installation procedure creates new, or uses pre-existing, but empty, library, 4.4.3.2
- library files, LOG file members, A.1.1
- library is created, gateway changes to AS/400 system, 1.8.1
- member names in gateway library files, A
- new tables, 9.7.3
- Oracle Net parameter files are installed in gateway instance library, 5.1.5
- ORASRVLIB, 1.8.1
- QSYS, checking authority of QWSETP program, 4.4
- QUSRSYS, 1.8.1
- starting the Oracle Gateway Monitor, 8.2
- syntax for accessing flat files, 7.5.1
- target library, using passthrough statements to create tables, 9.7.3
- listener
-
- client connection, 5.1.4
- Oracle Net for AS/400 architecture, 5.1.4
- prestarted jobs, 5.1.4
- TNS, 5.1.4
- LISTENER member
-
- clearing entries to reduce size of LOG file, A.1.1
- in LOG file, A.1.1
- of ORA file, A.1.2.1
- LISTENLOCK, member of ORA file, A.1.2.3
- literal values, restriction, 2.4.2.2
- local domain name, TCP/IP configuration, 5.4.3
- local host name, TCP/IP configuration, 5.4.3
- LOG file members, Oracle Net, A.1.1
- logical file members, OS/400 logical files, 7.5
- LONG data type
-
- converting character string data types, 9.8.4
- restriction, 2.4.3.4
- LONG VARCHAR data type, 9.8.4
M
- mapping error messages, 10.1.1
- Materialized View
-
- old name was "snapshot", 7.7.2
- can be used to propagate a complete copy or a subset of non-Oracle data, 7.7.2
- CREATE MATERIALIZED VIEW command, automatically and asynchronously copy DB2/400 server data, 7.9
- Incremental Materialized View refresh
-
- gateway restriction, 2.4.3.3
- member
-
- command to display members of ORA file, A.1.2.6
- accessing AS/400 file members, 7.5
- LISTENER, member of ORA file, A.1.2.1
- LISTENLOCK, member of ORA file, A.1.2.3
- LOG file, A.1.1
- names format, 5.1.5
- ORA file, A.1.2
- SQLNET, 5.1.5
- SQLNET, member of ORA file, A.1.2.4
- SQLNET_CHG, member of ORA file, A.1.2.5
- TRC file, A.1.3
- messages
-
- and error code processing, 10.1
- diagnosing, 10.1.3
- error, 10
- journaling, 9.7.3
- ORA-00947, 10.1.3
- Metalink Note 136294.1, connection problems, 5.6.2.1
- missing functionality, error categories, 10.3.5
- Mobile Agents, wireless communication, 1.2.1.3
- monitoring the gateway
-
- overview, 8.1
- starting Oracle gateway monitor, 8.2
- multiple rows, retrieving, 6.2.1
- multisite transactions, 1.3
N
- National Language Support, See NLS, B
- network parameters, changing, 6.1.3
- NLS
-
- CCSID
-
- Oracle language parameters must match, B.3
- supported character sets, B.3.1
- supported languages, B.3.2
- supported territories, B.3.2
- gateway commands
-
- CHGORANET, B.2, B.2
- CHGORATUN, B.2
- gateway configuration
-
- changing language settings, B.2
- CHGORATUN language specification, B.2.1
- message availability, B.5
- Oracle server and client configuration, B.4
- overview, B.1
- NOWAIT option, example when not supported, 9.10.2
- null values, with stored procedures, 9.4.2
- numeric column, performing numeric data type operations, 9.8.7
- numeric data type, DB2/400 performs automatic conversions, 9.8.7
- NVARCHAR2 data types, DB2/400 GRAPHIC support, 9.8.1
- NVL function, SQL differences, 1.8.2
O
- observability, gateway is shipped with IBM observability, it can be removed, 4.5.6
- OCI restriction (Oracle Call Interface), programmatic limitation, 2.4.2.3
- OPEN_LINKS parameter, limiting the number of active database links, 7.1.7
- operations, date and time, 9.8.5
- ORA file members, A.1.2
- ORA(LISTENER) file
-
- contains parameter values for the listener, A.1.2.1
- making changes with ORA(LISTENER_CHG), A.1.2.2
- some network parameters not displayed on CHGORANET panel, 6.1.3.2
- ORA(LISTENER_CHG) file, used to make changes to ORA(LISTENER) file, A.1.2.2
- ORA(LISTENLOCK) file, ensuring only one instance of RUNORALSN program is running, A.1.2.3
- ORA(SQLNET) file
-
- contains network parameter values for Oracle Net, A.1.2.4
- some network parameters not displayed on CHGORANET panel, 6.1.3.1
- ORA-00947 error message, not accompanied by DB2/400 error messages, 10.1.3
- ORA-1017 error, invalid user ID or password, 6.1.8
- ORA-12154 connection error, resolving connection problems, 5.6.5
- ORA-2068 connection error, resolving connection problems, 5.6.2.1
- ORA-28500 error
-
- file not journaled, 4.5.3
- resolving connection problems, 5.6.4
- ORA-28509 connection error, resolving connection problems, 5.6.2
- ORA-28511 connection error, resolving connection problems, 5.6.3
- ORA-28528 error, example - buffer too small for LONG data type, 2.4.3.4
- ORA-3114 connection error, resolving connection problems, 5.6.2.1
- Oracle Call Interface (OCI), restriction, programmatic limitation, 2.4.2.3
- Oracle Database 10g server
-
- post-processing of SUBSTR SQL function, 2.4.2.7
- Oracle Database Server
-
- copying data from the DB2/400 server, 7.9
- database links, 1.8
- database triggers, 1.2.1.2
- differences from DB2/400, 9.11
- distributed capabilities, 1.2.1.2
- distributed query optimization, 1.2.1.2
- extended database services, 1.2.1.2
- mapping DB2/400 error messages, 10.1.1
- performing character string operations, 9.8.3
- SQL, extended database services, 1.2.1.2
- stored procedures, 1.2.1.2
- triggers
-
- copying data from Oracle server, 7.8.1
- replicating in a distributed environment, 7.7.1
- two-phase commit protection, 1.2.1.2
- Oracle Database server
-
- and array size, 9.2.1, 9.2.1
- and error detection, 10.1.3
- copying data to DB2/400 server, 7.8
- date and time operations, 9.8.5
- initialization parameter notes, 6.1.5
- Oracle DATE data type, 9.8.5
- Oracle Developer
-
- Forms compatibility, 9.13
- Oracle gateway monitor
-
- display gateway call stack, 8.5
- display open files, 8.7
- ORAMON command, 8.2
- overview, 8.1
- starting, 8.2
- starting and stopping gateway, 8.3
- starting TCP/IP listener, 8.4
- working with gateway job locks, 8.6
- working with gateway jobs, 8.3.1
- Oracle integrating server
-
- and GLOBAL_NAMES initialization parameter, 2.4.2.5
- function
-
- regarding SQL, 1.8.2
- Oracle Net
-
- chapter, 5
- API, 5.1
- communications, 5.1.4
- configuration supported by Oracle server, 1.2.6
- configuring, 4.5.5
- configuring APPC/LU6.2
-
- define physical line, 5.3.3
- configuring TCP/IP
-
- checklist, 5.4.1
- define local host name, 5.4.3
- for TCP/IP AS/400, 5.4
- modify port number, 5.4.2
- start the listener, 5.4.5
- verify host name, 5.4.4
- connecting
-
- TCP/IP, 5.2.2
- connecting TCP/IP
-
- add connect descriptor, 5.2.1
- checklist, 5.2, 5.3.2
- to AS/400, 5.2
- connections, Oracle Net for AS/400 architecture, 5.1.4
- creating database links, 7.1.2
- distributed database, 5.1.2
- distributed processing, 5.1.1
- file names, 5.1.5
- listener, 5.1.4
- LOG file members, A.1.1
- ORA file members, A.1.2
- overview, 5.1
- TCP/IP listener, default trace output file, A.1.3
- terminology
-
- client, 5.1.3
- driver, 5.1.3
- host, 5.1.3
- network, 5.1.3
- protocol, 5.1.3
- terminology, main topic, 5.1.3
- tracing job members, 5.1.5.1
- TRC file members, A.1.3
- Oracle Precompilers
-
- restriction, 2.4.2.6
- Oracle subsystem
-
- error reporting, 10.3.3
- Oracle Support Services
-
- contacting, 10.2
- ORACLE2PC
-
- file
-
- journaling two-phase commit transactions, 4.5.4
- recording two-phase commit transactions, 7.6.2
- table, using DB2/400 stored procedures, 1.2.3.2
- ORADBMBOPT Data Area (or Environment variable), 9.8.2.1
- ORAMON command
-
- starting the gateway, 1.7
- starting the Oracle gateway monitor, 8.2
- ORARAW, data area, 6.2
- ORASRVLIB library, creation, 1.8.1
- OTGREGISTER view
-
- description, C.17
- finding primary authorization ID being used by gateway, 9.12.2
- outer joins, SQL functions, 1.2.1.2
P
- PACKED DECIMAL column, performing numeric data type operations, 9.8.7, 9.8.7
- panel examples
-
- Change Oracle Gateway Debugging Option, 6.1.6
- Change Oracle Gateway Initialization Parameters (page 1), 6.1.5
- Change Oracle Gateway Initialization Parameters (page 2), 6.1.5
- Change Oracle Network Parameters, 6.1.3
- Change Oracle Prestart Parameters, 6.1.4
- Change Recovery Profile Parameters, 6.1.8
- Change TCP/IP Domain (CHGTCPDMN), 5.4.3
- CMDORAGTW Oracle Commands, 6.1.1
- Create Oracle Transparent Gateway, 6.1.2
- Create Oracle Transparent Gateway Panel, with new values, 6.1.2
- Install Oracle Transparent Gateway, 4.4.3.2
- Install Oracle Transparent Gateway Panel, With Name Choices, 4.4.3.2
- Verify Oracle Install, 4.4.4.2
- parameters
-
- ARRAY BLOCK SIZE, 9.2.1
- ARRAY BLOCK SIZE, setting, 6.2
- AUTOCREATE CONTROLLER, 5.3.3
- data dictionary, 6.1.7
- DATABASE DOMAIN, 6.1.5
- DB_DOMAIN
-
- Oracle9 server, 2.4.2.5
- debugging, 6.1.6
- HS_DB_DOMAIN, Heterogeneous Services initialization parameter, 2.4.2.5
- HS_PRC_FETCH_REBLOCKING, 9.2.1
- HS_RPC_FETCH SIZE, 9.2.1
- initialization, 6.1.5
- network, 6.1.3
- OPEN_LINKS, 7.1.7
- optional, 6.2
- READONLY, 6.2.3
- required, 4.4.3
- RPC FETCH REBLOCKING
-
- *YES is default value, 9.2.1
- array size for SELECT, 9.2.1
- initialization parameter notes, 6.1.5
- may be changed by CHGORATUN command, 9.2.1
- RPC FETCH SIZE
-
- array size for SELECT, 9.2.1
- initialization parameter notes, 6.1.5
- may be changed by CHGORATUN command, 9.2.1
- setting optional parameters for gateway configuration, 6.2
- setting required parameters for gateway installation, 4.4.3
- SQLNET.ORA, file name structure, 5.1.5
- passthrough
-
- and Native DB2/400 SQL, introduction, 1.2.2.1
- examples, 9.7.2
- function, 9.7
- result sets
-
- example, 9.7.4.1
- retrieval, 9.7.4
- sending SQL statement directly to DB2/400 without being interpreted by Oracle server, 9.7
- performance issues, 10.3.4
- PING command
-
- troubleshooting gateway configuration, 5.7.1
- verifying host name, 5.4.4
- PL/SQL
-
- routine, 1.2.3.1
- standard Oracle, 1.2.3.2
- port number
-
- changing the default gateway port number, 5.4.2
- configuring for listener, 5.4.2
- default used by Oracle Net listener (1521), 5.2.1
- TCP/IP
-
- gateway installation panel, 4.4.3.2
- name choices of install panel, 4.4.3.2
- post-installation
-
- configure Oracle Net, 4.5.5
- journal ORACLE2PC file, 4.5.4
- raise priority level, 4.5.7
- remove observability, 4.5.6
- steps, 4.5
- verify journaling, 4.5.3
- post-processing of SQL functions, 1.8.2
- precompiler limitations, 2.4.2.6
- prestarted jobs, changing parameters, 6.1.4
- priority level, raising gateway level, 4.5.7
- processing SQL, 9.10
- processor requirement, 3.1.1
- product set, 2.1
- protocols
-
- APPC/LU6.2, 1.2.1.1
- commit confirm, 1.3
- DECnet, 1.2.1.1
- definition, 5.1.3
- SPX/IPX, 1.2.1.1, 1.2.1.3
- TCP/IP, 1.2.1.1, 1.2.1.3
Q
- QCCSID, default coded character set identifier, 6.2.2
- QCRTAUT parameter
-
- do not use value *EXCLUDE, 4.3.2
- restriction, 2.4.1.6
- QSECOFR user class, log on authority, 4.3.1
- QSYS2/SYSPARMS DB2/400 table, 9.4.1
- QSYS2/SYSPROCS DB2/400 table, 9.4.1
- qualified host name
-
- description, 5.4.3
- Option 12 of CFGTCP, 5.7.2
- queries, distributed, example, 7.6.1
- queries, distributed, performing, 7.6
- QUSRSYS library, creating user profile that corresponds to installation library, 1.8.1
R
- RAW
-
- columns, restriction, 2.4.2.2
- data restrictions, 2.4.2.4
- reading DB2/400 database, read and write access, 9.1.2
- read-only capabilities on the gateway, 6.2.3
- READONLY parameter, read-only gateway option may provide improved performance and security, 6.2.3
- recovery
-
- process, 7.6.2.1
- user and password, 6.1.2
- release information, 2
- remote transaction program, 3.1.2
- replication, heterogeneous environment, 7.7
- requirements
-
- documentation, 3.3
- hardware, 3.1
- software, 3.2
- software, journaling, 4.5.1
- result sets, retrieving with passthrough, 9.7
- retrieving multiple rows
-
- array processing, 9.2
- using BLOCKSIZE, 6.2.1
- ROUTINE_NAME column, executing DB2/400 stored procedures, 9.4.1
- ROUTINE_SCHEMA column, executing DB2/400 stored procedures, 9.4.1
- routines, PL/SQL, 1.2.3.1
- RPC FETCH REBLOCKING parameter
-
- *YES is default value, 9.2.1
- entering on Change Oracle Gateway Initialization Parameters panel, 6.1.5
- initialization parameter notes, 6.1.5
- may be changed by CHGORATUN command, 9.2.1
- RPC FETCH SIZE parameter
-
- changing initialization parameters, 6.1.5
- entering on Change Oracle Gateway Initialization Parameters panel, 9.2.1, 9.2.1
- running gateway commands, 6.1.1
- RUNORALSN program runs the TCP/IP listener, A.1.2.3
- RUNSQLSTM command required for cloning an instance, 3.2.1
S
- SBMJOB command
-
- QSECOFR ID, 4.5.6
- removing IBM observability, 4.5.6
- SECADM special authority, 4.3.1
- security
-
- advanced, 1.2.1.3
- ANO, 1.2.1.3
- encryption, 1.2.1.3
- on the gateway, 8.8
- SELECT FOR UPDATE clause, Oracle server cannot post-process, 9.10.2
- SELECT statement
-
- array size in fetch reblocking, 9.2.1
- read and write access to DB2/400 databases, 9.1.2
- SELECT without the FOR UPDATE clause, 9.10.1
- SQL differences, 1.8.2
- session connection, 7.1
- SID names, specifying, 5.2.2
- SMALLINT column, performing numeric data type operations, 9.8.7
- snapshot
-
- complete refresh
-
- restriction, fast refresh snapshots not supported, 2.4.1.4
- older name for Oracle Materialized View, see Materialized View, 7.7.2
- software requirements, 3.2
- special authority
-
- *JOBCTL, 4.4
- *SECADM, 4.3.1
- special registers in DB2/400, 9.12.2
- SPX/IPX protocol
-
- implicit protocol conversion, 1.2.1.3
- network transparency, 1.2.1.1
- SQL
-
- ANSI standard, 1.2.2
- commands, 7.1.2
- compatibility with gateway through Oracle integrating server, 1.8.2
- constructs, processing, 9.10
- conversion for compatibility withDB2/400 server, 1.8.2
- differences, 1.8.2
- functions
-
- column, 9.9
- compatibility, 9.9
- compensated, 9.9
- scalar, 9.9
- translated, 9.9
- ISO standard, 1.2.2
- known restrictions, 2.4.3
- limitations, 2.4.3
- passthrough, 9.7
- statements
-
- gateway appearance to application programs, 9.1
- passing SQL statements through gateway, 9.7
- SQL*Plus
-
- commands
-
- COPY, copying data from Oracle to DB2/400-7.8, 7.8
- COPY, general restrictions, 2.4.1.5
- COPY, limitation, 7.8.2
- INSERT, limitation, 7.8.2
- moving data between databases, 1.2.5
- SQL0105 error, "Mixed or Graphic String Constant Not Valid.", 9.8.2.1
- SQLNET member, file name structure, 5.1.5
- SQLNET(ORA) file,file name structure, 5.1.5
- SQLNET, member of ORA file, A.1.2.4
- SQLNET_CHG, member of ORA file, A.1.2.5
- SQLNET.ORA parameter, mapped to member SQLNET, 5.1.5
- starting the gateway, 8.3.2
- statements
-
- ALTER SESSION CLOSE DATABASE LINK, 7.1.3
- CONNECT TO, 7.1.4
- CREATE DATABASE LINK, 7.1.1
- DB2
-
- CREATE TABLE, 1.2.2.1
- DROP DATABASE LINK, 7.1.5
- INSERT, example for double-byte character support, 9.8.2.1
- SELECT
-
- fetch reblocking, 9.2.1
- retrieve data from multiple databases, 9.1.2
- without the FOR UPDATE clause, 9.10.1
- SQL
-
- gateway appearance to application programs, 9.1
- passing through gateway, 9.7
- stopping the gateway, 8.3.2
- stored procedures
-
- columns
-
- ROUTINE_NAME, 9.4.1
- ROUTINE_SCHEMA, 9.4.1
- considerations, 9.4.2
- database triggers, extended database services, 1.2.1.2
- DB2/400 with the gateway, 9.4
- execution of DB2/400 procedures from applications, 9.4.1
- gateway capabilities, intro, 1.2.3
- gateway support of Oracle stored procedures, 9.3
- linkage conventions, 9.4.2
- native DB2, 1.2.3.2
- Oracle stored procedures, introduction, 1.2.3.1
- PL/SQL, 9.3
- synonyms for, 9.3
- two-phase commit, 9.3
- using, 9.3
- streams
-
- replication, 8.9
- example code, 8.9
- replication from an Oracle Database to DB2/400 is supported, 8.9
- streams will not work if archivelog is not enabled, 8.9
- STRORALSN command, 5.4.5
- STRSBS command, 1.7
- Structured Query Language, See SQL, 1.2
- SUBSTR function, always post-processed by Oracle server, 1.8.2
- SUBSTR function, not same in Oracle server and other database servers, 1.8.2
- support, contacting Oracle Support Services, 10.2
- synonym feature, 7.3
- syntax, conventions used in this book, Preface
T
- TABLE_PRIVILEGES view, description, C.18
- TCP/IP
-
- AS/400 database, 5.1.4
- bequeath mechanism, 5.4
- concurrent connections, memory, 3.1.2
- configuring Oracle Net, 5.4
- connecting to the AS/400, 5.2
- connection flow, 5.4
- connection problems
-
- troubleshooting, 5.5
- inherit mechanism, 5.4
- listener
-
- gateway architecture, 1.7
- starting, 8.4
- local domain name, 5.4.3
- local host name, 5.4.3
- port numbers
-
- cloning a gateway instance, 6.1.2
- configuring for Oracle Net listener, 5.4.2
- name choices on install panel, 4.4.3.2
- protocol
-
- implicit protocol conversion, 1.2.1.3
- network transparency, 1.2.1.1
- socket interface, 4.4
- starting the listener, 8.4
- terminology, Oracle Net
-
- client, 5.1.3
- driver, 5.1.3
- host, 5.1.3
- network, 5.1.3
- protocol, 5.1.3
- TIME data type
-
- CHAR format, 9.8.5
- performing Date and Time operations, 9.8.5
- TIMESTAMP data type
-
- CHAR format, 9.8.5
- performing Date and Time operations, 9.8.5
- TNS
-
- connect descriptor, 7.1.2
- TNSNAMES.ORA file
-
- add a TCP/IP connect descriptor, 5.2.1
- connect descriptor, 7.1.1
- specify a system identifier (SID) name, 5.2.2
- TO_CHAR function, Julian dates support, 2.4.1.8
- TO_DATE function
-
- dates in the 21st century, 9.8.6
- Julian dates support, 2.4.1.8
- performing date and time operations, 9.8.5
- trace files
-
- agent trace files will appear if requested, 1.8.1
- for job members, file name structure, 5.1.5.1
- trace file member names, format, 5.1.5.1
- TRANSLATE translated SQL function, 9.9
- translated SQL functions, defined, 9.9
- transparency
-
- access method, 1.2.1.1
- data storage, 1.2.1.1
- location, 1.2.1.1
- network, 1.2.1.1
- operating system, 1.2.1.1
- TRC file
-
- member name format, 5.1.5.1
- members in TRC file, A.1.3
- trace files for job members, 5.1.5.1
- triggers
-
- Oracle Database server-7.7.1, 7.7.1
- synchronous copies of Oracle and non-Oracle data maintained automatically, 7.8.1
- twenty-first century dates, 9.8.6
- two-phase commit
-
- description, 7.6.2
- in multi-site transactions, 1.3
- prepare phase not supported by DB2/400, 7.6.2
- recorded in, 7.6.2
- transaction recovery, 7.6.2.1
- transaction treated as a single unit of work, 1.2.1.2
- updates to DB2/400 made within Oracle stored procedure, 9.3
U
- UNION capability, distributed capabilities, 1.2.1.2
- user class
-
- QSECOFR, 4.3.1
- USER, 4.4
- user ID
-
- cannot be longer than ten characters, 7.1.2
- CONNECT TO user ID provides implicit qualification for unqualified tables, 7.1.4
- gateway recovery caution, 6.1.8
- instance password for gateway copy, 6.1.2
- instance password, name choices on install panel, 4.4.3.2
- Oracle user ID passed over database link for gateway security, 8.8
- Oracle user ID used as implicit qualifier, 7.1.4
- OS/400 user ID identical to name of install library, 4.4
- OS/400 user ID known as gateway ID, 4.4
- recovery user ID, recovering failed transactions, 7.6.2.1
- remote user ID specified by CONNECT TO clause, creating database links, 7.1.1
- starting the Oracle gateway monitor, 8.2
- that is used to establish a session in remote AS/400 system, 7.1.2
- user ID, CONNECT TO, 7.1.4
- USER_CATALOG view, description, C.19
- USER_COL_COMMENTS view, description, C.20
- USER_CONS_COLUMNS view, description, C.21
- USER_CONSTRAINTS view, description, C.22
- USER_DB_LINKS data dictionary view, examining available database links, 7.1.6
- USER_INDEXES view, description, C.23
- USER_OBJECTS view, description, C.24
- USER_SYNONYMS view, description, C.25
- USER_TAB_COLUMNS view, description, C.26
- USER_TAB_COMMENTS view, description, C.27
- USER_TABLES view, description, C.28
- USER_USERS view, description, C.29
- USER_VIEWS view, description, C.30
- USING clause, specifies a TNSNAMES.ORA connect descriptor, 7.1.1
V
- VALUE translated SQL function, 9.9
- VARCHAR
-
- DB2/400 VARCHAR data type length, 9.8.4
- general restrictions, column returns its width doubled, 2.4.1.2
- table, data type mapping and restrictions, 9.8
- VARCHAR LONG, long data types, 2.4.3.4
- VARCHAR2 data types, DB2/400 GRAPHIC support, 9.8.1
- views, data dictionary
-
- ALL_CATALOG, description, C.1
- ALL_COL_COMMENTS, description, C.2
- ALL_CONS_COLUMNS, description, C.3
- ALL_CONSTRAINTS, description, C.4
- ALL_DB_LINKS, examining available database links, 7.1.6
- ALL_IND_COLUMNS, description, C.5
- ALL_INDEXES, description, C.6
- ALL_OBJECTS, description, C.7
- ALL_SYNONYMS, description, C.8
- ALL_TAB_COLUMNS, description, C.9
- ALL_TAB_COMMENTS, description, C.10
- ALL_TABLES, description, C.11, C.11
- ALL_USERS, description, C.12
- ALL_VIEWS, description, C.13
- COLUMN_PRIVILEGES, description, C.14
- DBA_DB_LINKS, examining available database links, 7.1.6
- DICTIONARY, description, C.15
- DUAL, description, C.16
- OTGREGISTER
-
- DB2/400 special registers, 9.12.2
- OTGREGISTER, description, C.17
- TABLE_PRIVILEGES, description, C.18
- USER_CATALOG, description, C.19
- USER_COL_COMMENTS, description, C.20
- USER_CONS_COLUMNS, description, C.21
- USER_CONSTRAINTS, description, C.22
- USER_DB_LINKS, examining available database links, 7.1.6
- USER_INDEXES, description, C.23
- USER_OBJECTS, description, C.24
- USER_SYNONYMS, description, C.25
- USER_TAB_COLUMNS, description, C.26
- USER_TAB_COMMENTS, description, C.27
- USER_TABLES, description, C.28
- USER_USERS, description, C.29
- USER_VIEWS, description, C.30
W
- WHERE clause
-
- copying data, refreshed, 7.9
- SELECT without the FOR UPDATE clause, 9.10.1
- wireless communication, 1.2.1.3
- writing to DB2/400 database, read and write access, 9.1.2
- WRKTRCLOG command
-
- agent trace files, A.2
- Displaying File Members, A.1.2.6
- make sure instance library is in library list before using this command, A.1.3
Z
- zoned decimal operations, 9.11.2