Skip Headers

Oracle® Transparent Gateway for IBM DRDA Installation and User's Guide
Release 9.2.0.1.0 for MS Windows
Part Number A96195-01
Go To Table Of Contents
Contents

Previous

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

ABS function, F
ABS SQL function, 12.6
accessing
DRDA servers, 9.8
gateway, 9.7
ACOS function, F
action items, 4.6.4
ADD_MONTHS function, F
Advanced Security
CHECKSUM command, 10.5
encryption, 10.5
international version types supported, 10.6
resetting configuration parameters on gateway, 10.7.2
setting test parameters for gateway, 10.6.1
setting test parameters for Oracle integrating server, 10.6.2
setting up for test, 10.6
testing gateway and Oracle integrating server, 10.7.1
export encryption algorithms, 10.5
function on the gateway, 1.3.3
test error, 10.7.1
12660, 10.6
AGW ADD USERID command, 13.5.1.2
AGW DELETE USERID command, 13.5.1.2
AIX
AIX_RS6K, default value, C.4.12
Communications Server, C.4.5
alias
DB2, C.4.8
objects, DB2, known restrictions, 2.6
ALL_CATALOG view, A.2.1
ALL_COL_COMMENTS view, A.2.2
ALL_CON_COLUMNS view, A.2.3
ALL_CONSTRAINTS view, A.2.4
ALL_DB_LINKS data dictionary view, 11.1.4
ALL_INDEXES view, A.2.5
ALL_OBJECTS view, A.2.7
ALL_SYNONYMS view, A.2.8
ALL_TAB_COMMENTS view, A.2.11
ALL_TABLES view, A.2.9
ALL_USERS view, A.2.12
ALL_VIEWS view, A.2.13
allocation mode, SNA session, C.4.2
ALTER session statement, 11.1.2
ANSI-standard SQL
gateway capabilities, 1.3.5
heterogeneous database integration, 1.9.10
API (application program interface)
Oracle Net, 10.3
APPC
concurrent connections, 3.1.2
connectivities, C.4.5
database link behavior, 12.4
DB2/VMT, 13.5.1.2
mode definition, 6.7
password length, 15.3
profile, 9.8
userid length, 15.3
APPC VTAM Support (AVS), 2.6.1
also see AVS, 13.5.1.2
APPEND command
supported by COPY, 11.8
application
application program interface defined, see API, 10.3
authenticating logons, 13.2
development on the gateway, 1.9.16
portability, 1.9.13
server support, 1.3.3
architecture of the gateway, 1.5
array size, 1.9.3
how determined, 12.1.1
AS/400
command
DSPRDBDIRE, 5.3.4
communications
configuring, 5.3.1
defining user ID, 5.3.2
ASCII
code page, D.3
function, F
sort order, 12.6
tables, known restrictions, 2.4
translated from EBCDIC, 12.7.1
US7ASCII, D.2, D.3.2.1
ASCIILSQL function, 12.6
ASIN function, F
asynchronous replication, 11.7.3
ATAN function, F
ATAN2 function, F
authority
CONNECT, 13.5.1.2
execute, 13.5.1.2
autonomy, site, 1.3.14
AVS
also see APPC VTAM Support, 2.6.1
configuring, 5.5.1
DB2/VMT, 13.5.1.2
mapping user IDs, 2.6.1
mapping user IDs (DB2/VM), 2.6.1
userid mapping, 13.5.1.2
with DB2/VMT, 13.5.1.2

B

binary data, non-character, 12.7.1
Bind Package Stored Procedure, 5.2.2, 5.3.2, 5.4.2, 5.5.2
BIND privilege, 5.2.2, 5.4.2, 5.5.2, E
bind variables, 12.8
restrictions, 2.6.2
BINDADD authority, 9.3.5
BINDADD privilege, 5.2.2, 5.4.2, 5.5.2, E
BINDAGENT privilege, 5.2.2, 5.4.2, 5.5.2, E
binding the DRDA package, 5.2.2, 5.3.2, 5.4.2, 5.5.2, 9.3.4
backward compatibility, 14.4
on DB2/UDB, 9.3.5
upgrading from Version 3, 9.3.5
bug
debugging, 11.10, 15.1.3, 15.4
number 205538, 2.6.2
bugs fixed in this release, 2.4

C

call
a CICS or IMS transaction, 12.3.2
DB2 stored procedure, 12.3, 12.3.1
DRDA_DISABLE_CALL, 9.4.1.1
empproc stored procedure, 12.3
Oracle Call Interfaces, 15.1
PL/SQL, 12.3.1
stored procedure, 12.2
stored procedures, 12.2
to stored procedure, 2.6.1
capabilities
DRDA server, 12.6
capability classification, C.4.28
catalog views, 12.9.1
caution, installation of gateway in ORACLE_HOME, 4.5
CCSID, C.4.14
codepage mapping facility, D.4
description, D.1
external mapping to Oracle character sets supported, 2.3
CCSID 65535 as the default for all tables created, C.4.7
CD-ROM drive requirements, 3.1.4
CEIL function, F
CEIL SQL function, 12.6
changed parameters, 14.3.2
changes in this release, 2.4
bugs fixed, 2.4
gateway parameters, 2.4
IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 2.4
IBM DB2/UDB supported, 2.4
Oracle server dependencies, 2.4
read-only support, 2.4
TNSNAMES.ORA, 2.4
CHAR_TO_ROWID function, F
CHARACTER SET parameter, D.2
description, D.1
character sets
and codepage map facility, D.4
ASCII, 2.4
CCSID, D.1
codepage, DRDA_DEFAULT_CCSID, C.4.7
EBCDIC, 2.4
limitation, 2.6.1
supported, 2.3
character strings, 12.7.1, 12.7.2
checklist
configuring the DRDA server, 5.1
gateway configuration, 9.1
gateway installation, 4.3
installation overview, 4.3
Oracle Net, 10.1
CHECKSUM command, 1.3.3, 10.5
also see Advanced Security
CHR function, F
CHR SQL function, 12.6
CICS transaction, 12.3.2
clauses
CONNECT TO, 11.1.1
GROUP BY, 12.6.1
HAVING, 12.6.1
ORDER BY, 12.6.1
SQL
DELETE, 12.7.7
INSERT, 12.7.7
SELECT WHERE, 12.7.7
UPDATE, 12.7.7
TO_DATE, 12.7.7
USING, 11.1.1
VALUES, 12.7.7
WHERE, 2.6.2, 12.6.1
WHERE CURRENT OF CURSOR, 2.6.2
code tracing, C.4.35
codepage
overriding, C.4.14
codepage map facility
configuring support for character sets, 2.6.1
for data translation, D.4
supported by gateway, 2.3
coercion of data, defined, 12.6
collection privilege - CREATE IN, 5.2.2, 5.4.2, 5.5.2, E
column
date, 12.7.7
Oracle ROWID, 2.6.2
supported in a result set, 1.9.8
commands
AGW ADD USERID, 13.5.1.2
AGW DELETE USERID, 13.5.1.2
CHECKSUM, 1.3.3, 10.5
COPY, 2.6
COPY (SQL*Plus command), 11.8
CREATE DATABASE LINK, 5.5.2
DESCRIBE, 2.6
EXECUTE, 1.3.9.1
EXPLAIN PLAN, 15.4
INSERT, 2.6
commit confirm protocol, 1.3.13
Communication Database (CDB) tables, DDF, 5.2.5
communications requirements, 3.2.3
compatible SQL set operators and clauses, 12.6.1
concatenation restrictions, 2.6.1
concurrent connections
APPC, 3.1.2
TCP/IP, 3.1.2
configuring
additional DRDA servers, 9.8
AS/400 communications, 5.3.1
AVS, 5.5.1
binding DRDA package, 9.4
checklist for gateway, 9.1
checklist for installation overview, 4.3
checklists, 4.3, 4.3, 5.1, 9.1, 10.1
DB2/400, 5.3, 5.3.1, 5.4
DB2/OS390, 5.2
DB2/UDB, 5.4.1
list of parameters needed to configure the gateway, E
Oracle integrating server, 9.6
Oracle Net, 10.4, 10.4
OS/390 (MVS) VTAM, 5.2.1
other Oracle servers, 9.7
SNA server
creating profiles, 6.3, 7.3
TCP/IP
for AS/400, 5.3.1
for DB2/UDB, 5.4.1
for MS Windows, 8.2
for OS/390, 5.2.1
for VM, 5.5.1
VM VATM, 5.5.1
workstation for gateway, 9.3
CONNECT authority, 9.3.5, 13.5.1.2
CONNECT BY not supported
known restrictions, 2.6.2
CONNECT TO clause, 11.1.1
connection
definition, 6.7
testing, 6.8, 7.8
conversion
errors, C.4.7
convert
character strings, 12.7.1, 12.7.2
datatypes, 12.7
DATE, 12.7.4.2
floating point to integer, 12.7.8
inbound userid, 13.5.1.2
into most suitable datatype, 12.7.10
to the numeric datatype, 12.7.8
CONVERT function, F
CONVERT SQL function, 12.6
converter, protocol, 1.3.3
COPY
SQL*Plus COPY command
Oracle server to DRDA server, 11.8
substituted for INSERT, 2.6
COPY privilege, 5.2.2, 5.4.2, 5.5.2, E
copying data
from the DRDA server, 11.9
from the Oracle server, 11.8
COS function, 12.5.3, F
COS SQL function, 12.6
COSH function, F
COSH SQL function, 12.6
COUNT function, 12.7.9, 12.7.9
CPI-C routine, 15.1.4
CPI-C Symbolic Destination Names, 6.7
CREATE command
supported by COPY, 11.8
CREATE DATABASE LINK command, 5.5.2
CREATE DATABASE LINK statement, 11.1.1
CREATE IN privilege, 5.2.2, 5.4.2, 5.5.2, E
CREATE PUBLIC DATABASE LINK privilege, 9.3.4, 9.6.1
CREATE TABLE statement, 1.3.8
CREATETAB authority, 9.3.5
creating a database link, 11.1.1
cursor
defining the number of, 12.10
number of, C.4.20
stability, DRDA_ISOLATION_LEVEL, C.4.11

D

data coercion, defined, 12.6
data control language (DCL), 1.3.7
DATA datatype, 12.7.4.1
data definition language (DDL), 1.3.6
data dictionary
improved in this release, 2.3
support, 9.4.2
using, 12.9.1
views, 12.9, 12.9.1
ALL_DB_LINKS, 11.1.4
considerations for migration from previous releases, 14.4
for DB2/VM and DB2/UDB not supported, A.1
list and descriptions, A.2
USER_DB_LINKS, 11.1.4
views supported for DB2/OS390 and DB2/400 servers, A.1
database
catalogs, 12.9
native tool, 9.4.2
database link
behavior, 12.4
binding DRDA gateway package, 9.3.4
creating, 11.1.1
defining and controlling, 13.3
dropping links, 11.1.3
examining, 11.1.4
guidelines, 11.1.2
limits, 11.1.5
processing, 11.1
public, 9.6.1
suffix, 12.1
to identify the gateway, 1.7
database triggers, 1.3.2
datatype
character string, 12.7.1
character string operations, 12.7.1
column (ALL_TAB_COLUMNS), A.2.10
column (USER_TAB_COLUMNS), A.2.26
conversion, 12.7
conversion between Oracle and DRDA, 1.7
conversion, control over, 12.7.8
converting character strings, 12.7.1, 12.7.2
data and time, 12.7.4
date, 2.6.1
differences between Oracle server and DRDA databases, 12
DRDA server datatypes list, 12.7
known restrictions, 2.6.1
mapping, 12.7
numeric, 12.7.8, 12.7.8, 12.7.10
operations, numeric, 12.7.8
Oracle datatypes RAW and LONG RAW, 12.7.1
restrictions, 12.7
size and value limitations, 12.7
supported by IBM DRDA, 12.7.4
datatypes
DATE, 12.7.4, 12.7.4.1, 12.7.4.2
GRAPHIC, 12.7.3
LONG, 12.7.2
known restrictions, 2.6.1
LONG RAW, 12.7.1
Oracle and IBM DATE, 12.7.4.2
Oracle DATE, 12.7.4.1
RAW, 12.7.1, C.4.7
TIME, 12.7.4, 12.7.4.1
TIMESTAMP, 12.7.4, 12.7.4.1
VARCHAR, 12.7.2
VARGRAPHIC, 12.7.3
date
2 or 4 digits, 12.7.5
arithmetic, known restrictions, 2.6.1
columns, 12.7.7
datatypes and DRDA server restriction, 2.6.1
datatypes supported by IBM DRDA, 12.7.4
DELETE
statement, 12.7.5, 12.7.5
HS_NLS_DATE_FORMAT, 12.7.6
INSERT
c, 12.7.7
statement, 12.7.5, 12.7.5
NLS_DATE_FORMAT parameter, 12.7.5, 12.7.5
operations, 12.7.4
SELECT statement, 12.7.5, 12.7.5
TO_DATE function, 12.7.5, 12.7.7, 12.7.7, 12.7.7
UPDATE
statement, 12.7.5, 12.7.5
DATE datatype, 12.7.4.2
DB_DOMAIN parameter, 2.6.1
DB2
02pcg.sql granting authority, 9.4.2.5
alias objects
known restrictions, 2.6
aliases, C.4.8
CICS, 12.3.2
data access, 1.3.9.1
Distributed Data Facility (DDF), 5.2.5
DRDA_DESCRIBE_TABLE compatibility, C.4.8
IBM DB2 Version 5.1 ASCII Tables, 2.4
IMS, 12.3.2
native SQL, 1.3.8
native stored procedures, 1.3.9.2
procedural feature considerations, 12.3.2
SPUFI utility, 5.2.5
SQL statements, 12.8.2
statements
CREATE TABLE, 1.3.8
stored procedures
considerations for use, 12.3.2
with OS/390, 5.2
DB2/400
catalog view, 12.9.1
configuring, 5.3, 5.3.1, 5.4
data dictionary views supported by gateway, A.1
defining user ID, 5.3.2
DRDA_DEFAULT_CCSID, C.4.7
DRDA_DISABLE_CALL, C.4.9
DRDA_ISOLATION_LEVEL, C.4.11
DRDA_OPTIMIZE_QUERY, C.4.13
userid mapping, 13.5.1.3, 13.5.1.4
DB2INS sample DB2 stored procedure, G.1
DB2/OS390
catalog view, 12.9.1
configuring, 5.2
data dictionary views supported by gateway, A.1
DRDA_DISABLE_CALL, C.4.9
DRDA_ISOLATION_LEVEL, C.4.11
DRDA_OPTIMIZE_QUERY, C.4.13
userid mapping, 13.5.1.1
with SPUFI, 9.4.2
DB2/OS390 V6 and V7
stored procedures supported, 2.3
DB2/UDB
catalog view, 12.9.1
configuring, 5.4, 5.4.1
data dictionary views not supported, A.1
DRDA_ISOLATION_LEVEL, C.4.11
DRDA_OPTIMIZE_QUERY, C.4.13
grant authority, 9.4.2.5
incompatibilities with gateway, 2.5
known restrictions, 2.6.1
ORACLE2PC table, binding packages, 9.4.1.2
supported, 2.4
DB2/VM
catalog view, 12.9.1
configuring, 5.5
data dictionary views not supported, A.1
database and SQL functions, 12.5.8
DRDA_ISOLATION_LEVEL, C.4.11
DRDA_OPTIMIZE_QUERY, C.4.13
DRDA_PACKAGE_OWNER, C.4.19
instance, DRDA location name, 5.5.4
server machine, 13.5.1.2
userid mapping, 13.5.1.2
DBCS (double-byte character set), 2.6.1
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 12.8, 12.8, 12.8.2
DD basic tables, known restrictions, 2.6.1
DDF
DB2 (Distributed Data Facility), 5.2.5
subsystem, 5.2.1
DDL
statement, 12.8, 12.8.2
debugging
error codes, 15.1.3
SQL tracing, 15.4
your application, 11.10
DECODE function, F
DECODE SQL function, 12.6
de-installing the gateway, 4.6.7
DELETE
known restrictions, 2.6.2
operation, 12.1
SQL clause, 12.7.7
statement, 12.8
with read-only gateway, 11.6
Dependent LU, 6.4, 7.4
DESCRIBE
character string operations, 12.7.1
command, known restrictions, 2.6
diagnostic parameter, C.4.33
dictionary
also see data dictionary
mapping, 1.3.4
tables, 12.9
DICTIONARY view, A.2.15
disk space requirements, 3.1.5
distributed
applications
support for, 1.9.15
database, 10.3.2
distributed data facility (DDF), 5.2.5
distributed query optimizer (DQO)
better performance of distibuted queries, 11.5
DRDA-specific parameters, C.4.13
operations, DB2, 5.2.5
processing, 10.3.1
queries
example of, 11.5.1
two-phase commit, 11.5.2
transaction, C.4.24
double-byte character set (DBCS), 2.6.1
DQO
DRDA-specific parameters, C.4.13
DQO, also see distributed query optimizer, 11.5
drc error code, 15.1.3
DRDA
catalog, 12.9.2
database requirements, 3.2.2
defining number of cursors, 12.10
location name, 5.5.4
for DB2/UDB instance, 5.4.4
for DB2/VM instance, 5.5.4
DRDA Application Server Function, 1.9.12
DRDA server
accessing, 9.8
architecture, 1.5
capabilities, 12.6
character sets
known restrictions, 2.6.1
configuring
DB2/400, 5.3
DB2/OS390, 5.2
DB2/UDB, 5.4
DB2/VM, 5.5
considerations for binding packages, 14.4
database link behavior, 12.4
functions, 12.6
languages and character sets in configuration, D.4
stored procedures
native to DRDA server, 12.3
DRDA session security options, 13.5.1.1
DRDA_CAPABILITY parameter, 12.6, C.4.1
DRDA_CODEPAGE_MAP parameter, D.4
DRDA_COMM_BUFLEN parameter, C.4.4
DRDA_CONNECT_PARM
configuring IBM Communication Server, 7.7
configuring Microsoft SNA server or host server, 6.7
DRDA_CONNECT_PARM parameter
communication errors, 15.1.4
configuring the gateway for TCP/IP, 8.2
DRDA_DESCRIBE_TABLE parameter, 2.6
DRDA_DESCRIBE_TABLE=FALSE initialization parameter, 2.6
DRDA_DISABLE_CALL parameter, 9.4.1.1
DRDA_OPTIMIZE_QUERY parameter, 11.5
DRDA_PACKAGE_COLLID parameter, 15.1.5
DRDA_PACKAGE_NAME parameter, 9.4.1.1, 15.1.5
DRDA_PACKAGE_SECTIONS parameter, 12.10
DRDA_READ_ONLY parameter, 11.6
DRDA_RECOVER_USERID, 5.2.3, 5.3.3, 5.4.3, 5.5.3
DRDA_RECOVERY_PASSWORD parameter, 5.2.3, 5.3.3, 5.4.3
DRDA_RECOVERY_USERID parameter, 5.2.3, 5.3.3, 5.4.3, 5.5.3
DRDA_SECURITY_TYPE parameter, C.4.27
DROP DATABASE LINK statement, 11.1.3
dropold.sql script, 9.4.2.2
DSPRDBDIRE command, 5.3.4
DUMP function, F
DUMP SQL function, 12.6
dynamic dictionary mapping, 1.3.4

E

EBCDIC
character set support, D.3.2.1
code page, D.3
DRDA server CCSID, D.6
sort order, 12.6
tables, known restrictions, 2.4
translated to ASCII, 12.7.1
EMP, 11.4
table, 11.8
empproc
stored procedure, 12.3
encryption types for Advanced Security, 10.6
enhancements in this release, 2.3
environment
distributed, 12.2
heterogeneous, 11.7
environmental variable
NLS_LANG, D.1
ORA_NLS33, D.1
errd
error array returned from DRDA server database, 15.1.5
example of translated, mapped error, 15.2
example with obsolete parameter, C.4.14
example, retrieving data, 11.2.3
errmc
(error tokens), 15.1.5
communication errors, 15.1.4
errmc field lists any error tokens, 15.1.3
example of translated, mapped error, 15.2
example with obsolete parameter, C.4.14
example, retrieving data, 11.2.3
error
12660 (test error for Advanced Security), 10.6
basic description, 15.1
change
ORA-09100 to ORA-28500, 15.1.3
ORA-09101 to ORA-28501, 15.1.3
codes
drc, 15.1.3
grc, 15.1.3
communication, 15.1.4, 15.1.4
condition, 15.1
conversion, C.4.7
date, D.3.2.2
detected
by gateway, 15.1.2
by integrating Oracle instance, 15.1.1
by server database, 15.1.5
in DRDA software, 15.1.3
drc= field
-300xx, 15.3
-7xx, 15.3
HGO-00706, 15.1.2
host database, 15.3
interpreting error messages, 15.1
mapped sqlstate, 15.2
messages, 12.7.2
messages & codes, 15
number, 15.1
obsolete parameters, 14.3.4
ORA-00001, index constraint violated, 15.2
ORA-00942
object does not exist, 15.2
object name too long, 15.2
ORA-01017, logon denied, 15.2
ORA-01031, insufficient privileges, 15.2
ORA-01460, invalid CCSID, 15.2
ORA-01476, divide by zero, 15.2
ORA-02019, undefined database link name is specified, 15.1.1
ORA-1460, C.4.14
ORA-28500
was ORA-09100, 15.1.3
detected by server database, 15.1.5
example, collection ID or package name not recognized, 15.1.5
ORA-28501
was ORA-09101, 15.1.4
communication error, 15.1.4
Side Information Profile not defined, 15.1.4
ORA-9100 to ORA-9199, 15.1.1
Oracle error code for maped errors, 15.2
server database, 15.1.5
specific error codes, 15.3
tokens, 15.1.3, 15.1.5
translation, 12.7.1
while binding the gateway package, 9.3.4
with Native Semantics, 12.6
errp
example, retrieving data, 11.2.3, 15.1.3, 15.1.5, 15.2, C.4.14
EXCEPT set operator, 12.6.1
execute authority
DB2/400, 13.5.1.3
DB2/UDB, 13.5.1.4
DB2/VM, 13.5.1.2
on the gateway DRDA package, 13.5.1.2
EXECUTE command, 1.3.9.1
EXECUTE privilege, 5.2.2, 5.4.2, 5.5.2, E
exits, gateway local date, 12.7.6
EXP function, F
EXP SQL function, 12.6
EXPLAIN PLAN command, 15.4
EXPLAIN_PLAN table, 1.9.9, 1.9.9
export encryption algorithms, 10.5

F

FDS_CLASS_VERSION parameter, C.4.29
features of the gateway
application development and end-user tools, 1.9.16
application portability, 1.9.13
columns supported in a result set, 1.9.8
distributed applications supported, 1.9.15
EXPLAIN_PLAN improvement, 1.9.9
fetch reblocking, 1.9.3
heterogeneous database integration, 1.9.10
heterogeneous services architecture, 1.9.1
large base of data access, 1.9.12
main topic, 1.9
minimum impact on existing systems, 1.9.11
Native Semantics, 1.9.7
Oracle snapshot, 11.7.2
Oracle9i passthrough supported, 1.9.4
performance enhancements, 1.9.2
remote data access, 1.9.14
retrieving result sets through passthrough, 1.9.5
support for TCP/IP, 1.9.6
fetch array size, with HS_FDS_FETCH_ROWS, C.4.27
fetch reblocking, 1.9.3, 12.1.1, 12.1.1
fetched date, C.4.32
fields
errmc, lists any error tokens, 15.1.3
errp, indicates program that detected error, 15.1.3
files
initsid.ora
invalid ORA_MAX_DATE specified, 15.3
parameter not recognized, 15.1.5
installation log file, 4.6.5
listener.ora, 9.8, 10.4.2
member name, 11.3
sample, B
listener.ora, B.3
tnsnames.ora, 9.6.1, 9.8
modifying, 10.4.2
VSAM, 12.3.2
FLOOR function, F
FLOOR SQL function, 12.6
FOR BIT DATA, 12.7.1, C.4.7
option, 12.7.1
free session, C.4.2
functions
ABS, F
ACOS, F
ADD_MONTHS, F
ASCII, F
ASIN, F
ATAN, F
ATAN2, F
CEIL, F
CHAR_TO_ROWID, F
CHR, F
CONVERT, F
COS, 12.5.3, F
COSH, F
COUNT, 12.7.9
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 12.8, 12.8, 12.8.2
DECODE, F
DRDA server, 12.6
DUMP, F
EXP, F
FLOOR, F
GREATEST, F
GTW_SQL.GTWPASS, 12.8.2
HEXTORAW, F
INITCAP, F
INSTR, F
INSTRB, F
LAST_DAY, F
LEAST, F
LENGTH, F
LENGTHB, F
LN, F
LOG, F
LOWER, F
LPAD, F
LTRIM, F
MOD, F
MONTHS_BETWEEN, F
NEW_TIME, F
NEXT_DAY, F
NLS_DATE_FORMAT, 12.7.5
NLS_INITCAP, F
NLS_LOWER, F
NLS_UPPER, F
NLSSORT, F
POWER, F
RAWTOHEX, F
REPLACE, F
ROUND, F
ROWID, 2.6.2
ROWIDTOCHAR, F
RPAD, F
RTRIM, F
SIGN, F
SIN, F
SINH, F
SOUNDEX, F
SQL
SUBSTR, 12.6
TANH, F
SQRT, F
STDDEV, F
SUBSTR, F
known restrictions, 2.6.1
SUBSTRB, F
SYSDATE, F
TAN, F
TO_CHAR, F
TO_DATE, 12.7.4.2, 12.7.5, 12.7.6, 12.7.7, 12.7.7, 12.7.7, F
TO_LABEL, F
TO_MULTI_BYTE, F
TO_NUMBER, F
TO_SINGLE_BYTE, F
TRANSLATE, F
TRUNC, F
UID, F
UPPER, F
USER, F
USERENV, F
VARIANCE, F
VSIZE, F

G

g4ddtab.sql script, 9.4.2.3
g4ddview.sql script, 9.4.2.3
g4drutl, C.4.9, C.4.17, C.4.20
gateway
access, 9.7
advantages, 1.2.1
migration and coexistence, 1.3.15
security, 1.3.16
server technology and tools, 1.3.11
site autonomy, 1.3.14
two-phase commitand multisite transactions, 1.3.13
application tools, 1.9.16
architecture, 1.5, 1.5
benefits of integration with 9i server, 1.3.3
capabilities, C.4.28
definition of terms, 1.4
de-installing, 4.6.7, 4.6.7
features, 1.9, 1.9
gateway and Oracle integrating server are not on the same host, 1.5
installing, 4.6
interface, 1.7
local date exit, 12.7.6
logging, LOG_DESTINATION, C.4.31
migration problems, 14.2
parameter, 5.5.4
performance, 12.6
performance enhancements, 1.9.2
service name entries in the tnsnames.ora, 14.5
SQL differences, 1.7.1
stored procedures (Oracle and non-Oracle), 1.3.9
supported languages, D.4
tracing, 11.10
tracing, LOG_DESTINATION, C.4.31
Gateway Initialization File
defining userids and passwords, 13.6
encrypting passwords, 13.7
parameter syntax and usage, C.3
parameter, reported errors, 9.3.4
parameters, 2.4
new since V4 gateway, 14.3.1.2
sample, B.1
Gateway Initialization Parameter
DRDA_READ_ONLY, 11.6
Gateway System Identifier (SID), defined, 9.2
GCS virtual machine, 13.5.1.2
GLOBAL_NAMES
known restrictions, 2.6.1
GRANT, 13.5.1.2
GRANT statement, 9.6.2
granting authority to a package for DB2, 9.4.2.5
GRAPHIC datatype, 12.7.3
graphic string operations
unsupported, 12.7.3
grc error code, 15.1.3
GREATEST function, F
GREATEST SQL function, 12.6
GROUP BY clause, 12.6.1
GROUPBY SQL function, 12.6
GTW$_BIND_PKG
internal stored procedure, 9.4
stored procedure, 9.3.4
GTW_SQL.GTWPASS
function, 12.8.2

H

hardware requirements
memory, 3.1.2
HAVING clause, 12.6.1
HAVING SQL function, 12.6
heterogeneous database integration, 1.9.10, 1.9.10
Heterogeneous Services (HS)
see also HS
component of the Oracle9i server, 1.2
parameter syntax and usage, C.3
HEXTORAW function, F
HEXTORAW SQL function, 12.6
HGO-00706 error, 15.1.2
host
architecture, 1.5
components when installed on gateway, 1.6
creating an independent process, 1.6
database error, 15.3
relationship to gateway and Oracle server, 1.5
variable
converting character string datatypes, 12.7.2
moving data between applications and the database, 12.7
HS (Heterogeneous Services)
architecture features, 1.9.1
Oracle Net considerations, 14.5
HS= (TNSNAMES parameter for Oracle Net), 10.4.2, 10.4.2
gateway migration problems, 14.2
HS_DB_DOMAIN parameter, 2.6.1
HS_DB_NAME parameter, 2.6.1
HS_NLS_DATE_FORMAT, D.3.2.2
parameters, 12.7.5
support, 12.7.6
HS_NLS_DATE_LANGUAGE, D.3.2.3
HS_RPC_FETCH_REBLOCKING parameter, 1.9.3, 12.1.1
HS_RPC_FETCH_SIZE parameter, 1.9.3, 12.1.1, 12.1.1

I

IBM Communication Server
definitions, 7.7
server selection, 7.7
implementation
gateway components, 1.6
implicit data conversion, 12.6
implicit protocol conversion, 1.3.3
IMS transaction, 12.3.2
inbound connections
processing, 13.5
incremental row changes, 11.7.3
Independent LU, 6.4, 7.4
INITCAP function, F
INITCAP SQL function, 12.6
initdrdahoa1.ora
sample Gateway Initialization File, B.1
initialization parameters
new since V4 gateway, 14.3.1.2
initsid.gtw file
sample, 9.3.1
initsid.gtwboot
migrating, 14.1.2
parameters moved to initsid.ora, 9.3
initsid.ora file
containing initsid.gwtboot parameters, 9.3
invalid ORA_MAX_DATE specified, 15.3
NLS parameters, D.3.2
parameter not recognized, 15.1.5
parameters have changed format, 14.1.3
sample, 9.3.1
simplified syntax, see Appendix C, 9.3
tailoring, 9.3.2.1
input bind variables, 12.7.4.2
INSERT
command restriction, 2.6
command, supported by COPY, 11.8
operation, 12.1
Oracle SQL command, known restrictions, 2.6
SQL clause, 12.7.7
statement, 12.7.5, 12.7.5, 12.8
with read-only gateway, 11.6
installation
checklists, 4.3, 4.3, 5.1, 9.1, 10.1
from CD, 4.6
log file, INSTALL.LOG, 4.6.5
overview, 4.4
INSTALL.LOG, 4.6.5
INSTR function, F
INSTR SQL function, 12.6
INSTRB function, F
INSTRB SQL function, 12.6
integrating Oracle server
requirements, 3.2.4
internal tracing, C.4.34
Internet and intranet support, 1.3.3
INTERSECT
SQL set operators and clauses, 12.6.1
IPC
adapter, B.3
ISO standard
SQL, 1.3.5
isolation level, C.4.11

J

JOIN
capability, 1.3.2
JOIN SQL statement, 12.1

K

keywords
LISTENER, B.3
known problems, 2.5
compatibility with DB2/UDB, 2.5
known restrictions, 2.6
accessing DB2 alias objects, 2.6
AVS mapping user IDs, 2.6.1
bind variables become SQL parameter markers, 2.6.2
binding the DRDA gateway package on DB2/UDB, 2.6.1
character set limitation, 2.6.1
CONNECT BY not supported, 2.6.2
datatype limitations, 2.6.1
date arithmetic, 2.6.1
DD basic tables and views, 2.6.1
dictionary views not provided for DB2/VM or DB2/UDB, 2.6.1
DRDA server character sets, 2.6.1
GLOBAL_NAMES parameter, 2.6.1
LONG datatype in SQL*Plus, 2.6.1
null values and stored procedures, 2.6.1
Oracle ROWID column, 2.6.2
row length, 2.6.1
row length limitation, 2.6.1
SAVEPOINT, 2.6.1
single gateway instances per DRDA network interface, 2.6.1
SQL*Plus DESCRIBE command, 2.6
string concatenation, 2.6.1
SUBSTR function post-processed, 2.6.1

L

LANGUAGE parameter, D.3.2.1
see also Gateway Initialization File
languages, 1.3.10
SQL*Plus, 1.3.12
LAST_DAY function, F
LEAST function, F
LEAST SQL function, 12.6
LENGTH function, F
LENGTH SQL function, 12.6
LENGTHB function, F
LENGTHB SQL function, 12.6
Link service definition, 6.7
link, also see Database Link, 12.4
linkage conventions
SIMPLE WITH NULLS, 12.3.2
linkname, 9.6.1
listener, B.3
LISTENER keyword, B.3
listener.ora
file, 9.8
file, sample, B.3
sample, B.3
listener.ora file, 10.4.2
literal
character literals, 12.7.4.1
date, 12.7.4.2
specific datatype, 12.7
TO_DATE, 12.7.7
LN function, F
LN SQL function, 12.6
Local LU definition, 6.7
log file, installation, 4.6.5
LOG function, F
LOG SQL function, 12.6
LOG_DESTINATION parameter, C.4.34
logging, LOG_DESTINATION, C.4.31
LONG columns
known restrictions, 2.6.1
LONG datatype, 12.7.2
known restrictions, 2.6.1
LONG RAW datatype, 12.7.1, 12.7.1
LOWER function, F
LOWER SQL function, 12.6
LPAD function, F
LPAD SQL function, 12.6
LTRIM function, F
LTRIM SQL function, 12.6
LU's
dependent, 6.4, 7.4
independent, 6.4, 7.4
local definition, alias, network name, 6.7
remote definition, 6.7

M

mapped sqlstate errors, 15.2
mapping user IDs
known restrictions, 2.6.1
memory, hardware requirements, 3.1.2
Microsoft Windows Sockets, 3.1.3
migrating the gateway instance, 14.4
migration problems, 14.2
migration, defined, 14.1
MINUS
set operator, 12.6.1
SQL set operators and clauses, 12.6.1
Mobile Agents, 1.3.3
MOD function, F
MOD SQL function, 12.6
Mode definition, 6.7
MONTHS_BETWEEN function, F

N

National Language Support
initsid.ora parameters, D.3.2
overriding codepage, C.4.14
overview, D
Native Semantics
main topic, 12.6
gateway features, 1.9.7
parameters, 12.6.1
with SUBSTR function, 2.6.1
network
configuration tool, 8.2
Oracle Net configuration, 10.4
requirements, 3.1.3
transparency, 1.3.1
NEW_TIME function, F
NEXT_DAY function, F
NLS
Also See National Language Support, D
DRDA server character sets, D.4
NLS_DATE_FORMAT
function, 12.7.5, 12.7.5
parameter, 12.7.6
NLS_INITCAP function, F
NLS_LANG
environmental variable, D.1
server-side parameter, D.1
NLS_LOWER function, F
NLS_UPPER function, F
NLSSORT function, F
NLSSORT SQL function, 12.6
non-character binary data, 12.7.1
null
rows, 12.7.9
values, 12.7.9
null values
known restrictions, 2.6.1
number of cursors, C.4.20
numbers
concatenation restrictions, 2.6.1
numeric datatype, 12.7.8, 12.7.10
numeric datatype operations, 12.7.8

O

o2pc.sql, 9.4.2.6, 11.5.2
obsolete parameters since V4 gateway, 14.3.4
open cursors, at the IBM database, 12.10
OPEN_LINKS parameter, 11.1.5
operating system requirements, 3.2.1
operations
DELETE, 12.1
INSERT, 12.1
SELECT, 12.1
UPDATE, 12.1
operators
UNION, 12.6.1
UNION ALL, 12.6.1
option
binding packages, 9.3.5
data dictionary views, 12.9
date format string, 12.7.5
DRDA session security, 13.5.1.1
FOR BIT DATA, 12.7.1
Oracle server, 1.5
read-only, 11.6
gateway configuration, 1.3.13
replicating, 11.7
security conduct, 13.5
service port number, C.4.6
SNA security, 6.10, 7.10
SQL functions, 12.6
SQL*Plus COPY command, 11.8
ORA_NLS33 parameter
description, D.1
ORA-00001 error, index constraint violated, 15.2
ORA-00942 error
object does not exist, 15.2
object name too long, 15.2
ORA-01017 error, logon denied, 15.2
ORA-01031 error, insufficient privileges, 15.2
ORA-01460 error, invalid CCSID, 15.2
ORA-01476 error, divide by zero, 15.2
ORA-02019 error, undefined database link name is specified, 15.1.1
ORA1 Oracle instance, 12.2
ORA-1460 error, C.4.14
ORA2 Oracle instance, 12.2
ORA-28500 error
was ORA-09100, 15.1.3
example, collection ID or package name not recognized, 15.1.5
ORA-28501 error
was ORA-09101, 15.1.3
communication error, 15.1.4
Side Information Profile not defined, 15.1.4
ORA-9100 to ORA-9199 errors, 15.1.1
Oracle
error code, mapped errors, 15.2
error number or return code, 15.1
products compatibility, 1.8
RAW datatype, C.4.7
snapshots, 11.7.2
stored procedure, defined, 12.2
Oracle integrating server
architecture, 1.5
configuration, 9.6
defined, 1.5
definition, 1.4
gateway and Oracle integrating server are not on the same host, 1.5
Oracle Net, 14.5
and application development, 1.9.16
and distributed processing, 10.3.1
and remote data access, 1.9.14
and server coexistence, 1.5
API, 10.3
compatibility with SQL*Net, 10.2
configuring, 10.4, 10.4
distributed
database, 10.3.2
processing, 10.3.1
editing to set up security test, 10.6.1
gateway and Oracle integrating server are not on the same host, 1.5
gateway migration problems, 14.2
Heterogeneous Services (HS) facility, 10.2
introduction, 10.2
operating system authentication, 13.2
overview, 10.3
product version, 2.1
purpose, 1.6
requirements, 3.2.5
sample files, B
sample listener.ora file, B.3
support, 1.3.11
support for CHECKSUM and encryption, 10.5
terminology, 10.3.3
client, 10.3.3
driver, 10.3.3
host, 10.3.3
network, 10.3.3
protocol, 10.3.3
Oracle Replication Services, 11.7.3
Oracle ROWID column, 2.6.2
Oracle ROWID function, 2.6.2
Oracle server dependencies, 2.4
ORACLE_HOME
preinstallation and caution notice, 4.5
ORACLE2PC table, 5.2.2, 5.3.2, 5.4.2, 5.4.2, 5.5.2, 9.3.5, 9.4.1.2, 9.4.2.5, 11.5.3
DRDA_PACKAGE_OWNER, C.4.19
Oracle9i server, 1.2
relationship to host, 1.5
services, 1.3.2
database triggers, 1.3.2
distributed capabilities, 1.3.2
distributed query optimization, 1.3.2
SQL, 1.3.2
stored procedures, 1.3.2
two-phase commit protection, 1.3.2
ORADRDA.ORACLE2PC table, 11.5.2
ORAIND sample DB2 stored procedure, G.2
oraproc1, 12.2
stored procedure, 12.2
oraproc2
stored procedure, 12.2
ORARECOV user ID, 5.2.3, 5.3.3, 5.4.3, 5.5.3
ORARECOV userid, C.4.24
ORDER BY clause, 12.6.1
ORDERBY SQL function, 12.6
OS/390 (MVS), 5.2
OS/390 (MVS) VTAM
configuring, 5.2.1
overriding codepage, C.4.14

P

package
collection ID, C.4.16
consistency token, C.4.17
privileges - BIND, COPY, and EXECUTE, 5.2.2, 5.4.2, 5.5.2, E
packed decimal, 12.7.10
paragraph tags
PT PrefaceTitle, Preface
parameter
changed, 14.3.2
checking settings, 9.4.1.1
diagnostic, C.4.33
gateway, 5.5.4
list of parameters needed to configure the gateway, E
Native Semantics, 12.6.1
new since V4 gateway, 14.3.1.2
obsolete since V4 gateway, 14.3.4
parameter syntax and usage, C.3
renamed since V4 gateway, 14.3.3
Startup Shell Script, new since V4 gateway, 14.3.1.1
parameters
CHARACTER SET, D.2
DB_DOMAIN, 2.6.1
DRDA_CAPABILITY, 12.6
DRDA_CODEPAGE_MAP, C.4.29, D.4
DRDA_CONNECT_PARM
configuring IBM Communication Server, 7.7
configuring Microsoft SNA server or host server, 6.7
configuring the gateway for TCP/IP, 8.2
DRDA_DESCRIBE_TABLE, 2.6
DRDA_DISABLE_CALL, 9.4.1.1
DRDA_PACKAGE_NAME, 9.4.1.1
DRDA_PACKAGE_SECTIONS, 12.10
DRDA_READ_ONLY, 11.6
DRDA_RECOVERY_PASSWORD, 5.2.3, 5.3.3, 5.4.3
DRDA_RECOVERY_USERID, 5.2.3, 5.3.3, 5.4.3, 5.5.3
FDS_CLASS_VERSION, C.4.29, C.4.29
Gateway Initialization File
DRDA_CONNECT_PARM, configuring the gateway for TCP/IP, 8.2, 11.5, 15.1.4, 15.1.5, 15.1.5, C.4.1, C.4.3, C.4.4, C.4.27
HS_DB_DOMAIN, 2.6.1
HS_DB_NAME, 2.6.1
HS_RPC_FETCH_REBLOCKING, 1.9.3, 12.1.1, 12.1.1
HS_RPC_FETCH_SIZE, 1.9.3, 12.1.1, 12.1.1
LOG_DESTINATION, C.4.34
NLS_DATE_FORMAT, 12.7.6
OPEN_LINKS, 11.1.5
passthrough, 12.8.3.1
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 1.9.4
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE syntax, 12.8.2
gateway feature, 1.3.8
native SQL through the gateway, 12.8
result sets, 12.8.3.1
result sets from queries, 12.8
retrieving result sets, 12.8.3
SQL feature, 12.8
performance enhancements
with fetch reblocking, 12.1.1
PL/SQL
call, 12.3.1
records, 12.3.2
routine, 1.3.9.1
running stored procedures, 12.3
standard Oracle, 1.3.9.2
stored procedure, 12.2
port number
Primary, 5.2.1, 5.3.1, 5.4.1
Recovery, 5.2.1, 5.3.1, 5.4.1
post processing
defined, 12.5.3
native semantics, 12.6
post-processed SQL functions
overview, 12.5.3
SQL tracing, 15.4
POWER function, F
POWER SQL function, 12.6
PREPARE TRANSACTION statement, 11.5.2
Primary port number, 5.2.1, 5.3.1, 5.4.1
privileges
BIND, 5.2.2, 5.4.2, 5.5.2, E
BINDADD, 5.2.2, 5.4.2, 5.5.2, E
BINDAGENT, 5.2.2, 5.4.2, 5.5.2, E
COPY, 5.2.2, 5.4.2, 5.5.2, E
CREATE IN, 5.2.2, 5.4.2, 5.5.2, E
CREATE PUBLIC DATABASE LINK, 9.3.4, 9.6.1
data dictionary limitations, 12.9
EXECUTE, 5.2.2, 5.4.2, 5.5.2, E
procedure
stored
with read-only gateway, 11.6
stored, using DRDA server, 12.3
procedures
DB2
DB2INS, sample, G.1
ORAIND, sample, G.2
processing time, with GROUPBY, HAVING, WHERE, 12.6
processor requirements, 3.1.1
profile set, 9.8
protocol
commit confirm, 1.3.13
communications and DRDA-specific parameters, 8.2
communications protocols with Oracle Net, 10.3
converter, 1.3.3
definition, 10.3.3
implicit protocol conversion, 1.3.3
network, 11.4
Oracle Net Protocol Adapters, 10.2
protocol-independent encryption, 1.3.3
two-phase commit, 11.5.2
protocols
IPC, 10.4.2
LU6.2, 1.5
SNA, 1.5
TCP/IP
for the DRDA server, 1.5
how supported, 1.9.6
implicit protocol conversion, 1.3.3
PT PrefaceTitle, Preface
public database link, 9.6.1

Q

queries, distributed, 11.5

R

RAW datatype, 12.7.1, 12.7.1, C.4.7
RAWTOHEX function, F
RAWTOHEX SQL function, 12.6
read-only, C.4.22
read-only gateway, main topic, 11.6
read-only support, 2.4
rebind, C.4.9, C.4.11, C.4.16, C.4.19
Recovery port number, 5.2.1, 5.3.1, 5.4.1
recovery user ID and password, 5.2.3, 5.3.3, 5.4.3, 5.5.3
remote
computer, 10.3.1
connections, 11.1.5
data, 1.3.2
data access, 1.9.14
database, 5.2.3, 5.3.3, 5.4.3, 5.5.3, 9.4, 11.1.1, 11.8, 15.1.1, 15.3, C.4.20, E
database, defining a path, 11.1.1
DB2 system, 2.6
DRDA database, C.4.11
DRDA server object information, 2.6
instance, 12.2
LU definition, 6.7
objects, 13.3.1
Oracle instance, 12.2, 12.3
Oracle servers, 10.3.2
procedure, 1.3.9.2
table, 1.3.4
transaction program, 3.1.2
userid and password, 11.1.1
renamed parameters, 14.3.3
REPLACE
command, supported by COPY, 11.8
function, F
REPLACE SQL function, 12.6
replication, 11.7
requirements
hardware, 3.1
software, 3.2
restrictions, 2.6
RESULT, 12.3.1
result sets, 1.9.5
columns in, 1.9.8
return code, 15.1
REVISE_SALARY
stored procedure example, 12.3.1
ROUND function, F
ROUND SQL function, 12.6
row length
known restrictions, 2.6.1
ROWID
known restrictions, 2.6.2
Oracle column, 2.6.2
with UPDATE or DELETE, 2.6.2
ROWIDTOCHAR function, F
RPAD function, F
RPAD SQL function, 12.6
RTRIM function, F
RTRIM SQL function, 12.6

S

sample
files, B
listener.ora file, B.3
SQL scripts, 9.4.2
Sample files
initsid.gtw, 9.3.1
initsid.ora, 9.3.1
sample Gateway Initialization File
initdrdahoa1.ora, B.1
SAVEPOINT
Known Restrictions, 2.6.1
known restrictions, 2.6.1
scripts
dropold.sql, 9.4.2.2
g4ddtab, 9.4.2.3
g4ddview.sql, 9.4.2.3
security
Advanced Security, 1.3.3
DRDA_SECURITY_TYPE, C.4.26
encryption, 10.5
overview, 13.1
site autonomy, 1.3.14
TCP/IP, 13.4
validation for SNA, 6.9, 7.9
validation for TCP/IP, 13.4
SELECT and array size, 1.9.3
SELECT operation, 12.1
SELECT SQL statement, 12.8.3
SELECT statement, 12.1.1
compensated SQL functions, 12.5.3
fetch reblocking, 12.1.1
retrieve results sets, 12.8.3
with read-only gateway, 11.6
SELECT WHERE SQL clause, 12.7.7
semantics, 12.6
server selection, 6.7, 7.7
service port number, C.4.6
session, connection, 12.4
set operator, compatibility, 12.6.1
set operators
EXCEPT, 12.6.1
INTERSECT, 12.6.1
MINUS, 12.6.1
SID
choosing a gateway SID, 9.2
configuring additional DRDA server instances, 9.8
Gateway System Identifier, defined, 9.2
Side Information Profile
communication error, 15.1.4
definition, 6.3, 7.3
SIGN function, F
SIGN SQL function, 12.6
SIMPLE linkage convention, 12.3.2, G.1
SIN function, F
SIN SQL function, 12.6
SINH function, F
SINH SQL function, 12.6
site autonomy, 1.3.14
SNA
configuring AS/400 communications, 5.3.1
configuring DB2/UDB communications, 5.4.1
configuring OS/390 communications, 5.2.1
configuring VM communications, 5.5.1
conversation security, 6.10, 6.10, 7.10, 7.10
CPI-C error, 15.1.4
facilities, 1.9.11
functions, 1.6
LU, 13.5.1.1
protocol, 1.5
remote access, 1.9.14
security, C.4.26
security validation, 6.9, 7.9, 13.4
SECURITY=PROGRAM, 6.10.1, 7.10.1
SECURITY=SAME, 6.10.2, 7.10.2
send/receive buffer, C.4.4
session allocation mode, C.4.2
SNA Server
connection definition, 6.7
CPI-C symbolic destination names, 6.7
definitions, 6.3, 6.7, 7.3
for Windows NT, 6.4
link service definition, 6.7
local LU definition, 6.7
mode definition, 6.7
remote LU definition, 6.7
server selection, 6.7
testing the connection, 6.8, 7.8
SNA Server for Windows NT
dependent LUs, 7.4
independent LUs, 7.4
SNACFG command, 6.5.1
snacfg.ctl file, 6.5.1, 7.5.1
snapshots
known restrictions, 2.6.2
Oracle snapshot feature, 11.7.2
software requirements, 3.2
sort order
with ORDERBY, 12.6
SOUNDEX function, F
SPUFI on DB2/OS390, 9.4.2
SQL
main topic, 1.3.5
ANSI standard, 1.3.5
clause compatibility, 12.6.1
clauses
DELETE, 12.7.7
INSERT, 12.7.7
SELECT WHERE, 12.7.7
UPDATE, 12.7.7
commands
DESCRIBE, 2.6
constructs
Oracle processing, 12.5
differences in the gateway, 1.7.1
functions, F
ABS, 12.6, F
ACOS, F
ADD_MONTHS, F
ASCII, 12.6, F
ASIN, F
ATAN, F
ATAN2, F
CEIL, 12.6, F
CHAR_TO_ROWID, F
CHR, 12.6, F
CONVERT, 12.6, F
COS, 12.6, F
COSH, 12.6, F
DECODE, 12.6, F
DUMP, 12.6, F
EXP, 12.6, F
FLOOR, 12.6, F
GREATEST, 12.6, F
GROUPBY, 12.6
HAVING, 12.6
HEXTORAW, 12.6, F
INITCAP, 12.6, F
INSTR, 12.6, F
INSTRB, 12.6, F
LAST_DAY, F
LEAST, 12.6, F
LENGTH, 12.6, F
LENGTHB, 12.6, F
LN, 12.6, F
LOG, 12.6, F
LOWER, 12.6, F
LPAD, 12.6, F
LTRIM, 12.6, F
MOD, 12.6, F
MONTHS_BETWEEN, F
NEW_TIME, F
NEXT_DAY, F
NLS_INITCAP, F
NLS_LOWER, F
NLS_UPPER, F
NLSSORT, 12.6, F
ORDERBY, 12.6
POWER, 12.6, F
RAWTOHEX, 12.6, F
REPLACE, 12.6, F
ROUND, 12.6, F
ROWIDTOCHAR, F
RPAD, 12.6, F
RTRIM, 12.6, F
SIGN, 12.6, F
SIN, 12.6, F
SINH, 12.6, F
SOUNDEX, F
SQRT, 12.6, F
STDDEV, 12.6, F
SUBSTR, 12.6, 12.6, F
SUBSTRB, 12.6, F
SYSDATE, F
TAN, 12.6, F
TANH, 12.6, F
TO_CHAR, F
TO_DATE, F
TO_LABEL, F
TO_MULTI_BYTE, F
TO_NUMBER, F
TO_SINGLE_BYTE, F
TRANSLATE, 12.6, F
TRUNC, 12.6, F
UID, F
UPPER, 12.6, F
USER, F
USERENV, F
VARIANCE, 12.6, F
VSIZE, F
WHERE, 12.6
functions and Native Semantics, 12.6
ISO standard, 1.3.5
native DB2, 1.3.8
passthrough, 12.8, 12.8.2, 12.8.3, 12.8.3.1
statements
DB2, 12.8.2
DRDA_ISOLATION_LEVEL, C.4.11
issued through the gateway, 11.10
passing through gateway, 12.8
using JOIN, 12.1
syntax, 12.7.9
tracing, 11.10, 15.4
SQL functions
column functions, 12.5.1
compatible, defined, 12.5.1
compensated, defined, 12.5.3
DB2/400, 12.5.7
DB2/CS, 12.5.6
DB2/OS390, 12.5.5
SQL/DS, 12.5.8
translated
defined, 12.5.2
with Native Semantics, 12.6
SQL*Net
Heterogeneous Services (HS) facility, 10.2
replaced by Oracle Net, 10.2
requirements, 3.2.5
SQL*Plus, 1.3.12, 10.7.1, 11.8
DESCRIBE command, known restrictions, 2.6
extending gateway uses, 1.8.1
Version 8, 2.6
sqlstate, mapped sqlstate errors, 15.2
SQRT function, F
SQRT SQL function, 12.6
stability of cursor, DRDA_ISOLATION_LEVEL, C.4.11
Startup Shell Script, 9.3.4
migration, 14.1.2
parameter syntax and usage, C.3
parameters new since V4 gateway, 14.3.1.1
statements
CREATE DATABASE LINK, 11.1.1
DB2 CREATE TABLE, 1.3.8
DDL, 12.8, 12.8.2
DELETE, 12.7.5, 12.8
DROP DATABASE LINK, 11.1.3
GRANT, 9.6.2
INSERT, 12.8
PREPARE TRANSACTION, 11.5.2
SELECT, 12.1.1
compensated SQL functions, 12.5.3
fetch reblocking, 12.1.1
retrieve results sets, 12.8.3
with read-only gateway, 11.6
SQL
DB2, 12.8.2
JOIN, 12.1
SELECT, 12.8.3
UPDATE, 12.7.5, 12.8
STDDEV function, F
STDDEV SQL function, 12.6
stored procedure
creating on DB2, 12.3.1
extended database services, 1.3.2
native DB2, 1.3.9.2
Oracle and non-Oracle, 1.3.9
Oracle database server
local instance, 12.2
PL/SQL, 12.2
remote instance, 12.2
Oracle, description, 1.3.9.1
Oracle8 database server
using, 12.2
restriction, 2.6.1
usage, C.4.9
using DRDA server, 12.3
stored procedures
DB2
considerations for use, 12.3.2
native to DRDA server, 12.3
with read-only gateway, 11.6
DB2INS, sample, G.1
GTW$_BIND_PKG, 9.3.4
ORAIND, sample, G.2
REVISE_SALARY, example, 12.3.1
string concatenation
known restrictions, 2.6.1
string index, with Native Semantics, 12.6
Structured Query Language, also see SQL, 1.2.1
SUBSTR
function, F
SQL function, 12.6
SUBSTR SQL function, 12.6
known restrictions, 2.6.1
with Native Semantics, 2.6.1
SUBSTRB function, F
SUBSTRB SQL function, 12.6
synonym, 1.7
feature, 11.4
for location transparency, 12.2
SYSDATE function, F
system privileges - BINDADD and BINDAGENT, 5.2.2, 5.4.2, 5.5.2, E

T

table
create a table in DB2, 12.8.2.1
insert a row into a DB2 table, 12.8.2.1
TABLE_PRIVILEGES view, A.2.17
tables
EXPLAIN_PLAN, 1.9.9
ORACLE2PC, 9.4.1.2, 9.4.2.5, 11.5.3
ORADRDA.ORACLE2PC, 11.5.2
tailoring
initsid.ora file, 9.3.2
TAN function, F
TAN SQL function, 12.6
TANH function, F
TANH SQL function, 12.6
TCP/IP
concurrent connections, 3.1.2
configuring
for AS/400, 5.3.1
for DB2/UDB, 5.4.1
for OS/390, 5.2.1
for VM, 5.5.1
database link behavior, 12.4
facilities, 1.9.11
functions, 1.6
hostname parameter, C.4.6
modifying tnsnames.ora in Oracle Net, 10.4.2
protocol
access across multiple networks, 1.3.1
DRDA server support, 1.5
implicit protocol conversion, 1.3.3
remote access, 1.9.14
security, 13.4
security validation, 13.4
support, 1.9.6
terminology defined, 1.4
tg4drda\sna\commsvr subdirectory, sample SNA Server definitions, 7.5.1
tg4drda\sna\mssna subdirectory, sample SNA Server definitions, 6.5.1
TIME datatype, 12.7.4.1
time operations, 12.7.4
TIMESTAMP datatype, 12.7.4.1
TNSNAMES.ORA
changes to, during migration problems, 14.2
extra parameter needed (HS=), 2.4
tnsnames.ora
connect descriptor, 11.1.1
file, 9.6.1, 9.8, 10.4.2
modifying for Oracle Net, 14.5
TO_CHAR function, F
TO_DATE
clause, 12.7.7
function, 12.7.4.2, 12.7.5, 12.7.6, 12.7.7, 12.7.7, F
TO_LABEL function, F
TO_MULTI_BYTE function, F
TO_NUMBER function, F
TO_SINGLE_BYTE function, F
token, package consistency, C.4.17
trace control, C.4.33
tracing
LOG_DESTINATION, C.4.31
ORACLE_DRDA_TRACE, C.4.34
SQL statements, 11.10
TRACE_LEVEL, C.4.35
tradeoff, Native Semantics, 12.6
transaction mode, read-only, C.4.22
transactions
CICS, 12.3.2
IMS, 12.3.2
TRANSLATE function, F
TRANSLATE SQL function, 12.6
translation, C.4.14
transparency
and performance, 12.6
main topic, 1.3.1
triggers for Oracle9i database server, 11.7.1
TRUNC function, F
TRUNC SQL function, 12.6
TSO, 5.2
two-phase commit
ORACLE2PC table, 5.2.2, 5.3.2, 5.4.2, 5.5.2
protection, 1.3.2
transactions, 11.5.2
unsupported statement, 11.5.2

U

UID function, F
UNION
capability, 1.3.2
operator, 12.6.1
SQL set operators and clauses, 12.6.1
UNION ALL
operator, 12.6.1
SQL set operators and clauses, 12.6.1
UPDATE
known restrictions, 2.6.2
operation, 12.1
SQL clause, 12.7.7
statement, 12.8
with read-only gateway, 11.6
upgrading, defined, 14.1
UPPER function, F
UPPER SQL function, 12.6
USER function, F
user privileges, 12.9
USER_CATALOG view, A.2.18
USER_COL_COMMENTS view, A.2.19
USER_CONS_COLUMNS view, A.2.21
USER_CONSTRAINTS view, A.2.20
USER_DB_LINKS data dictionary view, 11.1.4
USER_INDEXES view, A.2.22
USER_OBJECTS view, A.2.23
USER_SYNONYMS view, A.2.24
USER_TAB_COLUMNS view, A.2.26
USER_TAB_COMMENTS view, A.2.27
USER_TABLES view, A.2.25
USER_USERS view, A.2.28
USER_VIEWS view, A.2.29
USERENV function, F
userid mapping, 13.5.1
AVS, 13.5.1.2, 13.5.1.2
DB2/400, 13.5.1.3
DB2/OS390, 13.5.1.1
DB2/VM, 13.5.1.2
userid translation
DB2, 13.5.1.2
USING clause, 11.1.1

V

VALUES clause, 12.7.7
VARCHAR datatype, 12.7.2
VARGRAPHIC
datatype, 12.7.3
variable
bind, 12.8
input bind, 12.7.4.2
VARIANCE function, F
VARIANCE SQL function, 12.6
view
creating, 9.6.2
data dictionary, 12.9
views
catalog
DB2/400, 12.9.1
DB2/OS390, 12.9.1
DB2/UDB, 12.9.1
DB2/VM, 12.9.1
VM VTAM
configuring, 5.5.1
VSAM
file, 12.3.2
VSIZE function, F
VTAM, 5.2

W

WHERE clause, 2.6.2, 12.6.1
WHERE CURRENT OF CURSOR clause, 2.6.2
WHERE SQL function, 12.6
wireless communication, 1.3.3
workarounds, 2.5

Z

zoned decimal operations, 12.7.10

Previous
Oracle Logo
Copyright © 2001, 2002 Oracle Corporation

All rights reserved
Go To Table Of Contents
Contents