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