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

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

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