Index

A C D E F G H I J K L M N O P R S T U V W

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

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

CICS, 1.8.1

CICS Transaction Server

gateway starts communication with, 1.8.2.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

logging server, 5.3

OLTP commit-confirm transaction log, 5.3

OLTP forget/recovery transaction, 5.3

OLTP transaction logging code, 5.3

supported OLTPs, 5.2

transaction log, 5.6.2

communication

between mainframe and Oracle database

on gateway using SNA, 1.8.2

between server, gateway and remote host, 1.6

compiling a TIP, 3.4

CONNECT command, 2.3, 2.6.1

control file

creating

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.1

conversation sharing, see APPC conversation sharing

creating a TIP

(detailed), 3

overview, 1.8.3, 1.9.3

D

data conversion

errors, 8.4

DATA correspondence, 4.6.1, 7.3.1

data dictionary, see PG DD

data exchange

PGAXFER function, 1.7.1.2

data format conversion, D

database link, 1.6

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

debugging tool

PGATRAC function, B.1.5

DEFINE CALL, 2.1

DEFINE CALL parameters, 2.6.2

DEFINE CALL statement ("command"), 1.8.3.1, 1.9.3.1, 3.2.6, 4.10.4, F.2

DEFINE DATA, 2.1

DEFINE DATA statement ("command"), 1.8.3.1, 1.9.3.1, 2.6.15, 3.2.6, 4.6.1, 4.10.4, 7.3.1, A.2.3.7, F.1

DEFINE TRANSACTION parameters, 2.6.4

DEFINE TRANSACTION statement ("command"), 3.2.6, 4.10.4, F.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

dg4pwd utility

definition, 1.3

recommended security utility feature, 1.3

DISCONNECT command, 2.6.6

double byte character sets (DBCS)

in application development, 4.11, 7.8

driver procedure

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.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.1.3

PLS -00123

program too large, 4.10.4

truncation, 8.8

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.1, 8.9.2, 8.9.2.1

pagaims, E

pgadb2i, E

pgadb2id.sql, 4.8.2

pgadb2i.pkb, 1.4, 1.8.3.1, 4.1, 4.3.1

pgadb2i.pkh, 1.4, 1.8.3.1, 1.8.3.1, 4.3.1

pgadb2i.sql, E

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

pgtflip.pkb, 1.9.3.1, 7.1, 7.2.1

pgtflip.pkh, 1.9.3.1, 7.2.1

tipname.doc, 3.5, 4.5, 4.7.1, 7.4.1

tipname.pkb, 8.5

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

transaction in CICS, 1.8.2

transaction in IMS, 1.9.2

format conversion, D.2.1

function

PGATERM, B.1.3

PGAXFER, 4.3.1, 7.2.1, B.1.2

UTL_PG, C.1

functions

see RPC (remote procedural call)

See UTL_PG

see UTL_PG

see UTL_RAW

G

gateway

access to IBM datastores, 1.1

communication, 1.1

overview, 1.6

with CICS in mainframe on gateway using SNA, 1.8.2.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 database integration, 1.2

performs automatic conversions, 1.2

site autonomy and security, 1.2

support for tools, 1.2

initialization files, 1.3

overview, 1.1

using TCP/IP, 1.1

remote procedure, definition, 1.3

remote transaction initiation

using SNA, 1.7.1.1

using TCP/IP, 1.7.1.1

remote transaction termination

using SNA, 1.7.1.3

using TCP/IP, 1.7.1.3

tracing, 8.9

transaction types

on gateway using SNA, 1.8.1

on gateway using TCP/IP, 1.9.1

gateway sample files

using SNA

pgadb2i.pkb, 1.4

pgadb2i.pkh, 1.4

using TCP/IP

pgadb2i.pkb, 1.4

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

GENERATE, 2.1

GENERATE statement ("command"), 1.8.3.1, 1.9.3.1, 3.2.6, 3.3, 4.6.1, 7.3.1, E.2, F.4

GLOBAL_TRAN_ID, 5.6.2

Globalization Support

multi-byte character set support, 4.11, 7.8

granting privileges for creating TIPs, 3.1

GROUP statement (PGAU), 3.3

H

HOST command, 2.6.11

I

implicit APPC, 4.12

implicit versioning

sample definitions, F.5

IMS, 1.1

communication with Integrating Server

using TCP/IP, 1.9.2.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.7.1.1, 1.7.1.1

initsid.ora file, 1.3, 8.9.1, 8.9.1, 8.9.1, 8.9.2, 8.9.2.1

parameters to run pg4tcpmap tool, 6.4

I/O PCB, 1.9.2, 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

LENGTH IS field-2, D.2.1

logging server, 5.3, 5.5.2

description, 5.5.1

interaction with gateway database, 5.5.2

LU_NAME, 5.6.2

M

MAKE_NUMBER_TO_RAW_FORMAT function, C.1.5

MAKE_RAW_TO_NUMBER_FORMAT function, C.1.4

mapping parameters

from SNA to TCP/IP, 6.1

mapping table

PGA_TCP_IMSC, 1.9.2.2

MBCS, See multi-byte character sets

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

multi-conversational transactions, 4.3.2.3, 4.5

N

non-persistent socket transaction type for TCP/IP for IMS Connect, 1.9.1

NUMBER_TO_RAW and RAW_TO_NUMBER argument values, C.2, C.2, C.2

NUMBER_TO_RAW function, C.1.3

errors, C.1.3

NUMBER_TO_RAW_FORMAT function, C.1.7

O

OCCURS DEPENDING ON, D.2.1

OCCURS n TIMES, D.2.1

OLTP

and TCP/IP, 1.3, 1.5

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

remote, 1

security considerations, 4.7.2.3, 7.4.2.3

transaction logging code, 5.3

one-shot transaction types, 1.8.1, 4.3.2.1, 4.5, 5.4

online transaction processor

See OLTP

operating system

role in gateway installation, 1.5

Oracle database, 1.7.1.2

component of the gateway, 1.5

definition, 1.3

function in gateway communication

on gateway using TCP/IP, 1.9.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.6

simple communication

on gateway using SNA, 1.8.2

on gateway using TCP/IP, 1.9.2

steps to communication

between server and mainframe, 1.8.2.1

stores PL/SQL, 1.3

Oracle Database Gateway for APPC

also see gateway

compatibility with version 3.4.0, 4.10.3

development environment, 1.2

P

package

UTL_PG, 3.1, 3.1

parameters

mapped to TPC/IP, 6.3

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

persistent transaction type, for gateway using SNA, 1.8.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.9.2.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, 6.1

function in remote transaction initiation, 1.7.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.9.2.2, 3.2.5, 6.1, 6.2, 7, 7.1, 7.3.3

content and parameters, 6.3

querying, 6.5.3

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

PGAADMIN, 3.1

pgacics.sql, 1.8.2

pgadb2i file, E

pgadb2id.sql file, 4.3.1, 4.8.2

pgadb2i.pkb, 1.4

pgadb2i.pkb file, 1.4, 1.8.3.1, 4.1, 4.3.1

pgadb2i.pkh file, 1.4, 1.4, 1.8.3.1, 1.8.3.1

pgadb2i.sql file, 4.3.1, E

pgaims file, E

pgaims.sql, 1.9.2

PGAINIT, 1.7.1.1, B.1.1

role in mapping SNA parameters to TCP/IP, 6.1

PGAINIT function, 1.3, 1.7.1.1, 1.7.1.1

PGATCTL, B.1.4

PGATERM, B.1.3

PGATERM function, 1.3, 1.7.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.6

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

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

writing statements, 3.2.6

PGAU commands, 1.8.3.1, 1.9.3.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.8.3.1

on gateway using TCP/IP, 1.9.3.1

sample, F.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.8.3.1

on gateway using TCP/IP, 1.9.3.1

parameters, 2.6.3

sample, F.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.8.3.1, 2.1, 2.6.4, 2.6.4, 3.2.6, 4.10.4

on gateway using TCP/IP, 1.9.3.1

sample, F.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.8.3.1, 1.9.3.1

GENERATE, 2.6.9, 3.2.6, 3.3, 3.5, 4.6.1, 7.3.1, E.2

error messages, 8.3

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.1

parameters, 2.6.9

problem analysis, 8.2

sample, F.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.8.3.1

PRINT, 2.6.12, 2.6.12

REDEFINE DATA, 2.6.13, 2.6.13, A.2.3.7

sample, F.6

REM, 2.6.14

REM, parameters, 2.6.14

REPORT, 2.6.15

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, F.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.7.1.1, 1.7.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.9.3.1

pgtflipd.sql, 7.4.1

pgtflipd.sql file, 7.2.1, 7.5.2, E

pgtflip.pkb, 1.4, 1.4

pgtflip.pkb file, 1.9.3.1, 7.1, 7.2.1

pgtflip.pkh, 1.4

pgtflip.pkh file, 1.9.3.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.5

PKGEX(DR)

GENERATE diagnostic option, 8.2

PL/SQL, 1.3

call, A.2.3.4, A.2.3.5

code, B.1

code generator, 1.2, 8.4

data length limits, 8.8

datatypes, 1.6, 4.5, 4.5, 4.5, 4.6.1, F.4, F.5

converted to RAW, 1.7.1.2

developing TIPs, D

enabling a trace, 8.9.2.2

function in the gateway, 1.1, 1.6

invoking DG4APPC, 1.8.2, 1.9.2

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, F.5

stored procedure, 1.8.2.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, 3.1, 4.3.1, 8.2, B, E.2, E.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, 3.1

definition, 1.3, 1.3

execute authority, 4.8.3, 7.5.3

function, 4.1, 7.1

functions, 1.6

grants required, 3.1

pagcics, 1.8.2.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.8.2.1, 1.9.2.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.8

with PG DD diagnostic references, 8.2

with PG DD select scripts, 8.3

with TIP runtime traces, 8.5

Procedural Gateway Administration

see PGA

Procedural Gateway Administration Utility

see PGAU, 1.6

R

RAW_TO_NUMBER FORMAT function, C.1.6

RAW_TO_NUMBER function, C.1.2

recompilation errors

causes, E.2.2.1

REDEFINE DATA statement, A.2.3.7, F.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.8.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.7.1.1

on gateway using TC/IP, 1.7.1.1

remote transaction program

See RTP

remote transaction termination

on gateway using SNA, 1.7.1.3

on gateway using TCP/IP, 1.7.1.3

RENAMES, D.2.1

REPORT statement, 3.2.6

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.7.1.1, 1.7.1.1

PGATERM, 1.3

PGAXFER, 1.3, 1.7.1.2

within the gateway, 1.1, 1.7

processing, 1

RPC interface

PGATCTL, B.1.4

PGATERM, B.1.3

PGATRAC, B.1.5

PGAXFER, B.1.2

S

sample

PGAU DEFINE CALL command, F.2

PGAU DEFINE DATA command, F.1

PGAU DEFINE TRANSACTION command, F.3

PGAU GENERATE command, F.4

PGAU REDEFINE DATA command, F.6

PGAU UNDEFINE command, F.7

sample definitions

implicit versioning, F.5

script file, 3.2.7

sequence objects

in the PGDD environment dictionary, A.1.1

SET command, 2.6.16

SET LOG_DESTINATION parameter, 8.8, 8.8, 8.8, 8.9.1, 8.9.1, 8.9.1

SET TRACE_LEVEL parameter, 8.8, 8.8, 8.9.1, 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 DG4APPC communication

on gateway using SNA, 1.8.2

SNA

and gateway components, 1.5

communication between mainframe and Oracle database, 1.8.2

communications function, 1.8.2

creating a TIP, 1.8.3

determining validity of TIP specification, E.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.8.1

implementing commit-confirm, 5

overview of the gateway, using, 1.1

parameters, 1.7.1.1

PGAU DEFINE TRANSACTION command, 3.2.4

remote transaction initiation, 1.7.1.1, 1.7.1.1

remote transaction termination on the gateway, 1.7.1.3

steps to connecting Oracle database and mainframe, 1.8.2.1

supported remote host languages, 3.2.1

TIP internals, E

uses APPC to access all systems, 1.1

writing TIPs, 1.8.3

socket file descriptor

returned by TCP/IP network to PGAINIT, 1.7.1.1

specification file

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.1

SPOOL command, 2.6.18

SQL*Plus

connecting server and mainframe, 1.8.2.1

invoking, 3.4

recompiling TIP body changes, E.2.1

running scripts, 4.13, 7.9

test scripts, 8.3

statements

see PGAU commands

SYNCHRONIZED, D.2.1

SYNCHRONIZED LEFT, D.2.1

SYNCHRONIZED RIGHT, D.2.1

T

TCP/IP for IMS Connect, 1.9.2, 7.4.2.1

and gateway components, 1.5

and PGA_TCP_IMSC parameter table, 6.2

and PGAINIT, 6.1

and Remote Transaction Initiation, 1.7.1.1

Client application overview, 7.1

communication between gateway and Oracle database, 1.9.2

content of PGA_TCP_IMSC table, 6.3

creating a TIP, 7

determining validity of TIP specification, E.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, 6.1

non-persistent socket transaction type, 1.9.1

OLTP in gateway architecture, 1.5

persistent socket transaction type, 1.9.1

PGAU DEFINE TRANSACTION command, 3.2.5

remote host languages supported, 3.2.1

remote transaction initiation, 1.7.1.1

remote transaction termination, 1.7.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.9.2

steps to communication between server and IMS, 1.9.2.2

steps to writing a TIP, 1.9.3.1

supports only IMS as OLTP, 1.2, 1.3

TIP granting privileges needed, 7.9

TIP internals, E

TRANSACTION correspondence, 7.3.3

transaction types, 1.9.1

terminal-oriented transactions

modifying, 4.12

terminating a TIP conversation, 4.8.1, 7.5.1

terms, gateway terms defined, 1.3

TIP, 1.4, 4.1, 7.1

APPC conversation sharing, 4.10.1, 4.10.3

background references, E.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.6.2

runtime data conversion tracing, 8.6.4

runtime function tracing, 8.6.3

runtime gateway exchange tracing, 8.6.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.7.1.2

creating, 3

custom TIP writing, E

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, E.2.2

diagnostic parameters, 4.10.6

driver procedures

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.1

flexible call sequence, 4.6.2.1

four steps to generate

on gateway using SNA, 1.8.3

on gateway using TCP/IP, 1.9.3

functions

in Oracle database, 1.7.1.2

generated by PGAU, 4.1

granting privileges to use, 3.1, 4.13, 7.9

independent TIP body changes, E.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, E

override parameters, 4.10.6

overriding default attributes, 4.7.2.2, 7.4.2.2

overview, 1.8.3, 1.9.3

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, E.2, E.2.1, E.2.2

remote transaction

correspondence, 4.6

remote transaction correspondence, on gateway using TCP/IP, 7.3

remote transaction initiation (PGAINIT), 1.7.1.1, 1.7.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.8.3.1

on gateway using TCP/IP, 1.9.3.1

specifications

generated by PGAU, 1.6, 1.6

steps to writing

on gateway using SNA, 1.8.3.1

on gateway using TCP/IP, 1.9.3.1

terminating the conversation, 4.8.1, 7.5.1

trace controls, 8.6

tracing, 8.8

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

on gateway using TCP/IP, 3.2.5

TIP control file commands, 1.8.3.1, 1.8.3.1, 1.8.3.1, 1.8.3.1, 1.8.3.1, 1.9.3.1, 1.9.3.1, 1.9.3.1, 1.9.3.1

on gateway using TCP/IP, 1.9.3.1

TIP specification, 4.1, E.2, E.2.1

changes, E.2.2

errors, E.2.2.1

TIP warnings and tracing

suppressing, 8.7

tipname.doc file, 3.5, 4.5, 4.7.1, 7.4.1

tipname.pkb file, 8.5

tname.ctl file, 3.2.7, 3.2.7

TP_NAME, 5.6.2

trace option, 8

TIP definition errors, 8.1

TRACE_LEVEL, 8.9.1, 8.9.1

traces, 8.6.2, 8.6.3, 8.6.4, 8.6.5

diagnostic, 8.8

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

trace controls, 8.6

suppressing, 8.7

TIP, 8.5, 8.7

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

TRANSACTION tname, 2.6.4

transaction types

one-shot, persistent and multi-conversational, for SNA, 1.8.1

transparency

(application), 1.2

(location), on gateway using SNA, 1.2

U

UNDEFINE statement, 3.2.7, F.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

dg4pwd, 1.3

UTL_PG

input parameters

wmsgbsiz, C.1.1.1

output parameters

wmsgblk, C.1.1.2

package

definition, 1.3

parameters (input and output), C.1.1

PL/SQL package, 3.1, 3.1

UTL_PG function, C.1

MAKE_NUMBER_TO_RAW_FORMAT, C.1.5

MAKE_RAW_TO_NUMBER_FORMAT, C.1.4

NUMBER_TO_RAW, C.1.3

NUMBER_TO_RAW and RAW_TO_NUMBER argument values, C.2

NUMBER_TO_RAW_FORMAT, C.1.7

RAW_TO_NUMBER, C.1.2

RAW_TO_NUMBER_FORMAT, C.1.6

WMSG, C.1.9

WMSGCNT, C.1.8

UTL_PG input parameters

compname, C.1.1.1

compopts, C.1.1.1

envrnmnt, C.1.1.1

mask, C.1.1.1

maskopts, C.1.1.1

nlslang, C.1.1.1

wind, C.1.1.1

UTL_RAW PL/SQL package, 3.1, 3.1, C

definition, 1.3

V

VARIABLE command, 2.6.22

W

WMSG function, C.1.9

WMSGCNT function, C.1.8

writing PGAU statements, 3.2.6