Index

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

A

  • APPC
  • APPC conversation sharing 4.10
  • 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
  • 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
    • 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 5.4
    • requirements 4.5
      • declare RHT/TIP data to be exchanged 4.5
      • exchange data with RHT using TIP user function 4.5
      • initialize RHT for multi-conversational applications 4.5
      • initialize RHT using TIP initialization function 4.5
      • repetitively exchange data with RHT using TIP user function 4.5
      • terminate RHT using TIP termination function 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
  • 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-confirm 5.1
    • application design requirements 5.4
    • architecture 5.5
    • components 5.3
    • logic flow 5.6
    • 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
  • COMMIT processing 2.2.1
  • 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
  • conversation sharing, see APPC conversation sharing 4.10
  • creating a TIP

D

  • database link 1.6
  • data conversion
  • DATA correspondence 4.6.1, 7.3.1
  • data dictionary, see PG DD 1.3
  • data exchange
  • data format conversion D
  • 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 D.2.1
    • send length D.1
    • truncated and non-unique names D.2.4
  • datatype conversions
    • COBOL symbols interpreted by PGAU D.2.1
  • DBCS
    • See double-byte character sets 4.11, 7.8
  • DBMS_PIPE PL/SQL package 3.1
  • debugging tool
    • PGATRAC function B.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
  • DISCONNECT command 2.6.6
  • double byte character sets (DBCS)
    • in application development 4.11, 7.8
  • driver procedure

E

  • EBCDIC
    • automatic conversion 1.2
  • environment dictionary
  • 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
    • 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


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
    • remote transaction termination
    • 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.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


I

  • I/O PCB 1.9.2, 3.2.1, 7.1
  • implicit APPC 4.12
  • implicit versioning
    • sample definitions F.5
  • IMS 1.1
    • communication with Integrating Server
  • IMS/TM
    • communication through the gateway 1
  • IMS inquiry
    • location of sample file 1.4
  • initialization files
    • see gateway initialization files, also see PGA parameters 1.3
  • initiating remote transactions 1.7.1.1
  • initsid.ora file 1.3, 8.9.1, 8.9.2, 8.9.2.1
    • parameters to run pg4tcpmap tool 6.4

J


K


L


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
  • MBCS, See multi-byte character sets 4.11, 7.8
  • MODE_NAME 5.6.2
  • multi-byte character sets (MBCS) 4.11, 7.8
    • application development support 4.11, 7.8
  • multi-conversational transactions 4.3.2.3, 4.5
  • multi-conversational transaction type
    • for gateway using SNA 1.8.1

N

  • non-persistent socket transaction type for TCP/IP for IMS Connect 1.9.1
  • NUMBER_TO_RAW_FORMAT function C.1.7
  • NUMBER_TO_RAW and RAW_TO_NUMBER argument values C.2
  • NUMBER_TO_RAW function C.1.3

O

  • OCCURS DEPENDING ON 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
  • operating system
    • role in gateway installation 1.5
  • Oracle database 1.7.1.2
    • between server and mainframe
    • 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
    • stores PL/SQL 1.3
  • Oracle Database Gateway for APPC
    • also see gateway 1.8.1
    • compatibility with version 3.4.0 4.10.3
    • development environment 1.2
    • See also, gateway server 5.5.1
  • Oracle global transaction ID 5.1, 5.3, 5.4, 5.6.2
  • Oracle integrating server 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
    • interaction with gateway server in commit-confirm 5.5.2
    • simple communication
      • on gateway using TCP/IP 1.9.2
    • steps to communication
  • Oracle Net 1.3, 4.13, 7.9, C
    • restrictions for data conversion C
  • overrides 4.7.2.2, 7.4.2.2

P


R

  • RAW_TO_NUMBER FORMAT function C.1.6
  • RAW_TO_NUMBER function C.1.2
  • recompilation errors
  • REDEFINE DATA statement A.2.3.7, F.6
  • 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
  • remote procedural call
  • remote procedural call (RPC) A.2.3.5
    • calling the gateway B
    • executing gateway functions B
    • parameters B.4
    • PGAINIT and PGAINIT_SEC B.1
    • PGAINIT and PGAINIT_SEC, parameters B.1
    • PGATCTL B.4
    • PGATERM B.3
    • PGATERM, parameters B.3
    • PGATRAC B.5
    • PGATRAC, parameters B.5
    • PGAXFER B.2
    • PGAXFER, parameters B.2
  • remote procedure
    • definition 1.3
  • remote transaction initiation
  • remote transaction program
  • remote transaction termination
  • REPORT statement 3.2.6
  • RHT, See remote host transactions 3.2.1
  • ROLLBACK command 2.2.1, 2.2.2
  • ROLLBACK processing 2.2.2
  • RPC
  • RPC interface
    • PGATCTL B.4
    • PGATERM B.3
    • PGATRAC B.5
    • PGAXFER B.2
    • See also, remote procedural call (RPC) B
  • RTP
  • runtime traces 8.5
    • controls 8.6
    • conversion warnings 8.6.2
    • data conversion tracing 8.6.4
    • gateway exchange tracing 8.6.5
    • runtime function entry/exit tracing 8.6.3

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.9.1
  • SET TRACE_LEVEL parameter 8.8, 8.9.1, 8.9.2.1, 8.9.2.2
  • SIDE_NAME 5.6.2
  • Side Information Profile 2.6.4, B.1
  • 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
    • 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
  • 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 2.6
  • SYNCHRONIZED LEFT 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
    • 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
  • 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
      • 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
    • 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
    • customized interface for each remote host transaction (RTP) 4.4
    • custom TIP writing E
    • 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, with PGAU 2.5
    • defining and generating 3.3
    • definition 1.3
    • definition errors 8.1
    • dependent TIP body or specification changes E.2.2
    • diagnostic parameters 4.10.6
    • driver procedures
    • 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
    • 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
    • initializing the conversation 4.7.2, 7.4.2
    • internals E
    • override parameters 4.10.6
    • overriding
    • 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
    • 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
    • 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
    • specifications
      • generated by PGAU 1.6
    • steps to writing
    • 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
    • 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.9.3.1
  • tipname.doc file 3.5, 4.5, 7.4.1
  • tipname.pkb file 8.5
  • TIP specification 4.1, E.2, E.2.1
  • TIP warnings and tracing
    • suppressing 8.7
  • TP_NAME 5.6.2
  • TRACE_LEVEL 8.9.1
  • trace option 8
    • TIP definition errors 8.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
  • Transaction Interface Package
  • transaction socket
    • transaction type for TCP/IP 1.9.1
  • 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
  • USAGE(SKIP) D.2.3
  • UTL_PG
    • package
      • definition 1.3
    • parameters (input and output) C.1.1
    • PL/SQL package 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_FORMAT C.1.7
    • NUMBER_TO_RAW and RAW_TO_NUMBER argument values C.2
    • RAW_TO_NUMBER C.1.2
    • RAW_TO_NUMBER_FORMAT C.1.6
    • WMSG C.1.9
    • WMSGCNT C.1.8
  • UTL_RAW PL/SQL package 3.1, C
    • definition 1.3

V


W