Skip Headers

Oracle Transparent Gateway for DB2/400 Installation and User's Guide
Release 9.2.0.1.0 for IBM AS/400

Part Number A97615-01
Go To Table Of Contents
Contents

Go to previous page

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-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

B

binary literal notation, restriction, 2-7
bind variables, 9-27
restriction, 2-7, 2-8
BLOCKSIZE data area, 6-18

C

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

D

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

E

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

F

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

G

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
changing parameters, A-2
CHGORAPJE, 6-10
CHGORATUN, 6-10, 6-18, B-2
CHGRECOPRF, 6-7
CHGUSRPRF, 6-7
command summary, 6-2
CRTORAGTWI, 6-4
menu to access, 6-4
running, 6-3
components
DB2 server, 1-10
Oracle9 Database Server, 1-10
transparent gateway, 1-10
development applications, 9-2
how it works, 1-11
jobs, 7-7
known restrictions, 2-5
library files, A-2
monitoring, 8-1
multiple copies, 6-4
NLS configuration, B-2
post-installation, 4-11
raising priority level, 4-14
removing observability, 4-14
retrieving data, 6-18
security, 8-6
setting optional parameters, 6-18
starting, 8-5
stopping, 8-5
transparency levels, 1-4
two-phase commit, 7-9
using Oracle stored procedures, 9-5
verifying the version, 4-12
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

H

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

I

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

J

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

K

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

L

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

M

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

N

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

O

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

P

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

Q

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

R

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

S

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

T

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

U

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

V

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

W

WHERE clause, 7-15, 9-25
wireless communication, 1-6
writing to DB2/400 database, 9-3
WRKTRCLOG command, A-3

Z

zoned decimal operations, 9-28

Go to previous page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents