Oracle Transparent Gateway for DB2/400 Installation and User's Guide -- Index

accessing

AS/400 file members, 7-7

Advanced Security, 1-6

agent trace files, 1-12, A-3

ALL_CATALOG view, C-3

ALL_COL_COMMENTS view, C-3

ALL_CONSTRAINTS view, C-4

ALL_DB_LINKS data dictionary view, 7-4

ALL_IND_COLUMNS view, C-5

ALL_INDEXES view, C-5

ALL_OBJECTS view, C-7

ALL_SYNONYMS view, C-7

ALL_TAB_COLUMNS view, C-8

ALL_TAB_COMMENTS view, C-9

ALL_TABLES view, C-9

ALL_USERS view, C-10

ALL_VIEWS view, C-11

ALTER SESSION CLOSE DATABASE LINK statement, 7-3

ANO, 1-5

API, 5-2

APPC/LU6.2

protocol, 1-4

application development

database link, 9-2

application server support, 1-5

applications

SQL*Plus, 1-8

applications program interface See API

architecture

gateway, 1-10

array

definition, 9-3

processing, 6-18, 9-3

ARRAY BLOCK SIZE parameter, 6-18, 9-5

AS/400 database

accessing file members, 7-7

AUTOCREATE CONTROLLER parameter, 5-8

binary literal notation, restriction, 2-7

bind variables, 9-27

restriction, 2-7, 2-8

BLOCKSIZE data area, 6-18

CCSID, 6-19, B-3

and NLS, B-3

supported character sets, B-3

supported languages, B-5

supported territories, B-5

CFGTCP command, 5-17

changes to the system upon installation, 1-12

CHAR format, 9-21

CHARACTER SET parameter, B-6

character strings

converting datatypes, 9-20

processing, 9-19

CHECKSUM command, 1-6

CHGGTWDBG command

command description, 6-14

purpose, 6-2

CHGORANET command

assigning a port number, 5-10

changing parameters, A-2

purpose, 6-2

trace files, 5-5

CHGORAPJE command

command description, 6-10

prestarted jobs, 6-7

purpose, 6-2

CHGORATUN command, B-2

changing default BLOCKSIZE, 6-18

command description, 6-10

data conversion, 6-19

gateway configuration, B-2

language specification, B-2

number of DB2/400 cursors, 7-5

purpose, 6-2

CHGRECOPRF command, 6-7

caution to synchronize recovery password, 6-17, 8-7

command description, 6-16

CHGUSRPRF command, 6-7

clauses

CONNECT BY, 9-25

CONNECT TO, 8-6

FOR UPDATE, 9-25, 9-26

USING, 7-2

WHERE, 9-25

coded character set identifier, See CCSID

co-existence between gateways, 4-2

COLUMN_PRIVILEGES view, C-11

columns

DECIMAL, 9-22

INTEGER, 9-22

NUMERIC, 9-22

PACKED, 9-22

ROUTINE_NAME, 9-9

ROUTINE_SCHEMA, 9-9

SMALLINT, 9-22

command summary, gateway commands, 6-2

commands

CFGTCP, 5-17

CHGGTWDBG

command description, 6-14

purpose, 6-2

CHGORANET

assigning port number, 5-10

command description, 6-8

purpose, 6-2

trace files, 5-5

CHGORAPJE

command description, 6-10

purpose, 6-2

CHGORATUN

changing BLOCKSIZE, 6-18

command description, 6-10

data conversion, 6-19

gateway configuration, B-2

language specification, B-2

purpose, 6-2

CHGRECOPRF

caution to synchronize recovery password, 6-17, 8-7

CREATE COMMAND, 4-6

CREATE SNAPSHOT, 7-14

CREATE TABLE, 7-14

CRTLF, 7-7

CRTLINETH, 5-8

CRTLINSDLC, 5-8

CRTLINTRN, 5-8

CRTLINX25, 5-8

CRTORADDB

command description, 6-15

purpose, 6-2

CRTORAGTWI

purpose, 6-2

CRTUSRPRF, 1-12

DSPLIND, 5-8

DSPPGM, 4-12

ENDSBS, 8-5

EXECUTE, 1-7

INSERT, 7-14

JOIN, 9-3

ORAMON, 1-10, 8-2

PING, 5-12

SBMJOB, 4-14

SQL, 7-3

SQL*Plus

COPY, 7-12, 7-13, 7-15

DELETE, 9-27

DESCRIBE, restrictions, 2-2

INSERT, 7-13

STRORALSN, 5-12

STRSBS, 1-10

commit confirm protocol, 1-9

COMMIT_POINT_STRENGTH setting, 7-10

commitment control, 4-11, 9-10

concurrent connections

TCP/IP, memory, 3-2

CONNECT BY

clause, 9-25

CONNECT BY clause, not supported in SQL, 2-8

CONNECT TO

clause, 7-2, 7-4, 7-6, 8-6

statement, 7-4

user ID, 7-4

convert

SQL to make compatible with DB2/400 server, 1-13

COPY command, 7-12, 7-13, 7-15

copying data

from the DB2/400 server, 7-14

from the Oracle9 Database Server, 7-13

to DB2/400 server, 7-12

copying the gateway, CRTORAGTWI command, 6-4

COUNT function, 9-27

CREATE COLLECTION command, 4-6

CREATE DATABASE LINK command, 7-2

CREATE SNAPSHOT command, 7-14

CREATE TABLE command, 1-7, 7-14

CRTLF command, 7-7

CRTLINETH command, 5-8

CRTLINSDLC command, 5-8

CRTLINTRN command, 5-8

CRTLINX25 command, 5-8

CRTORADDB command

command description, 6-15

purpose, 6-2

CRTORAGTWI command, 6-4

command description, 6-4

purpose, 6-2

CRTUSRPRF command, 1-12

cursor stability, 4-11

cursors for DB2/400, 7-5

data control language, See DCL

data conversion, 6-19

data definition language, See DDL

data dictionary, 4-8, 4-11, 6-7

creating, 6-15

emulation in DB2/400 server, 9-28

tables

restriction with v4 gateways, 2-5

using, 9-28

views, 7-5, 9-28

ALL_CATALOG, C-3

ALL_COL_COMMENTS, C-3

ALL_CONSTRAINTS, C-4

ALL_DB_LINKS, 7-4

ALL_IND_COLUMNS, C-5

ALL_INDEXES, C-5

ALL_OBJECTS, C-7

ALL_SYNONYMS, C-7

ALL_TAB_COLUMNS, C-8

ALL_TAB_COMMENTS, C-9

ALL_TABLES, C-9

ALL_USERS, C-10

ALL_VIEWS, C-11

COLUMN_PRIVILEGES, C-11

DBA_DB_LINKS, 7-5

OTGREGISTER, 9-28, C-12

TABLE_PRIVILEGES, C-13

USER_CATALOG, C-13

USER_COL_COMMENTS, C-13

USER_CONS_COLUMNS, C-14

USER_CONSTRAINTS, C-14

USER_DB_LINKS, 7-4

USER_INDEXES, C-15

USER_OBJECTS, C-16

USER_SYNONYMS, C-17

USER_TAB_COLUMNS, C-18

USER_TAB_COMMENTS, C-19

USER_TABLES, C-19

USER_USERS, C-21

USER_VIEWS, C-21

DATABASE DOMAIN parameter, 6-11

database link, 7-2

accessing data, 7-4

behavior, 7-2

closing, 7-3

connecting to DB2/400 databases, 9-2

creating, 7-2

data dictionary views

ALL_DB_LINKS, 7-4

DBA_DB_LINKS, 7-5

USER_DB_LINKS, 7-4

dropping links, 7-4

examining, 7-4

function in the gateway, 1-11

limiting, 7-5

using Oracle Net, 7-3

database triggers, 1-5

datatypes

conversion

for Oracle tools, 9-15

from DB2/400 to Oracle, B-6

Oracle to DB2/400 datatypes, 9-15

converting character strings, 9-20

DATE, 9-20

DB2/400 GRAPHIC, 9-17

IBM DATE, 9-21

LONG, 9-20

known restriction, 2-9

LONG VARCHAR, 9-20

Oracle DATE, 9-21

restrictions, 9-15

TIME, 9-20, 9-21

CHAR format, 9-21

TIMESTAMP, 9-20

CHAR format, 9-21

VARCHAR, 9-20

zoned decimal, 9-28

date and time operations

Oracle and DB2/400, 9-20

date arithmetic

restriction, 2-5

DATE datatype, 9-20

dates

21st century, 9-22

TO_DATE function, 9-22

DB_DOMAIN parameter, Oracle9 Database Server, 2-7

DB2/400

Application Server, 1-10

cursors, 7-5

database

read, 9-2

write, 9-2

differences from Oracle server, 9-27

executing stored procedures, 9-8

GRAPHIC datatype support and NCHAR, 9-17

native SQL, 1-7

native stored procedures, 1-8, 9-7

DB2/400 server

compatibility

with SQL form, 1-13

triggers, 7-12

DB2/400 VALUE

function, 1-13

DBA_DB_LINKS data dictionary view, 7-5

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 9-11

DCL

issue native DCL from Oracle environment, 1-7

DD basic tables

restriction, 2-7

DDL

Oracle applications use native DDL, 1-7

debugging parameters

changing, 6-14

DECIMAL column, 9-22

DECnet protocol, 1-4

definitions, 5-3

DELETE

command, 9-27

DESCRIBE SQL*Plus command, 2-2

developing applications, 9-2

diagnosing errors, 10-4

dictionary mapping, 1-6

distributed database

Oracle Net, 5-2

distributed processing

Oracle Net, 5-2

distributed queries, 7-8

documentation

errors, 10-5

requirements, 3-3

domain name, 5-11

double-byte character support, 9-17

DROP DATABASE LINK statement, 7-4

DSPLIND command, 5-8

DSPPGM command, 4-12

EMPDB2 synonym, 7-5

ENDSBS command, 8-5

error

1017, invalid user ID or password, 6-17, 8-7

ORA-12154 connection error, 5-15

ORA-2068 connection error, 5-15

ORA-2070, 2-9

ORA-28500

file not journalled, 4-13

ORA-28500 connection problems, 5-15

ORA-28509 connection error, 5-15

ORA-28511 connection error, 5-15

ORA-3114 connection error, 5-15

SQL0105, "Mixed or Graphic String Constant Not Valid.", 9-17

errors

diagnosing via categories, 10-5

mapping DB2/400 messages to Oracle, 10-2

messages, 10-1

reporting

documentation, 10-5

external Oracle error messages, 10-6

incorrect output, 10-6

performance, 10-7

EXECUTE command, 1-7

fetch reblocking, 9-4

file

INIT.ORA, 2-7, 6-11

TNSNAMES.ORA, 5-14, 7-2

file members

accessing, 7-7

flat files

accessing, 7-8

FOR BIT DATA option, 2-7

FOR UPDATE clause, 9-25, 9-26

NOWAIT option, 9-26

FORCE_SBCS, string to force double-byte character support, 9-19

functions

converting Oracle9 Database Server NVL function to VALUE, 1-13

COUNT, 9-27

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 9-11, 9-13

NVL, 1-13

SQL

column, 9-23

compensated, 9-24

scalar, 9-23

translated, 9-24

TO_DATE, 9-22

VALUE, 9-24

G4DB2ENV, 7-5

gateway, 9-7

access, 7-6

advantages, 1-3

migration and coexistence, 1-9

multisite transactions, 1-9

security, 1-10

site autonomy, 1-9

two-phase commit, 1-9

architecture, 1-10

array processing, 9-3

changes made to the OS/400 system, 1-12

co-existence with previous gateways, 4-2

commands, 6-2

CHGGTWDBG, 6-14

CHGORANET, 6-8, B-2

gateway call stack

displaying, 8-6

gateway initialization parameters, 6-11

gateway job locks, 8-6

gateway monitor

see Oracle gateway monitor

GATEWAY NATIONAL LANGUAGE parameter, 6-11

GENERAL linkage convention, 9-10

GENERAL WITH NULLS linkage convention, 9-10

GLOBAL_NAMES

known restrictions, 2-7

GO CMDORAGTW, 6-3

GRAPHIC datatype, B-6

support, B-6

hanging condition, connection problems, 5-15

hardware requirements, 3-2

heterogeneous services, 1-3

initialization parameters

known restrictions for DB2/400, 2-7

host name, 5-11

HS= parameter, 5-13

HS_DB_DOMAIN

Heterogeneous Services initialization parameter, 2-7

HS_RPC_FETCH SIZE parameter, 9-4

HS_RPC_FETCH_REBLOCKING parameter, 9-4

IBM DATE datatype, 9-21

implicit protocol conversion, 1-5

incorrect output errors, 10-6

initialization parameters

changing, 6-10

GLOBAL_NAMES, 2-7

INIT.ORA file, 2-7, 6-11

INSERT

clause, 9-26

command, 7-14

command, restriction, 2-5

installation

before installing, 4-4

checking distribution kit, 3-3

completion, 4-10

mount product tape, 4-6

required parameters, 4-6

set required parameters, 4-6

start Oracle subsystem, 4-10

start process, 4-6

starting Oracle subsystem, 4-10

verify, 4-9

INTEGER column, 9-22

Integrated File System

system changes when installing the gateway, 1-12

internal process communication, 5-9

internet support, 1-5

isolation level, 4-11, 4-13, 9-13

job locks, 8-6

job logs, 4-12

JOBCTL special authority, 4-5

jobs

viewing, 7-7

JOIN capability, 1-4

JOIN command, 9-3

journalling

AS/400 files, 4-12

definition, 4-11

error messages, 9-13

new tables, 9-13

ORACLE2PC file, 4-13

requirements, 4-11

Julian dates, restriction, 2-6

known problems, 2-4

known restrictions

date arithmetic, 2-5

DB2/400

GLOBAL_NAMES initialization parameter, 2-7

DB2/400 components, 2-7

OCI, 2-7

snapshots, 2-5

SQL*Plus DESCRIBE command, 2-2

Languages, 1-8

libraries

new tables, 9-13

ORASRVLIB, 1-12

QUSRSYS, 1-12

library files, A-2

listener, 5-3

client connection, 5-4

prestarted jobs, 5-4

TNS, 5-3

literal values, restriction, 2-7

local domain name, 5-11

local host name, 5-11

LOG file members, A-2

logical file members, 7-7

LONG datatype, 9-20

restriction, 2-9

LONG VARCHAR datatype, 9-20

mapping error messages, 10-2

mass delete

from a segmented tablespace, 9-27

member names

format, 5-5

members

accessing AS/400 file members, 7-7

LOG file, A-2

ORA file, A-2

SQLNET, 5-5

TRC file, A-3

messages

and error code processing, 10-2

diagnosing, 10-4

error, 10-1

journalling, 9-13

ORA-00947, 10-4

ORA-2070, 2-9

Metalink Note 136294.1, connection problems, 5-15

missing functionality, 10-7

Mobile Agents, 1-6

monitoring the gateway, 8-1

overview, 8-2

starting Oracle gateway monitor, 8-2

multiple rows

retrieving, 6-18

multisite transactions, 1-9

National Language Support, See NLS

network parameters

changing, 6-8

NLS

CCSID, B-3

supported character sets, B-3

supported languages, B-5

supported territories, B-5

gateway commands

CHGORANET, B-2

CHGORATUN, B-2

gateway configuration, B-2

CHGORATUN language specification, B-2

message availability, B-6

Oracle server and client configuration, B-6

overview, B-2

notational conventions, xv

NOWAIT option, 9-26

null values

with stored procedures, 9-10

numeric column, 9-22

numeric datatype, 9-22

NVL function, 1-13

observability, 4-14

OCI

restriction, 2-7

OPEN_LINKS parameter, 7-5

operations

date and time, 9-20

ORA file members, A-2

ORA(LISTENER) file, 6-9, A-2

ORA(LISTENER_CHG) file, A-2

ORA(LISTENLOCK) file, A-2

ORA(SQLNET) file, 6-9, A-2

ORA-00947 error message, 10-4

ORA-12154 connection error, 5-15

ORA-2068 connection error, 5-15

ORA-2070 message, 2-9

ORA-28500 error, 5-15

file not journalled, 4-13

ORA-28509 connection error, 5-15

ORA-28511 connection error, 5-15

ORA-3114 connection error, 5-15

Oracle Call Interface See OCI

Oracle DATE datatype, 9-21

Oracle Developer

Forms

compatibility, 9-29

Oracle gateway monitor

display gateway call stack, 8-6

display open files, 8-6

ORAMON command, 8-2

overview, 8-2

starting, 8-2

starting and stopping gateway, 8-5

starting TCP/IP listener, 8-6

working with gateway job locks, 8-6

working with gateway jobs, 8-5

Oracle integrating server

and GLOBAL_NAMES initialization parameter, 2-7

function

regarding SQL, 1-13

Oracle Net, 1-8, 4-14, 5-1

API, 5-2

communications, 5-3

configuring APPC/LU6.2

define physical line, 5-8

configuring TCP/IP, 5-9

checklist, 5-10

define local host name, 5-11

modify port number, 5-10

start the listener, 5-12

verify host name, 5-12

connecting TCP/IP, 5-12

add connect descriptor, 5-13

checklist, 5-7, 5-12

specify SID names, 5-14

connections, 5-3

creating database links, 7-3

distributed database, 5-2

distributed processing, 5-2

file names, 5-5

listener, 5-3

LOG file members, A-2

ORA file members, A-2

overview, 5-2

terminology, 5-3

client, 5-3

driver, 5-3

host, 5-3

network, 5-3

protocol, 5-3

tracing job members, 5-5

TRC file members, A-3

Oracle Precompilers

restriction, 2-7

Oracle subsystem

error reporting, 10-6

Oracle Support Services

contacting, 10-4

ORACLE2PC file, 4-13, 7-10

ORACLE2PC table, 1-8

Oracle9 Database Server, 1-4, 6-11

and array size, 9-4, 9-5

and database links, 1-11

and error detection, 10-4

copying data from the DB2/400 server, 7-14

copying data to DB2/400 server, 7-12

database triggers, 1-5

date and time operations, 9-20

differences from DB2/400, 9-27

distributed capabilities, 1-4

distributed query optimization, 1-5

mapping DB2/400 error messages, 10-2

performing character string operations, 9-19

post-processing of SUBSTR SQL function, 2-8

SQL, 1-4

stored procedures, 1-5

triggers, 7-11, 7-12

two-phase commit protection, 1-5

ORADBMBOPT Data Area (or Environment variable), 9-19

ORAMON command, 1-10, 8-2

ORARAW

data area, 6-18

ORASRVLIB library

creation, 1-12

OTGREGISTER view, 9-28, C-12

outer joins, SQL functions, 1-4

overview of Oracle Net, 5-2

PACKED column, 9-22

panel

Change Oracle Gateway Debugging Option, 6-14

Change Oracle Gateway Initialization Parameters (page 1), 6-12

Change Oracle Gateway Initialization Parameters (page 2), 6-13

Change Oracle Network Parameters, 6-8

Change Recovery Profile Parameters, 6-16

CMDORAGTW Oracle Commands, 6-3

Create Oracle Prestart Parameters, 6-10

Create Oracle Transparent Gateway, 6-5, 6-6

parameters

ARRAY BLOCK SIZE, 6-18, 9-5

AUTOCREATE CONTROLLER, 5-8

data dictionary, 6-15

DATABASE DOMAIN, 6-11

DB_DOMAIN

Oracle9 server, 2-7

debugging, 6-14

HS_DB_DOMAIN, Heterogeneous Services initialization parameter, 2-7

HS_PRC_FETCH_REBLOCKING, 9-4

HS_RPC_FETCH SIZE, 9-4

initialization, 6-10

network, 6-8

OPEN_LINKS, 7-5

optional, 6-18

READONLY, 6-19

required, 4-6

RPC FETCH REBLOCKING, 6-11, 9-4

RPC FETCH SIZE, 6-11, 9-4

setting, 4-6, 6-18

SQLNET.ORA, 5-5

passthrough, 1-7, 9-11

examples, 9-12

function, 9-11

result sets, 9-11

example, 9-14

retrieving result sets, 9-14

performance issues, 10-7

PING command, 5-12

PL/SQL

routine, 1-7

standard Oracle, 1-8

port numbers

changing them, 5-10

post-installation

configure Oracle Net, 4-14

journal ORACLE2PC file, 4-13

raise priority level, 4-14

remove observability, 4-14

steps, 4-11

verify journalling, 4-12

post-processing, 1-13

precompiler limitations, 2-7

prestarted jobs

changing parameters, 6-10

priority level, 4-14

processing SQL, 9-25

processor requirement, 3-2

product set, 2-2

protocols

APPC/LU6.2, 1-4

commit confirm, 1-9

DECnet, 1-4

definition, 5-3

SPX/IPX, 1-4, 1-5

TCP/IP, 1-4, 1-5

QCCSID, 6-19

QCRTAUT parameter, 4-4

restriction, 2-5

QSECOFR user class, 4-4

QSYS2/SYSPARMS DB2/400 table, 9-9

QSYS2/SYSPROCS DB2/400 table, 9-9

queries

distributed, 7-8

example, 7-8

QUSRSYS library, 1-12

RAW

columns, restriction, 2-7

data

restrictions, 2-7

reading DB2/400 database, 9-3

read-only capabilities on the gateway, 6-19

READONLY parameter, 6-19

recovery

process, 7-11

user and password, 6-7

release information, 2-1

remote transaction program, 3-2

replication

heterogeneous environment, 7-11

requirements

documentation, 3-3

hardware, 3-2

software, 3-3

journalling, 4-11

result sets, 9-11

retrieving

multiple rows, 6-18, 9-3

ROUTINE_NAME column, 9-9

ROUTINE_SCHEMA column, 9-9

routines

PL/SQL, 1-7

ROWID

not supported, 2-8

RPC FETCH REBLOCKING parameter, 6-11, 9-4

RPC FETCH SIZE parameter, 6-11, 9-4

running gateway commands, 6-3

RUNORALSN program runs the TCP/IP listener, A-2

savepoints, restriction, 2-9

SBMJOB command, 4-14

QSECOFR ID, 4-14

SECADM special authority, 4-4

security

advanced, 1-6

ANO, 1-6

encryption, 1-6

on the gateway, 8-6

segmented tablespace

mass delete from, 9-27

SELECT FOR DELETE clause, 9-26

SELECT FOR INSERT clause, 9-26

SELECT FOR UPDATE clause, 9-26

SELECT statement, 1-13, 9-3, 9-4, 9-25

array size in fetch reblocking, 9-4

session connection, 7-2

SID names, 5-14

SMALLINT column, 9-22

snapshots

complete refresh, 7-14

restriction, 2-5

CREATE SNAPSHOT command, 7-14

fast refresh, 2-5

restriction, 2-9

feature capability, 7-11

software requirements, 3-3

special authority

*JOBCTL, 4-5

*SECADM, 4-4

special registers in DB2/400, 9-28

SPX/IPX protocol, 1-4, 1-5

SQL, 1-7

ANSI standard, 1-7

commands, 7-3

compatibility with gateway through Oracle integrating server, 1-13

constructs, Oracle-specific, 9-25

conversion for compatibility withDB2/400 server, 1-13

differences, 1-13

functions

column, 9-23

compatibility, 9-23

compensated, 9-24

scalar, 9-23

translated, 9-24

ISO standard, 1-7

known restrictions, 2-8

limitations, 2-8

passthrough, 9-11

statements, 9-2

passing through gateway, 9-11

SQL construct processing, 9-25

SQL*Plus, 1-8

commands

COPY, 7-12, 7-13

DELETE, 9-27

DESCRIBE, 2-2

INSERT, 7-13

SQL0105 error, "Mixed or Graphic String Constant Not Valid.", 9-17

SQLNET member, 5-5

SQLNET(ORA) file, 5-5

SQLNET.ORA parameter, 5-5

starting the gateway, 8-5

statements

ALTER SESSION CLOSE DATABASE LINK, 7-3

CONNECT TO, 7-4

CREATE DATABASE LINK, 7-2

DB2

CREATE TABLE, 1-7

DROP DATABASE LINK, 7-4

SELECT, 9-3, 9-4, 9-25

SQL, 9-2

passing through gateway, 9-11

stopping the gateway, 8-5

storage measurements, xv

stored procedures, 1-5, 1-7

columns

ROUTINE_NAME, 9-9

ROUTINE_SCHEMA, 9-9

considerations, 9-10

DB2/400 with the gateway, 9-7

execution of DB2/400 procedures from applications, 9-8

linkage conventions, 9-10

native DB2, 1-8

Oracle, 1-7, 9-5

PL/SQL, 9-7

synonyms for, 9-6

two-phase commit, 9-7

using, 9-5

STRORALSN command, 5-12

STRSBS command, 1-10

Structured Query Language See SQL

support

contacting, 10-4

synonym feature, 7-5

syntax

conventions used in this book, xv

TABLE_PRIVILEGES view, C-13

TCP/IP

AS/400 database, 5-3

bequeath mechanism, 5-9

concurrent connections, memory, 3-2

configuring Oracle Net, 5-9

connecting to the AS/400, 5-12

connection flow, 5-9

connection problems

troubleshooting, 5-15

inherit mechanism, 5-9

local domain name, 5-11

local host name, 5-11

port numbers, 4-8, 5-10, 6-7

protocol, 1-4, 1-5

socket interface, 4-5

starting the listener, 8-6

TCP/IP listener, 1-10

starting, 8-6

terminology, Oracle Net

client, 5-3

driver, 5-3

host, 5-3

network, 5-3

protocol, 5-3

TIME datatype, 9-20

CHAR format, 9-21

TIMESTAMP datatype, 9-20

CHAR format, 9-21

TNS

connect descriptor, 7-3

TNSNAMES.ORA file, 5-13, 5-14, 7-2

connect descriptor, 7-2

TNSPING command, 5-17

TO_CHAR function, 2-6

TO_DATE function, 2-6, 9-21, 9-22

trace files, 5-5

creating, 1-12

tracing, 5-6

transparency

access method, 1-4

data storage, 1-4

location, 1-4

network, 1-4

operating system, 1-4

TRC file members, 5-6, A-3

triggers, 7-11

DB2 server, 7-12

Oracle9 Database Server, 7-12

twenty-first century dates, 9-22

two-phase commit, 1-5, 1-9, 9-7

description, 7-9

recorded in, 7-10

transaction recovery, 7-11

unsupported statement, 7-10

UNION capability, 1-4

user class

QSECOFR, 4-4

USER, 4-5

user IDs

CONNECT TO, 7-4

USER_CATALOG view, C-13

USER_COL_COMMENTS view, C-13

USER_CONS_COLUMNS view, C-14

USER_CONSTRAINTS view, C-14

USER_DB_LINKS view, 7-4

USER_INDEXES view, C-15

USER_OBJECTS view, C-16

USER_SYNONYMS view, C-17

USER_TAB_COLUMNS view, C-18

USER_TAB_COMMENTS view, C-19

USER_TABLES view, C-19

USER_USERS view, C-21

USER_VIEWS view, C-21

USING clause, 7-2

VALUE function, 9-24

VARCHAR datatype, 9-20

views

data dictionary

ALL_CATALOG, C-3

ALL_COL_COMMENTS, C-3

ALL_CONSTRAINTS, C-4

ALL_DB_LINKS, 7-4

ALL_IND_COLUMNS, C-5

ALL_INDEXES, C-5

ALL_OBJECTS, C-7

ALL_SYNONYMS, C-7

ALL_TAB_COLUMNS, C-8

ALL_TAB_COMMENTS, C-9

ALL_TABLES, C-9

ALL_USERS, C-10

ALL_VIEWS, C-11

COLUMN_PRIVILEGES, C-11

DBA_DB_LINKS, 7-5

OTGREGISTER, 9-28, C-12

TABLE_PRIVILEGES, C-13

USER_CATALOG, C-13

USER_COL_COMMENTS, C-13

USER_CONS_COLUMNS, C-14

USER_CONSTRAINTS, C-14

USER_DB_LINKS, 7-4

USER_INDEXES, C-15

USER_OBJECTS, C-16

USER_SYNONYMS, C-17

USER_TAB_COLUMNS, C-18

USER_TAB_COMMENTS, C-19

USER_TABLES, C-19

USER_USERS, C-21

USER_VIEWS, C-21

WHERE clause, 7-15, 9-25

wireless communication, 1-6

writing to DB2/400 database, 9-3

WRKTRCLOG command, A-3

zoned decimal operations, 9-28