Go to main content
22/22
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
R
S
T
U
V
W
X
A
APPC
runtime,
4.10.2
SENDs and RECEIVEs
TIP CALL correspondence,
4.6.2
trace,
8.9.2.1
,
8.9.2.2
using with terminal-oriented transaction program,
4.12
APPC conversation sharing,
4.10
concepts,
4.10.1
examples,
4.10.5
for too large TIPs,
4.10.4
overrides and diagnostics,
4.10.6
TIP compatibility,
4.10.3
usage,
4.10.2
architecture
commit-confirm,
5.5
components of the gateway,
1.5
ASCII
automatic conversion,
1.2
B
BIT_AND function,
C.1.1
BIT_COMPLEMENT function,
C.1.2
BIT_OR function,
C.1.3
BIT_XOR function,
C.1.4
C
CALL correspondence
on gateway using SNA,
4.6.2
on gateway using TCP/IP,
7.3.2
call correspondence order restrictions
on gateway using SNA,
4.6.2.2
on gateway using TCP/IP,
7.3.2.2
CAST_TO_RAW function,
C.1.5
CAST_TO_VARCHAR2 function,
C.1.6
CICS,
1.9.1
CICS Transaction Server
gateway starts communication with,
1.10.1
client application development
calling a TIP
on gateway using SNA,
4.7
on gateway using TCP/IP,
7.4
customized TIPs for remote host transaction,
4.4
declaring TIP variables,
4.7.1
,
7.4.1
error handling
on gateway using SNA,
4.8.2
on gateway using TCP/IP,
7.5.2
examples and samples,
1.4
exchanging data,
4.8
on gateway using TCP/IP,
7.5
executing,
4.9
,
7.7
granting execute authority,
4.8.3
,
7.5.3
on gateway using TCP/IP,
7
overriding TIP initializations,
4.7.2.2
on gateway using TCP/IP,
7.4.2.2
overview,
4.1
preparation,
4.2
remote host transaction types
multi-conversational transactions,
4.3.2.3
one-shot transactions,
4.3.2.1
persistent transactions,
4.3.2.2
See also, index entries for each transaction type
requirements,
4.5
declare RHT/TIP data to be exchanged,
4.5
,
4.5
,
4.5
exchange data with RHT using TIP user function,
4.5
,
4.5
initialize RHT for multi-conversational applications,
4.5
initialize RHT using TIP initialization function,
4.5
,
4.5
repetitively exchange data with RHT using TIP user function,
4.5
terminate RHT using TIP termination function,
4.5
,
4.5
,
4.5
security considerations,
4.7.2.3
,
7.4.2.3
terminating the conversation,
4.8.1
,
7.5.1
TIP and remote transaction program correspondence,
4.6
,
7.3
TIP CALL correspondence,
4.6.2
TIP content and purpose,
4.3.1
TIP DATA correspondence,
4.6.1
,
7.3.1
TIP TRANSACTION correspondence
on gateway using SNA,
4.6.3
on gateway using TCP/IP,
7.3.3
client application development for gateway using TCP/IP
overview,
7.1
client application development on gateway using TCP/IP
preparing,
7.2
COBOL,
4.2
,
7.2
,
D.2
,
D.2.4
datatype conversion supported by PG DD and TIPs,
D.2
lacks datatype for variable length data,
D.2.1
PGAU interpretation of COBOL symbols,
D.2.1
support for double byte character sets, PIC G datatypes,
4.11
,
7.8
COMMIT command,
2.2.1
,
2.2.2
user responsibility,
2.2.1
COMMIT processing,
2.2.1
commit-confirm,
5.1
application design requirements,
5.4
architecture,
5.5
components,
5.5.1
interactions,
5.5.2
components,
5.3
logic flow,
5.6
step by step,
5.6.1
Oracle Global Transaction ID,
5.1
purpose,
5
relation to two-phase commit,
5.1
required components
OLTP commit-confirm transaction log,
5.3
OLTP forget/recovery transaction,
5.3
OLTP transaction logging code,
5.3
Oracle logging server,
5.3
supported OLTPs,
5.2
transaction log,
5.6.2
communication
between mainframe and Oracle integrating server
on gateway using SNA,
1.10
between server, gateway and remote host,
1.7
COMPARE function,
C.1.7
compiling a TIP,
3.4
CONCAT function,
C.1.8
CONNECT command,
2.3
,
2.6.1
control file
creating
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
conversation sharing, see APPC conversation sharing
CONVERT function,
C.1.9
COPIES function,
C.1.10
creating a TIP
(detailed),
3
overview,
1.11
,
1.14
D
data conversion
errors,
8.4
languages supported,
E.3
DATA correspondence,
4.6.1
,
7.3.1
data dictionary, see PG DD
data exchange
PGAXFER function,
1.8.1.2
data format conversion,
D
database instance,
1.6
database link,
1.7
datastores
gateway access to,
1.1
datatype
RAW,
C
datatype conversion,
D
COBOL editing symbols,
D.2.1
convert length,
D.1
duplicate names,
D.2.4
expected length,
D.1
format conversion,
D.2.1
parameters over 32K in length,
D.1.1
PL/SQL,
D.2.4
naming algorithms,
D.2.4
receive length,
D.1
removing support for parameters over 32K in length,
D.1.1
See USAGE (PASS), USAGE (ASIS). USAGE (SKIP), and PL/SQL Naming Algorithms
send length,
D.1
truncated and non-unique names,
D.2.4
datatype conversions
COBOL symbols interpreted by PGAU,
D.2.1
datatypes
See PIC X and PIC G
DBCS
See double-byte character sets
DBMS_PIPE PL/SQL package,
3.1
debugging tool
PGATRAC function,
B.1.5
DEFINE CALL,
2.1
DEFINE CALL parameters,
2.6.2
DEFINE CALL statement ("command"),
1.11.1
,
1.14.1
,
3.2.6
,
4.10.4
,
G.2
DEFINE DATA,
2.1
DEFINE DATA statement ("command"),
1.11.1
,
1.14.1
,
2.6.15
,
3.2.6
,
4.6.1
,
4.10.4
,
7.3.1
,
A.2.3.7
,
G.1
DEFINE TRANSACTION parameters,
2.6.4
DEFINE TRANSACTION statement ("command"),
3.2.6
,
4.10.4
,
G.3
defining and generating a TIP,
3.3
definition versioning,
2.5.2
deleting and inserting rows into PGA_TCP_IMSC table,
6.5
DESCRIBE command,
2.6.5
DISCONNECT command,
2.6.6
double byte character sets (DBCS)
in application development,
4.11
,
7.8
driver procedure
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
E
EBCDIC
automatic conversion,
1.2
environment dictionary
sequence numbers,
A.1.1
errors
causes of,
8.1
data conversion,
8.4
including exception handlers in your TIP,
4.8.2
,
7.5.2
NUMBER_TO_RAW function,
C.2.3
PLS -00123
program too large,
4.10.4
truncation,
8.5
examples
APPC conversation sharing,
4.10.5
EXECUTE command,
2.6.7
executing
client application development,
4.9
,
7.7
EXIT command,
2.6.8
F
file
initsid.ora,
1.3
,
8.9.1
,
8.9.1
,
8.9.2
,
8.9.2.1
,
E.2
,
E.2
,
E.2
pagaims,
F
pgadb2i,
F
pgadb2id.sql,
4.8.2
pgadb2i.pkb,
1.4
,
1.11.1
,
4.1
,
4.3.1
pgadb2i.pkh,
1.4
,
1.11.1
,
1.11.1
,
4.3.1
pgadb2i.sql,
F
pgau.trc,
2.6.9
,
2.6.9
pgddausr.sql,
4.13
,
7.9
pgddcr8.sql,
2.5.2
,
A.2
pgtflipd.sql,
7.5.2
,
F
pgtflip.pkb,
1.14.1
,
7.1
,
7.2.1
pgtflip.pkh,
1.14.1
,
7.2.1
tipname.doc,
3.5
,
4.5
,
4.7.1
,
7.4.1
tipname.pkb,
8.6
tname.ctl,
3.2.7
,
3.2.7
flexible call sequence
on gateway using SNA,
4.6.2.1
on gateway using TCP/IP,
7.3.2.1
FLIP
and pgacics PL/SQL stored procedure
on gateway using SNA,
1.10.1
transaction in CICS,
1.10
transaction in IMS,
1.13
format conversion,
D.2.1
function
PGATERM,
B.1.3
PGAXFER,
4.3.1
,
7.2.1
,
B.1.2
UTL_PG,
C.2
UTL_RAW,
C.1
functions
see RPC (remote procedural call)
See UTL_PG
see UTL_PG
See UTL_RAW,
C.1
see UTL_RAW
G
gateway
access to IBM datastores,
1.1
communication
overview,
1.7
with all platforms,
1.1
with CICS in mainframe on gateway using SNA,
1.10.1
components,
1.5
creating a TIP,
3
enabling a trace,
8.9.2.2
features
application transparency,
1.2
code generator,
1.2
fast interface,
1.2
flexible interface,
1.2
location transparency,
1.2
Oracle server integration,
1.2
performs automatic conversions,
1.2
site autonomy and security,
1.2
support for tools,
1.2
function,
1
initialization files,
1.3
language support,
E.2
overview,
1.1
using TCP/IP,
1.1
remote procedure, definition,
1.3
remote transaction initiation
using SNA,
1.8.1.1
using TCP/IP,
1.8.1.1
remote transaction termination
using SNA,
1.8.1.3
using TCP/IP,
1.8.1.3
server trace output sample,
8.10
starting,
1.6
tracing,
8.9
transaction types
on gateway using SNA,
1.9.1
on gateway using TCP/IP,
1.12.1
gateway sample files
using SNA
pgadb2i.pkb,
1.4
using TCP/IP
pgadb2i.pkb,
1.4
pgadb2i.pkh,
1.4
gateway sample files, using SNA
pgadb2i.pkh,
1.4
gateway server,
5.5.1
function in commit-confirm architecture,
5.5.1
transaction log tables,
5.6.2
gateway server trace,
8.9
,
8.9.2
output sample,
8.10
GENERATE,
2.1
GENERATE statement ("command"),
1.11.1
,
1.14.1
,
3.2.6
,
3.3
,
4.6.1
,
7.3.1
,
F.2
,
G.4
GLOBAL_TRAN_ID,
5.6.2
granting privileges for creating TIPs,
3.1
GROUP statement (PGAU),
3.3
H
HOST command,
2.6.11
hp-ux
in gateway architecture,
1.5
starting the gateway,
1.6
I
implicit APPC,
4.12
implicit versioning
sample definitions,
G.5
IMS,
1.1
communication with Integrating Server
using TCP/IP,
1.13.2
IMS inquiry
location of sample file,
1.4
IMS/TM
communication through the gateway,
1
initialization files
see gateway initialization files, also see PGA parameters
initiating remote transactions,
1.8.1.1
,
1.8.1.1
initsid.ora file,
1.3
,
8.9.1
,
8.9.1
,
8.9.2
,
8.9.2.1
,
E.2
,
E.2
,
E.2
parameters to run pg4tcpmap tool,
6.4
I/O PCB,
1.13
,
3.2.1
,
7.1
J
JUSTIFIED,
D.2.1
JUSTIFIED LEFT,
D.2.1
JUSTIFIED RIGHT,
D.2.1
K
keywords
PGAU,
2.5.3
L
LANGUAGE parameter
LENGTH function,
C.1.11
LENGTH IS field-2,
D.2.1
LU_NAME,
5.6.2
M
MAKE_NUMBER_TO_RAW_FORMAT function,
C.2.5
MAKE_RAW_TO_NUMBER_FORMAT function,
C.2.4
mapping parameters
from SNA to TCP/IP,
1.13.1
,
6.1
mapping table
PGA_TCP_IMSC,
1.13.2
MBCS, See multi-byte character sets
messages
UTL_RAW interface,
C.1
MODE_NAME,
5.6.2
multi-byte character sets (MBCS),
4.11
,
7.8
application development support,
4.11
,
7.8
multi-conversational transaction type
for gateway using SNA,
1.9.1
multi-conversational transactions,
4.3.2.3
,
4.5
N
National Language Support (NLS),
3.2.4
,
E
in the gateway,
E.2
languages supported for data conversion,
E.3
multi-byte character set support,
4.11
,
7.8
on various platforms,
E.3
NLS LANGUAGE parameter
syntax,
E.2
non-persistent socket transaction type for TCP/IP for IMS Connect,
1.12.1
NUMBER_TO_RAW and RAW_TO_NUMBER argument values,
C.3
,
C.3
,
C.3
NUMBER_TO_RAW function,
C.2.3
errors,
C.2.3
NUMBER_TO_RAW_FORMAT function,
C.2.7
O
OCCURS DEPENDING ON,
D.2.1
OCCURS n TIMES,
D.2.1
OLTP
and TCP/IP,
1.3
,
1.5
character set,
E.3
commit-confirm transaction log,
5.3
definition,
1.3
forget/recovery transaction,
5.3
functional requirements of the gateway,
5.4
in commit-confirm,
5.1
in gateway architecture featuring SNA,
1.5
in gateway using TCP/IP,
1.5
logic flow for successful commit,
5.6
only IMS supported on gateway using TCP/IP,
1.2
,
1.3
parameters needed for NLS,
E.3
remote,
1
security considerations,
4.7.2.3
,
7.4.2.3
transaction logging code,
5.3
one-shot transaction types,
1.9.1
,
4.3.2.1
,
4.5
,
5.4
online transaction processor
See OLTP
operating system
role in gateway installation,
1.5
Oracle global transaction ID,
5.1
,
5.1
,
5.3
,
5.4
,
5.6.2
Oracle integrating server,
1.8.1.2
,
4.1
and role in client application, on gateway using TCP/IP,
7.1
calling RPC functions,
5.5.2
component of commit-confirm architecture,
5.5.1
component of the gateway,
1.5
definition,
1.3
function in gateway communication
on gateway using TCP/IP,
1.13
interaction with gateway server in commit-confirm,
5.5.2
multiple servers on the gateway
using SNA,
1.5
using TPC/IP,
1.5
precompiles PL/SQL package,
1.2
role
in gateway communication,
1.7
in starting the gateway,
1.6
simple communication
on gateway using SNA,
1.10
on gateway using TCP/IP,
1.13
,
1.13
steps to communication
between server and IMS,
1.13.2
between server and mainframe,
1.10.1
stores PL/SQL,
1.3
support for NLS,
E.3
Oracle logging server,
5.3
,
5.5.1
,
5.5.2
description,
5.5.1
interaction with gateway server,
5.5.2
Oracle Net,
1.3
,
4.13
,
7.9
,
C
,
C
restrictions for data conversion,
C
Oracle Procedural Gateway for APPC
also see gateway
compatibility with version 3.4.0,
4.10.3
development environment,
1.2
See also, gateway server
OVERLAY function,
C.1.12
overrides,
4.7.2.2
,
7.4.2.2
LOGMODE,
4.7.2.2
,
7.4.2.2
LUname,
4.7.2.2
,
7.4.2.2
Side profile,
4.7.2.2
,
7.4.2.2
TPname,
4.7.2.2
,
7.4.2.2
P
package
UTL_PG,
3.1
parameters
mapped to TPC/IP,
6.3
See NLS LANGUAGE
see PGAU commands
See remote procedural call (RPC)
See SET LOG_DESTINATION
See SET TRACE_LEVEL
persistent socket transaction type
for TCP/IP for IMS Connect,
1.12.1
persistent transaction type, for gateway using SNA,
1.9.1
persistent transactions,
4.3.2.2
,
4.5
,
4.5
,
5.4
PG DD (Data Dictionary),
2.1
,
2.6.4
active dictionary,
A.2
sequence numbers,
A.2.2
versioning,
A.2.1
active dictionary tables
pga_call,
A.2.3.5
pga_call_parm,
A.2.3.6
pga_data,
A.2.3.7
pga_data_attr,
A.2.3.9
pga_data_values,
A.2.3.10
pga_fields,
A.2.3.8
pga_trans,
A.2.3.1
pga_trans_attr,
A.2.3.2
pga_trans_calls,
A.2.3.4
pga_trans_values,
A.2.3.3
data definitions for parameters over 32K in length,
D.1.1
datatype conversion support for COBOL,
D.2
definition,
1.3
definition names
valid characters in,
2.5.1
diagnostic
options,
8.2
references,
8.1
entries, creating a TIP,
3.3
environment dictionary tables,
A.1
,
A.1.2
,
A.1.2.1
pga_modes,
A.1.2.10
pga_usage,
A.1.2.9
in writing PGAU statements,
3.2.6
keyword form in storage,
2.5.3
maintenance,
2.3
overview,
A
preparing client application
on gateway using SNA,
4.2
on gateway using TCP/IP,
7.2
purpose of REPORT command,
2.6.15
relationship to PGAU,
2.1
remote transaction definitions,
2.4
ROLLBACK command,
2.2.1
select scripts,
8.3
storage of information needed for PGAU GENERATE to perform,
4.6.1
,
7.3.1
transaction attributes,
4.7.2.2
,
7.4.2.2
USAGE (SKIP),
D.2.3
version definition tables,
2.5.2
pg4tcpmap tool,
1.13.2
,
3.2.5
,
7
calling, to map DEFINE TRANSACITON parameters,
7.6
commands to operate PGA_TCP_IMSC table,
6.5
definition,
1.3
description and function in the gateway,
1.2
function,
1.2
in mapping input parameters,
1.13.1
,
6.1
function in remote transaction initiation,
1.8.1.1
preparation for populating PGA_TCP_IMSC table,
6.1
setting parameters in initsid.ora,
6.4
to map SideProfile name,
2.6.4
PGA
administrator,
2.1
definition,
1.3
pga_call table,
A.2.3.5
pga_call_parm table,
A.2.3.6
PGA_CC_PENDING table
commit-confirm transaction log,
5.6.2
pga_compilers table,
A.1.2.5
pga_data table,
A.2.3.7
pga_data_attr,
A.2.3.9
pga_data_values table,
A.2.3.10
pga_datatype_attr table,
A.1.2.7
pga_datatype_values table,
A.1.2.8
pga_datatypes table,
A.1.2.6
pga_env_attr table,
A.1.2.3
pga_env_values table,
A.1.2.4
,
A.1.2.4
pga_environments table,
A.1.2.2
pga_fields table,
A.2.3.8
pga_maint table,
A.1.2.1
pga_modes constant,
A.1.2.10
PGA_TCP_IMSC table,
1.13.2
,
3.2.5
,
6.1
,
6.2
,
7
,
7.1
,
7.3.3
content and parameters,
6.3
querying,
6.5.3
TCP/IP parameter table,
1.13.1
PGA_TCP_PASS,
6.2
PGA_TCP_USER,
6.2
pga_trans table,
A.2.3.1
pga_trans_attr table,
A.2.3.2
pga_trans_calls table,
A.2.3.4
pga_trans_values table,
A.2.3.3
pga_usage,
A.1.2.9
pga_usage constant,
A.1.2.9
pgacics.sql,
1.10
pgadb2i file,
F
pgadb2id.sql file,
4.3.1
,
4.8.2
pgadb2i.pkb,
1.4
pgadb2i.pkb file,
1.4
,
1.11.1
,
4.1
,
4.3.1
pgadb2i.pkh file,
1.4
,
1.4
,
1.11.1
,
1.11.1
pgadb2i.sql file,
4.3.1
,
F
pgaims file,
F
pgaims.sql,
1.13
PGAINIT,
1.8.1.1
,
B.1.1
role in mapping SNA parameters to TCP/IP,
1.13.1
,
6.1
PGAINIT function,
1.3
,
1.8.1.1
,
1.8.1.1
PGATCTL,
B.1.4
PGATERM,
B.1.3
PGATERM function,
1.3
,
1.8.1.1
PGATRAC,
B.1.5
PGAU,
4.1
accesses definitions in PG DD,
1.3
commands- also called "statements",
2.6
COMMIT processing,
2.2.1
defining and testing a TIP,
2.5
definition,
2
used to generate TIP specifications,
1.3
definition names,
2.5.1
definition versioning,
2.5.2
definitions,
2.4
functions,
2.1
-generated TIP specifications,
1.7
generation,
2.4
interpretation of COBOL symbols in datatype conversion,
D.2.1
invoking,
2.3
,
2.3
keywords,
2.5.3
,
2.5.3
NLS Language usage,
E.2
overview,
2.1
purpose of PGDL,
1.3
role in calling TIPs, on gateway using TCP/IP,
7.1
ROLLBACK processing,
2.2.2
sample input,
G
writing statements,
3.2.6
PGAU commands,
1.11.1
,
1.14.1
CONNECT,
2.3
,
2.6.1
CONNECT, parameters,
2.6.1
DEFINE CALL,
2.6.2
,
2.6.2
,
2.6.15
,
3.2.6
,
4.10.4
call list,
3.2.2
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
sample,
G.2
DEFINE DATA,
2.6.3
,
2.6.15
,
3.2.6
,
4.6.1
,
4.10.4
,
7.3.1
,
A.2.3.7
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
parameters,
2.6.3
sample,
G.1
DEFINE DATA, datatype conversions
USAGE (ASIS),
D.2.2
USAGE (PASS),
D.2.1
USAGE (SKIP),
D.2.3
DEFINE PGAU, call list,
3.2.3
DEFINE TRANSACTION,
1.11.1
,
2.1
,
2.6.4
,
2.6.4
,
3.2.6
,
4.10.4
on gateway using TCP/IP,
1.14.1
sample,
G.3
DEFINE TRANSACTION, parameters,
2.6.4
,
3.2.4
,
3.2.4
defining correlation between TIP and RTP,
2.1
DESCRIBE,
2.6.5
DESCRIBE, parameters,
2.6.5
DISCONNECT,
2.6.6
DISCONNECT, parameters,
2.6.6
EXECUTE,
2.6.7
EXECUTE, parameters,
2.6.7
EXIT,
2.6.8
EXIT, parameters,
2.6.8
formatting of Call and Transaction reports,
2.6.15
four main types, in control file,
1.11.1
,
1.14.1
GENERATE,
2.6.9
,
3.2.6
,
3.3
,
3.5
,
4.6.1
,
7.3.1
,
F.2
error messages,
8.3
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
parameters,
2.6.9
problem analysis,
8.2
sample,
G.4
support and non-support for parameters over 32K length,
D.1.1
traces,
8.1
GROUP,
2.6.10
,
2.6.10
,
3.3
,
3.3
HOST,
2.6.11
parameters,
2.6.11
on gateway using SNA,
1.11.1
PRINT,
2.6.12
,
2.6.12
REDEFINE DATA,
2.6.13
,
2.6.13
,
A.2.3.7
sample,
G.6
REM,
2.6.14
REM, parameters,
2.6.14
REPORT,
2.6.15
output sample,
G.8
REPORT, parameters,
2.6.15
SET,
2.6.16
SET, parameters,
2.6.16
SHOW,
2.6.17
SHOW, parameters,
2.6.17
SPOOL,
2.6.18
SPOOL, parameters,
2.6.18
TRANSACTION,
2.6.15
UNDEFINE CALL,
2.6.19
UNDEFINE CALL, parameters,
2.6.19
UNDEFINE DATA,
2.6.20
UNDEFINE DATA, parameters,
2.6.20
UNDEFINE TRANSACTION,
2.6.21
UNDEFINE TRANSACTION, parameters,
2.6.21
UNDEFINE, sample,
G.7
VARIABLE,
2.6.22
VARIABLE, parameters,
2.6.22
PGAU script file
adding spool and echo,
3.3
creating,
3.2.7
pgau.trc file,
2.6.9
,
2.6.9
PGAXFER,
7.3.2.2
,
B.1.2
PGAXFER function,
1.3
,
1.8.1.1
,
1.8.1.2
,
4.3.1
,
7.2.1
PGDD (Data Dictionary)
environment sequence numbers,
A.1.1
pgddausr.sql file,
4.13
,
7.9
pgddcr8.sql file,
2.5.2
,
A.2
PGDL (Procedural Gateway Definition Language),
2.1
,
B
definition,
1.3
pgtflip,
7.5.3
pgtflipd,
1.14.1
pgtflipd.sql,
7.4.1
pgtflipd.sql file,
7.2.1
,
7.5.2
,
F
pgtflip.pkb,
1.4
,
1.4
pgtflip.pkb file,
1.14.1
,
7.1
,
7.2.1
pgtflip.pkh,
1.4
pgtflip.pkh file,
1.14.1
pgtflip.sql file,
7.2.1
PIC 9,
8.4
,
D.2.1
PIC G,
8.4
datatypes,
4.11
,
7.8
PIC G datatype conversions,
D.2.1
PIC G datatypes,
D.2.1
PIC X,
D.2.1
PIC X datatypes,
8.4
,
D.2.1
PKGEX(DC) diagnostic option,
8.6
PKGEX(DR)
GENERATE diagnostic option,
8.2
PL/SQL,
1.3
,
C.1
call,
A.2.3.4
,
A.2.3.5
code,
B.1
code generator,
1.2
,
8.4
data length limits,
8.5
datatypes,
1.7
,
4.5
,
4.5
,
4.5
,
4.6.1
,
G.4
,
G.5
converted to RAW,
1.8.1.2
developing TIPs,
D
enabling a trace,
8.9.2.2
function in the gateway,
1.1
,
1.7
invoking PG4APPC,
1.10
,
1.13
naming algorithms,
D.2.4
delimiters,
D.2.4
duplicate names,
D.2.4
qualified compound names,
D.2.4
parameters,
4.7.1
,
7.4.1
record format,
G.5
stored procedure,
1.10.1
transferring data
using RAW datatype,
C
UTL_PG package function,
1.3
UTL_RAW function,
1.3
variable names,
D.2.4
datatype conversion,
D.2.4
variables,
3.5
,
D.2.1
,
D.2.1
,
D.2.1
,
D.2.4
PL/SQL package,
2.3
,
2.6.2
,
2.6.19
,
2.6.21
,
3.1
,
4.3.1
,
8.2
,
B
,
F.2
,
F.2
components,
4.3.1
,
4.3.1
,
7.2.1
,
7.2.1
contents
package specification,
4.3.1
,
7.2.1
DBMS_PIPE,
3.1
definition,
1.3
,
1.3
execute authority,
4.8.3
,
7.5.3
function,
4.1
,
7.1
functions,
1.7
grants required,
3.1
pagcics,
1.10.1
parameter,
2.6.9
See TIP
specifying names,
4.6.3
,
7.3.3
PL/SQL stored procedure,
5.5.2
changing trace level,
B.1.4
starting up communication with mainframe,
1.10.1
,
1.13.2
PL/SQL stored procedure specification
also called "TIP"
See PL/SQL package
PRINT command,
2.6.12
privileges
needed to use TIPs,
4.13
problem analysis
of data conversion and truncation errors,
8.5
with PG DD diagnostic references,
8.2
with PG DD select scripts,
8.3
with TIP runtime traces,
8.6
Procedural Gateway Administration
see PGA
Procedural Gateway Administration Utility
see PGAU,
1.7
R
RAW,
C.1.8
RAW_TO_NUMBER FORMAT function,
C.2.6
RAW_TO_NUMBER function,
C.2.2
recompilation errors
causes,
F.2.2.1
REDEFINE DATA statement,
A.2.3.7
,
G.6
REDEFINES,
D.2.1
REM command,
2.6.14
remote host transactions (RHT)
APPC conversation sharing,
4.10
attributes needed,
4.6.3
,
7.3.3
client application,
4.5
defined using the PGAU DEFINE TRANSACTION statement,
4.6.3
,
7.3.3
evaluating,
3.2
multi-conversational, client applications,
4.5
one-shot, client applications,
4.5
persistent, client applications,
4.5
requirements
understanding,
4.3
steps involved in,
4.5
types
on gateway using SNA,
1.9.1
,
4.3.2
on gateway using TCP/IP,
7.2.2
remote procedural call
See RPC
remote procedural call (RPC),
A.2.3.5
calling the gateway,
B
executing gateway functions,
B.1
parameters,
B.1.4
PGAINIT and PGAINIT_SEC,
B.1.1
PGAINIT and PGAINIT_SEC, parameters,
B.1.1
PGATCTL,
B.1.4
PGATERM,
B.1.3
PGATERM, parameters,
B.1.3
PGATRAC,
B.1.5
PGATRAC, parameters,
B.1.5
PGAXFER,
B.1.2
PGAXFER, parameters,
B.1.2
remote procedure
definition,
1.3
remote transaction initiation
on gateway using SNA,
1.8.1.1
on gateway using TC/IP,
1.8.1.1
remote transaction program
See RTP
remote transaction termination
on gateway using SNA,
1.8.1.3
on gateway using TCP/IP,
1.8.1.3
RENAMES,
D.2.1
REPORT statement,
3.2.6
REVERSE function,
C.1.13
RHT, See remote host transactions
ROLLBACK command,
2.2.1
,
2.2.2
ROLLBACK processing,
2.2.2
RPC
definition,
1.3
function
PGAINIT,
1.3
,
1.8.1.1
,
1.8.1.1
PGATERM,
1.3
PGAXFER,
1.3
,
1.8.1.2
within the gateway,
1.1
,
1.8
processing,
1
RPC interface
PGATCTL,
B.1.4
PGATERM,
B.1.3
PGATRAC,
B.1.5
PGAXFER,
B.1.2
See also, remote procedural call (RPC)
RTP
activities,
4.3.2.2
definition,
1.3
executing,
1.3
function in the gateway,
1.1
on gateway using SNA,
4.4
purpose,
4.3.1
,
7.2.1
runtime traces,
8.6
controls,
8.7
conversion warnings,
8.7.2
data conversion tracing,
8.7.4
gateway exchange tracing,
8.7.5
runtime function entry/exit tracing,
8.7.3
S
sample
PGAU DEFINE CALL command,
G.2
PGAU DEFINE DATA command,
G.1
PGAU DEFINE TRANSACTION command,
G.3
PGAU GENERATE command,
G.4
PGAU REDEFINE DATA command,
G.6
PGAU REPORT output,
G.8
PGAU UNDEFINE command,
G.7
TIP output,
G.11
TIP trace output,
G.10
sample definitions
implicit versioning,
G.5
script file,
3.2.7
sequence objects
in the PGDD environment dictionary,
A.1.1
server
role in gateway architecture,
1.5
SET command,
2.6.16
SET LOG_DESTINATION parameter,
8.5
,
8.5
,
8.9.1
,
8.9.1
SET TRACE_LEVEL parameter,
8.5
,
8.9.1
,
8.9.2.1
,
8.9.2.2
Side Information Profile,
2.6.4
,
B.1.1
SIDE_NAME,
5.6.2
SIDEPROFILE (name),
2.6.4
simple PG4APPC communication
on gateway using SNA,
1.10
SNA
and gateway components,
1.5
communication between mainframe and Oracle Integrating Server,
1.10
communications function,
1.10
creating a TIP,
1.11
determining validity of TIP specification,
F.2.1.1
examples and sample files used in this guide,
1.4
flexible call sequence,
4.6.2.1
function in the gateway,
1.1
gateway transaction types,
1.9.1
implementing commit-confirm,
5
overview of the gateway, using,
1.1
parameters,
1.8.1.1
PGAU DEFINE TRANSACTION command,
3.2.4
remote transaction initiation,
1.8.1.1
,
1.8.1.1
remote transaction termination on the gateway,
1.8.1.3
steps to connecting Integrating Server and mainframe,
1.10.1
supported remote host languages,
3.2.1
TIP internals,
F
trace output files,
8.10.1
uses APPC to access all systems,
1.1
writing TIPs,
1.11
socket file descriptor
returned by TCP/IP network to PGAINIT,
1.8.1.1
specification file
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
SPOOL command,
2.6.18
SQL*Plus
connecting server and mainframe,
1.10.1
invoking,
3.4
recompiling TIP body changes,
F.2.1
running scripts,
4.13
,
7.9
test scripts,
8.3
starting
the gateway,
1.6
statements
see PGAU commands
SUBSTR function,
C.1.14
supported languages,
E.2
SYNCHRONIZED,
D.2.1
SYNCHRONIZED LEFT,
D.2.1
SYNCHRONIZED RIGHT,
D.2.1
T
TCP/IP for IMS Connect,
1.13
,
7.4.2.1
and gateway components,
1.5
and PGA_TCP_IMSC parameter table,
1.13.1
,
6.2
and PGAINIT,
1.13.1
,
6.1
and Remote Transaction Initiation,
1.8.1.1
Client application overview,
7.1
communication between gateway and OIS,
1.13
content of PGA_TCP_IMSC table,
6.3
creating a TIP,
7
determining validity of TIP specification,
F.2.1.1
elements of TIP-RTP correspondence,
7.3
examples and sample files used in this guide,
1.4
function in the gateway,
1.1
,
1.1
gateway support for, description,
1.2
IMS enabled,
1.3
mapping parameters using pg4tcpmap tool,
7.6
mapping SNA parameters to TCP/IP,
1.13.1
,
6.1
non-persistent socket transaction type,
1.12.1
OLTP in gateway architecture,
1.5
persistent socket transaction type,
1.12.1
PGAU DEFINE TRANSACTION command,
3.2.5
remote host languages supported,
3.2.1
remote transaction initiation,
1.8.1.1
remote transaction termination,
1.8.1.3
SENDs and RECEIVEs
TIP CALL correspondence,
7.3.2
setting initsid.ora parameters,
6.4
simple communication
between gateway and integrating server,
1.13
steps to communication between server and IMS,
1.13.2
steps to writing a TIP,
1.14.1
supports only IMS as OLTP,
1.2
,
1.3
TIP granting privileges needed,
7.9
TIP internals,
F
trace output files,
8.10.2
TRANSACTION correspondence,
7.3.3
transaction types,
1.12.1
terminal-oriented transactions
modifying,
4.12
terminating a TIP conversation,
4.8.1
,
7.5.1
terms, gateway terms defined,
1.3
tg4pwd utility
definition,
1.3
recommended security utility feature,
1.3
TIP,
1.4
,
4.1
,
7.1
also called PL/SQL package
APPC conversation sharing,
4.10.1
,
4.10.3
background references,
F.1
CALL correspondence,
4.6.2
on gateway using SNA,
4.6.2
on gateway using TCP/IP,
7.3.2
,
7.3.2
order restrictions,
4.6.2.2
calling
from the client application,
4.7
,
7.4
calling and controlling
on gateway using SNA,
4.1
on gateway using TCP/IP,
7
,
7.1
client application development
content and purpose on gateway using SNA,
4.3.1
content and purpose on gateway using TCP/IP,
7.2.1
compiling,
3.4
content documentation (tipname.doc),
3.5
,
3.5
content file sections
GENERATION Status,
3.5
TIP Default Calls,
3.5
TIP Transaction,
3.5
TIP User Calls,
3.5
TIP User Declarations,
3.5
TIP User Variables,
3.5
control file,
2.1
controlling
runtime conversion warnings,
8.7.2
runtime data conversion tracing,
8.7.4
runtime function tracing,
8.7.3
runtime gateway exchange tracing,
8.7.5
conversation sharing used to circumvent large TIPs,
4.10.4
conversion,
1.2
,
4.11
,
7.8
converting PL/SQL datatypes to RAW,
1.8.1.2
creating,
3
custom TIP writing,
F
customized interface for each remote host transaction (RTP),
4.4
DATA correspondence,
4.6.1
on gateway using TCP/IP,
7.3.1
datatype conversion support for COBOL,
D.2
declaring variables to create a TIP,
4.7.1
,
7.4.1
defining and generating,
3.3
defining, with PGAU,
2.5
definition,
1.3
,
1.3
definition errors,
8.1
dependent TIP body or specification changes,
F.2.2
diagnostic parameters,
4.10.6
driver procedures
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
flexible call sequence,
4.6.2.1
four steps to generate
on gateway using SNA,
1.11
on gateway using TCP/IP,
1.14
functions,
1.7
in Oracle integrating server,
1.8.1.2
generated by PGAU,
4.1
granting privileges to use,
3.1
,
4.13
,
7.9
independent TIP body changes,
F.2.1
initializations,
4.7.2.2
,
7.4.2.2
overriding,
4.7.2.2
,
7.4.2.2
initializing the conversation,
4.7.2
,
7.4.2
internals,
F
output, sample,
G.11
override parameters,
4.10.6
overriding default attributes,
4.7.2.2
,
7.4.2.2
overview,
1.11
,
1.14
privileges needed,
3.1
,
4.13
public functions
tip_init,
4.3.2.2
tip_inqr,
4.3.2.2
tip_mode,
4.3.2.2
tip_term,
4.3.2.2
tip_updt,
4.3.2.2
recompiling,
F.2
,
F.2.1
,
F.2.2
remote transaction
correspondence,
4.6
remote transaction correspondence, on gateway using TCP/IP,
7.3
remote transaction initiation (PGAINIT),
1.8.1.1
,
1.8.1.1
requirements for corresponding with RHT
on gateway using SNA,
4.6
on gateway using TCP/IP,
7.3
requirements of the client application,
4.5
service,
4.10.1
specification file,
3.3
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
specifications
generated by PGAU,
1.7
,
1.7
steps to writing
on gateway using SNA,
1.11.1
on gateway using TCP/IP,
1.14.1
terminating the conversation,
4.8.1
,
7.5.1
trace controls,
8.7
trace output sample,
G.10
tracing,
8.5
TRANSACTION correspondence,
4.6.3
,
7.3.3
on gateway using SNA,
4.6.3
using transaction instance parameter
on gateway using TCP/IP,
7.4.2.1
writing
on gateway using SNA,
1.11
on gateway using TCP/IP,
3.2.5
TIP control file commands,
1.11.1
,
1.11.1
,
1.11.1
,
1.11.1
,
1.11.1
,
1.14.1
,
1.14.1
,
1.14.1
,
1.14.1
on gateway using TCP/IP,
1.14.1
TIP specification,
4.1
,
F.2
,
F.2.1
changes,
F.2.2
errors,
F.2.2.1
TIP warnings and tracing
suppressing,
8.8
tipname.doc file,
3.5
,
4.5
,
4.7.1
,
7.4.1
tipname.pkb file,
8.6
tname.ctl file,
3.2.7
,
3.2.7
TP_NAME,
5.6.2
trace option,
8
TIP definition errors,
8.1
trace output files
for gateway using SNA,
8.10.1
for gateway using TCP/IP,
8.10.2
TRACE_LEVEL,
8.9.1
traces,
8.7.2
,
8.7.3
,
8.7.4
,
8.7.5
diagnostic,
8.5
enable gateway server trace,
8.9.2
enabling APPC trace from PL/SQL,
8.9.2.2
enabling through initsid.ora,
8.9.2.1
gateway server,
8.9
purpose of initializing conversations,
4.7.2
,
7.4.2
runtime,
8.6
trace controls,
8.7
sample gateway server output,
8.10
suppressing,
8.8
TIP,
8.6
,
8.8
TRANSACTION correspondence
on gateway using SNA,
4.6.3
on gateway using TCP/IP,
7.3.3
transaction instance parameter
on gateway using SNA,
4.7.2.1
on gateway using TCP/IP,
7.4.2.1
Transaction Interface Package
See TIP
transaction socket
transaction type for TCP/IP,
1.12.1
TRANSACTION tname,
2.6.4
transaction types
one-shot, persistent and multi-conversational, for SNA,
1.9.1
TRANSLATE function,
C.1.15
TRANSLITERATE function,
C.1.16
transparency
(application),
1.2
(location), on gateway using SNA,
1.2
U
UNDEFINE statement,
3.2.7
,
G.7
USAGE(ASIS),
D.2.2
USAGE(PASS),
D.2.1
datatype conversion,
D.2.1
FILLER,
D.2.1
PIC 9,
D.2.1
PIC G,
D.2.1
format conversion
OCCURS DEPENDING ON,
D.2.1
OCCURS n TIMES,
D.2.1
USAGE(SKIP),
D.2.3
utility
tg4pwd,
1.3
UTL_PG
input parameters
wmsgbsiz,
C.2.1.1
output parameters
wmsgblk,
C.2.1.2
package
definition,
1.3
parameters (input and output),
C.2.1
PL/SQL package,
3.1
UTL_PG function,
C.2
MAKE_NUMBER_TO_RAW_FORMAT,
C.2.5
MAKE_RAW_TO_NUMBER_FORMAT,
C.2.4
NUMBER_TO_RAW,
C.2.3
NUMBER_TO_RAW and RAW_TO_NUMBER argument values,
C.3
NUMBER_TO_RAW_FORMAT,
C.2.7
RAW_TO_NUMBER,
C.2.2
RAW_TO_NUMBER_FORMAT,
C.2.6
WMSG,
C.2.9
WMSGCNT,
C.2.8
UTL_PG input parameters
compname,
C.2.1.1
compopts,
C.2.1.1
envrnmnt,
C.2.1.1
mask,
C.2.1.1
maskopts,
C.2.1.1
nlslang,
C.2.1.1
wind,
C.2.1.1
UTL_RAW function
BIT_AND,
C.1.1
BIT_COMPLEMENT,
C.1.2
BIT_OR,
C.1.3
BIT_XOR,
C.1.4
CAST_TO_RAW,
C.1.5
CAST_TO_VARCHAR2,
C.1.6
COMPARE,
C.1.7
CONCAT,
C.1.8
CONVERT,
C.1.9
COPIES,
C.1.10
LENGTH,
C.1.11
OVERLAY,
C.1.12
REVERSE,
C.1.13
SUBSTR,
C.1.14
TRANSLATE,
C.1.15
TRANSLITERATE,
C.1.16
XRANGE,
C.1.17
UTL_RAW PL/SQL package,
3.1
,
C
definition,
1.3
functions,
C.1
V
VARIABLE command,
2.6.22
W
WMSG function,
C.2.9
WMSGCNT function,
C.2.8
writing PGAU statements,
3.2.6
X
XRANGE function,
C.1.17
Scripting on this page enhances content navigation, but does not change the content in any way.