Index
C
- CALL correspondence
- call correspondence order restrictions
- CICS 1
- CICS Transaction Server
- gateway starts communication with 1
- client application development
- calling a TIP
- customized TIPs for remote host transaction 1
- declaring TIP variables 1, 2
- error handling
- examples and samples 1
- exchanging data 1
- on gateway using TCP/IP 1
- executing 1, 2
- granting execute authority 1, 2
- on gateway using TCP/IP 1
- overriding TIP initializations 1
- on gateway using TCP/IP 1
- overview 1
- preparation 1
- remote host transaction types
- requirements 1
- declare RHT/TIP data to be exchanged 1
- exchange data with RHT using TIP user function 1
- initialize RHT for multi-conversational applications 1
- initialize RHT using TIP initialization function 1
- repetitively exchange data with RHT using TIP user function 1
- terminate RHT using TIP termination function 1
- security considerations 1, 2
- terminating the conversation 1, 2
- TIP and remote transaction program correspondence 1, 2
- TIP CALL correspondence 1
- TIP content and purpose 1
- TIP DATA correspondence 1, 2
- TIP TRANSACTION correspondence
- client application development for gateway using TCP/IP
- overview 1
- client application development on gateway using TCP/IP
- preparing 1
- COBOL 1, 2, 3, 4
- COMMIT command 1, 2
- user responsibility 1
- commit-confirm 1
- COMMIT processing 1
- communication
- compiling a TIP 1
- CONNECT command 1, 2
- control file
- conversation sharing, see APPC conversation sharing 1
- creating a TIP
D
- database link 1
- data conversion
- errors 1
- DATA correspondence 1, 2
- data dictionary, see PG DD 1
- data exchange
- PGAXFER function 1
- data format conversion 1
- datastores
- gateway access to 1
- datatype
- RAW 1
- datatype conversion 1
- COBOL editing symbols 1
- convert length 1
- duplicate names 1
- expected length 1
- format conversion 1
- parameters over 32K in length 1
- PL/SQL 1
- naming algorithms 1
- receive length 1
- removing support for parameters over 32K in length 1
- See USAGE (PASS), USAGE (ASIS). USAGE (SKIP), and PL/SQL Naming Algorithms 1
- send length 1
- truncated and non-unique names 1
- datatype conversions
- COBOL symbols interpreted by PGAU 1
- DBCS
- DBMS_PIPE PL/SQL package 1
- debugging tool
- PGATRAC function 1
- DEFINE CALL 1
- DEFINE CALL parameters 1
- DEFINE CALL statement ("command") 1, 2, 3, 4, 5
- DEFINE DATA 1
- DEFINE DATA statement ("command") 1, 2, 3, 4, 5, 6, 7, 8, 9
- DEFINE TRANSACTION parameters 1
- DEFINE TRANSACTION statement ("command") 1, 2, 3
- defining and generating a TIP 1
- definition versioning 1
- deleting and inserting rows into PGA_TCP_IMSC table 1
- DESCRIBE command 1
- dg4pwd utility
- definition 1
- DISCONNECT command 1
- double byte character sets (DBCS)
- driver procedure
E
G
- gateway
- gateway sample files
- gateway server 1
- gateway server trace 1, 2
- GENERATE 1
- GENERATE statement ("command") 1, 2, 3, 4, 5, 6, 7, 8
- GLOBAL_TRAN_ID 1
- Globalization Support
- granting privileges for creating TIPs 1
- GROUP statement (PGAU) 1
I
- I/O PCB 1, 2, 3
- implicit APPC 1
- implicit versioning
- sample definitions 1
- IMS 1
- communication with Integrating Server
- using TCP/IP 1
- communication with Integrating Server
- IMS/TM
- communication through the gateway 1
- IMS inquiry
- location of sample file 1
- initialization files
- see gateway initialization files, also see PGA parameters 1
- initiating remote transactions 1
- initsid.ora file 1, 2, 5, 6
- parameters to run pg4tcpmap tool 1
M
- MAKE_NUMBER_TO_RAW_FORMAT function 1
- MAKE_RAW_TO_NUMBER_FORMAT function 1
- mapping parameters
- from SNA to TCP/IP 1
- mapping table
- PGA_TCP_IMSC 1
- MBCS, See multi-byte character sets 1, 2
- MODE_NAME 1
- multi-byte character sets (MBCS) 1, 2
- multi-conversational transactions 1, 2
- multi-conversational transaction type
- for gateway using SNA 1
O
- OCCURS DEPENDING ON 1
- OLTP
- and TCP/IP 1, 2
- commit-confirm transaction log 1
- definition 1
- forget/recovery transaction 1
- functional requirements of the gateway 1
- in commit-confirm 1
- in gateway architecture featuring SNA 1
- in gateway using TCP/IP 1
- logic flow for successful commit 1
- only IMS supported on gateway using TCP/IP 1, 2
- remote 1
- security considerations 1, 2
- transaction logging code 1
- one-shot transaction types 1, 2, 3, 4
- online transaction processor
- See OLTP 1
- operating system
- role in gateway installation 1
- Oracle database 1
- Oracle Database Gateway for APPC
- Oracle global transaction ID 1, 3, 4, 5
- Oracle integrating server 1
- Oracle Net 1, 2, 3, 4
- restrictions for data conversion 1
- overrides 1, 2
P
- package
- UTL_PG 1
- parameters
- persistent socket transaction type
- for TCP/IP for IMS Connect 1
- persistent transactions 1, 2, 4
- persistent transaction type, for gateway using SNA 1
- pg4tcpmap tool 1, 2, 3
- calling, to map DEFINE TRANSACITON parameters 1
- commands to operate PGA_TCP_IMSC table 1
- definition 1
- description and function in the gateway 1
- function 1
- in mapping input parameters 1
- function in remote transaction initiation 1
- preparation for populating PGA_TCP_IMSC table 1
- setting parameters in initsid.ora 1
- to map SideProfile name 1
- PGA
- pga_call_parm table 1
- pga_call table 1
- PGA_CC_PENDING table
- commit-confirm transaction log 1
- pga_compilers table 1
- pga_data_attr 1
- pga_data_values table 1
- pga_data table 1
- pga_datatype_attr table 1
- pga_datatype_values table 1
- pga_datatypes table 1
- pga_env_attr table 1
- pga_env_values table 1
- pga_environments table 1
- pga_fields table 1
- pga_maint table 1
- pga_modes constant 1
- PGA_TCP_IMSC table 1, 2, 3, 4, 5, 6, 7
- PGA_TCP_PASS 1
- PGA_TCP_USER 1
- pga_trans_attr table 1
- pga_trans_calls table 1
- pga_trans_values table 1
- pga_trans table 1
- pga_usage 1
- pga_usage constant 1
- PGAADMIN 1
- pgadb2i.pkb 1
- pgadb2i.pkb file 1, 2, 3
- pgadb2i.pkh file 1, 3
- pgadb2i.sql file 1, 2
- pgadb2id.sql file 1
- PGAINIT 1, 2
- role in mapping SNA parameters to TCP/IP 1
- PGAINIT function 1, 2
- PGATCTL 1
- PGATERM 1
- PGATERM function 1, 2
- PGATRAC 1
- PGAU 1
- accesses definitions in PG DD 1
- commands- also called "statements" 1
- COMMIT processing 1
- defining and testing a TIP 1
- definition 1
- used to generate TIP specifications 1
- definition names 1
- definitions 1
- definition versioning 1
- functions 1
- -generated TIP specifications 1
- generation 1
- interpretation of COBOL symbols in datatype conversion 1
- invoking 1
- keywords 1
- overview 1
- purpose of PGDL 1
- role in calling TIPs, on gateway using TCP/IP 1
- ROLLBACK processing 1
- sample input 1
- writing statements 1
- pgau.trc file 1
- PGAU commands 1, 2
- CONNECT 1, 2
- CONNECT, parameters 1
- DEFINE CALL 1, 3, 4, 5
- DEFINE DATA 1, 2, 3, 4, 5, 6, 7
- DEFINE DATA, datatype conversions
- DEFINE PGAU, call list 1
- DEFINE TRANSACTION 1, 2, 3, 5, 6
- DEFINE TRANSACTION, parameters 1, 2
- defining correlation between TIP and RTP 1
- DESCRIBE 1
- DESCRIBE, parameters 1
- DISCONNECT 1
- DISCONNECT, parameters 1
- EXECUTE 1
- EXECUTE, parameters 1
- EXIT 1
- EXIT, parameters 1
- formatting of Call and Transaction reports 1
- four main types, in control file 1, 2
- GENERATE 1, 2, 3, 4, 5, 6, 7
- GROUP 1, 3
- HOST 1
- parameters 1
- on gateway using SNA 1
- PRINT 1
- REDEFINE DATA 1, 3
- sample 1
- REM 1
- REM, parameters 1
- REPORT 1
- REPORT, parameters 1
- SET 1
- SET, parameters 1
- SHOW 1
- SHOW, parameters 1
- SPOOL 1
- SPOOL, parameters 1
- TRANSACTION 1
- UNDEFINE, sample 1
- UNDEFINE CALL 1
- UNDEFINE CALL, parameters 1
- UNDEFINE DATA 1
- UNDEFINE DATA, parameters 1
- UNDEFINE TRANSACTION 1
- UNDEFINE TRANSACTION, parameters 1
- VARIABLE 1
- VARIABLE, parameters 1
- PGAU script file
- PGAXFER 1, 2
- PGAXFER function 1, 2, 3, 4, 5
- PGDD (Data Dictionary)
- environment sequence numbers 1
- PG DD (Data Dictionary) 1, 2
- active dictionary 1
- active dictionary tables
- data definitions for parameters over 32K in length 1
- datatype conversion support for COBOL 1
- definition 1
- definition names
- valid characters in 1
- diagnostic
- entries, creating a TIP 1
- environment dictionary tables 1, 2, 3
- in writing PGAU statements 1
- keyword form in storage 1
- maintenance 1
- overview 1
- preparing client application
- purpose of REPORT command 1
- relationship to PGAU 1
- remote transaction definitions 1
- ROLLBACK command 1
- select scripts 1
- storage of information needed for PGAU GENERATE to perform 1, 2
- transaction attributes 1, 2
- USAGE (SKIP) 1
- version definition tables 1
- pgddausr.sql file 1, 2
- pgddcr8.sql file 1, 2
- PGDL (Procedural Gateway Definition Language) 1, 2
- definition 1
- pgtflip.pkb file 1, 2
- pgtflip.pkh file 1
- pgtflip.sql file 1
- pgtflipd.sql 1
- pgtflipd.sql file 1
- PIC 9 1
- PIC G 1
- PIC G datatype conversions 1
- PIC G datatypes 1
- PIC X datatypes 1
- PIC X data types 1
- PKGEX(DC) diagnostic option 1
- PL/SQL 1
- call 1, 2
- code 1
- code generator 1, 2
- data length limits 1
- datatypes 1, 2, 5, 6, 7
- converted to RAW 1
- developing TIPs 1
- enabling a trace 1
- function in the gateway 1, 2
- invoking DG4APPC 1, 2
- naming algorithms 1
- parameters 1, 2
- record format 1
- stored procedure 1
- transferring data
- using RAW datatype 1
- UTL_PG package function 1
- UTL_RAW function 1
- variable names 1
- datatype conversion 1
- variables 1, 2, 5
- PL/SQL package 1, 2, 3, 4, 5, 7, 8, 9, 10
- PL/SQL stored procedure 1
- PL/SQL stored procedure specification
- PRINT command 1
- privileges
- needed to use TIPs 1
- problem analysis
- Procedural Gateway Administration
- see PGA 1
- Procedural Gateway Administration Utility
- see PGAU 1
R
- RAW_TO_NUMBER FORMAT function 1
- RAW_TO_NUMBER function 1
- recompilation errors
- causes 1
- REDEFINE DATA statement 1, 2
- REM command 1
- remote host transactions (RHT)
- APPC conversation sharing 1
- attributes needed 1, 2
- client application 1
- defined using the PGAU DEFINE TRANSACTION statement 1, 2
- evaluating 1
- multi-conversational, client applications 1
- one-shot, client applications 1
- persistent, client applications 1
- requirements
- understanding 1
- steps involved in 1
- types
- remote procedural call
- See RPC 1
- remote procedural call (RPC) 1
- remote procedure
- definition 1
- remote transaction initiation
- remote transaction program
- See RTP 1
- remote transaction termination
- REPORT statement 1
- RHT, See remote host transactions 1
- ROLLBACK command 1, 2
- ROLLBACK processing 1
- RPC
- RPC interface
- RTP
- runtime traces 1
S
- sample
- sample definitions
- implicit versioning 1
- script file 1
- sequence objects
- in the PGDD environment dictionary 1
- SET command 1
- SET LOG_DESTINATION parameter 1, 3
- SET TRACE_LEVEL parameter 1, 3, 5, 6
- SIDE_NAME 1
- Side Information Profile 1, 2
- simple DG4APPC communication
- on gateway using SNA 1
- SNA
- and gateway components 1
- communication between mainframe and Oracle database 1
- communications function 1
- creating a TIP 1
- determining validity of TIP specification 1
- examples and sample files used in this guide 1
- flexible call sequence 1
- function in the gateway 1
- gateway transaction types 1
- implementing commit-confirm 1
- overview of the gateway, using 1
- parameters 1
- PGAU DEFINE TRANSACTION command 1
- remote transaction initiation 1
- remote transaction termination on the gateway 1
- steps to connecting Oracle database and mainframe 1
- supported remote host languages 1
- TIP internals 1
- uses APPC to access all systems 1
- writing TIPs 1
- socket file descriptor
- returned by TCP/IP network to PGAINIT 1
- specification file
- SPOOL command 1
- SQL*Plus
- statements
- see PGAU commands 1
- SYNCHRONIZED LEFT 1
T
- TCP/IP for IMS Connect 1, 2
- and gateway components 1
- and PGA_TCP_IMSC parameter table 1
- and PGAINIT 1
- and Remote Transaction Initiation 1
- Client application overview 1
- communication between gateway and Oracle database 1
- content of PGA_TCP_IMSC table 1
- creating a TIP 1
- determining validity of TIP specification 1
- elements of TIP-RTP correspondence 1
- examples and sample files used in this guide 1
- function in the gateway 1
- gateway support for, description 1
- IMS enabled 1
- mapping parameters using pg4tcpmap tool 1
- mapping SNA parameters to TCP/IP 1
- non-persistent socket transaction type 1
- OLTP in gateway architecture 1
- persistent socket transaction type 1
- PGAU DEFINE TRANSACTION command 1
- remote host languages supported 1
- remote transaction initiation 1
- remote transaction termination 1
- SENDs and RECEIVEs
- TIP CALL correspondence 1
- setting initsid.ora parameters 1
- simple communication
- between gateway and integrating server 1
- steps to communication between server and IMS 1
- steps to writing a TIP 1
- supports only IMS as OLTP 1, 2
- TIP granting privileges needed 1
- TIP internals 1
- TRANSACTION correspondence 1
- transaction types 1
- terminal-oriented transactions
- modifying 1
- terminating a TIP conversation 1, 2
- terms, gateway terms defined 1
- TIP 1, 2, 3
- APPC conversation sharing 1, 2
- background references 1
- CALL correspondence 1
- calling
- calling and controlling
- client application development
- compiling 1
- content documentation (tipname.doc) 1
- content file sections
- control file 1
- controlling
- conversation sharing used to circumvent large TIPs 1
- conversion 1, 2, 3
- converting PL/SQL datatypes to RAW 1
- creating 1
- customized interface for each remote host transaction (RTP) 1
- custom TIP writing 1
- DATA correspondence 1
- on gateway using TCP/IP 1
- datatype conversion support for COBOL 1
- declaring variables to create a TIP 1, 2
- defining, with PGAU 1
- defining and generating 1
- definition 1
- definition errors 1
- dependent TIP body or specification changes 1
- diagnostic parameters 1
- driver procedures
- flexible call sequence 1
- four steps to generate
- functions
- in Oracle database 1
- generated by PGAU 1
- granting privileges to use 1, 2, 3
- independent TIP body changes 1
- initializations 1, 2
- overriding 1
- initializing the conversation 1, 2
- internals 1
- override parameters 1
- overriding
- on gateway using TCP/IP 1
- overriding default attributes 1, 2
- overview 1, 2
- privileges needed 1, 2
- public functions
- recompiling 1, 2, 3
- remote transaction
- correspondence 1
- remote transaction correspondence, on gateway using TCP/IP 1
- remote transaction initiation (PGAINIT) 1
- requirements for corresponding with RHT
- requirements of the client application 1
- service 1
- specification file 1
- specifications
- generated by PGAU 1
- steps to writing
- terminating the conversation 1, 2
- trace controls 1
- tracing 1
- TRANSACTION correspondence 1, 2
- on gateway using SNA 1
- using transaction instance parameter
- on gateway using TCP/IP 1
- writing
- TIP control file commands 1, 6
- on gateway using TCP/IP 1
- tipname.doc file 1, 2, 3
- tipname.pkb file 1
- TIP specification 1, 2, 3
- TIP warnings and tracing
- suppressing 1
- TP_NAME 1
- TRACE_LEVEL 1
- trace option 1
- TIP definition errors 1
- traces 1, 2, 3, 4
- TRANSACTION correspondence
- transaction instance parameter
- Transaction Interface Package
- See TIP 1
- transaction socket
- transaction type for TCP/IP 1
- transaction types
- one-shot, persistent and multi-conversational, for SNA 1
- transparency