Oracle Procedural Gateway for APPC User's Guide
Release 9.0.1.0.1 for UNIX
Part Number A90397-01
Go To Documentation Library
Library		 Go To Product List
Product		 Go To Table Of Contents
Contents

Go to previous page

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
communications function, 1-12
facilitates gateway access to systems, 1-2
overview, 1-2
runtime, 4-30
SENDs and RECEIVEs
TIP CALL correspondence, 4-16
trace, 6-15
using with terminal-oriented transaction program, 4-36
APPC conversation sharing, 4-28
concepts, 4-28
examples, 4-32
for too large TIPs, 4-31
overrides and diagnostics, 4-35
TIP compatibility, 4-30
usage, 4-30
architecture
commit-confirm, 5-9
three components of gateway architecture, 1-7
ASCII
automatic conversion, 1-7

B

BIT_AND function, D-2
BIT_COMPLEMENT function, D-3
BIT_OR function, D-3
BIT_XOR function, D-4

C

CALL correspondence, 4-16
CAST_TO_RAW function, D-5
CAST_TO_VARCHAR2 function, D-6
client application development
calling a TIP, 4-20
customized TIPs for remote host transaction, 4-8
declaring TIP variables, 4-20
error handling, 4-27
examples and samples, 1-5
exchanging data, 4-26
executing, 4-28
granting execute authority, 4-28
overriding TIP initializations, 4-24
overview, 4-2
preparation, 4-3
remote host transaction types
multi-conversational transactions, 4-7
one-shot transactions, 4-5
persistent transactions, 4-6
See also, index entries for each transaction type
requirements, 4-9
declare RHT/TIP data to be exchanged, 4-9, 4-10, 4-12
exchange data with RHT using TIP user function, 4-10, 4-13
initialize RHT for multi-conversational applications, 4-12
initialize RHT using TIP initialization function, 4-9, 4-11
repetitively exchange data with RHT using TIP user function, 4-11
terminate RHT unsing TIP termination function, 4-13
terminate RHT using TIP termination function, 4-10, 4-12
security considerations, 4-26
terminating the conversation, 4-27
TIP and remote transaction program correspondence, 4-14
TIP CALL correspondence, 4-16
TIP content and purpose, 4-4
TIP DATA correspondence, 4-14
TIP TRANSACTION correspondence, 4-18
COBOL, 1-14, 4-3, G-4, G-13
source code, F-2
command termination, 2-7
COMMIT command, 2-3
user responsibility, 2-3
COMMIT processing, 2-3
commit-confirm, 4-8, 5-2
application design requirements, 5-8
architecture, 5-9
components, 5-9
interactions, 5-10
components required, 5-3
configuring, 5-5
gateway initialization parameters, 5-6
OLTP, 5-7
Oracle server, 5-5
flow, 5-10
logic flow, step by step, 5-10
Oracle Global Transaction ID, 5-2
purpose, 5-1
relation to two-phase commit, 5-2
required components
OLTP commit-confirm transaction log, 5-4
OLTP forget/recovery transaction, 5-4
OLTP transaction logging code, 5-4
Oracle logging server, 5-3
procedural gateway for APPC server, 5-3
sample applications, 5-14
supported OLTPs, 5-2
transaction log, 5-13, 5-14
communication, between mainframe and Oracle integrating server, 1-11
COMPARE function, D-6
compiling a TIP, 3-8
components
of procedural gateway for APPC, G-2
CONCAT function, D-7
configuring
commit-confirm, 5-5
Oracle integratng server, 5-5
CONNECT command, 2-4, 2-8
control file
creating, 1-14
conversation sharing, see APPC conversation sharing
CONVERT function, D-8
COPIES function, D-9
creating a TIP
(detailed), 3-1
(overview), 1-13

D

data conversion
errors, 6-5
languages supported, H-3
DATA correspondence, 4-14
data dictionary, see PG DD
data exchange (PGAXFER function), 1-10
data format conversion, G-1
database link, 1-9
datatype
RAW, D-1
datatype conversion, G-1
See USAGE (PASS), USAGE (ASIS). USAGE (SKIP), and PL/SQL Naming Algorithms
convert length, G-3
duplicate names, G-15
expected length, G-3
format conversion, G-8
length checking, G-3
parameters over 32K in length, G-3
PL/SQL, G-14
naming algorithms, G-13
receive length, G-3
removing support for parameters over 32K in length, G-3
send length, G-3
truncated and non-unique names, G-14
DBCS
See double-byte character sets
DBMS_PIPE PL/SQL package, 3-2
debugging tool
PGATRAC function, C-10
DEFINE CALL statement ("command"), 1-14, 3-5, 4-31, E-3
DEFINE DATA statement ("command"), 1-14, 2-42, 3-5, 4-14, 4-31, A-12, E-2
DEFINE TRANSACTION statement ("command"), 3-6, 4-31, E-3
defining and generating a TIP, 3-7
DESCRIBE command, 2-20
DISCONNECT command, 2-21
documentation required, xiii
double byte character sets (DBCS)
in application development, 4-35
driver procedure, 1-15

E

EBCDIC
automatic conversion, 1-7
errors
causes of, 6-2
data conversion, 6-5
including exception handlers in your TIP, 4-27
MAKE_NUMBER_TO_RAW_FORMAT function, D-29
MAKE_RAW_TO_NUMBER_FORMAT function function, D-26
NUMBER_TO_RAW function, D-23
NUMBER_TO_RAW_FORMAT function, D-33
PLS -00123
program too large, 4-31
RAW_TO_NUMBER function, D-20
RAW_TO_NUMBER_FORMAT function, D-31
truncation, 6-6
WMSG function, D-36
WMSGCNT function, D-34
examples
APPC conversation sharing, 4-32
EXECUTE command, 2-22
executing
client application development, 4-28
EXIT command, 2-23

F

file
initsid.ora, 1-2, 5-6, 6-13, 6-14, 6-15, H-3
pgaccau.sql, 5-5
pgacclg.asm, 5-14
pgacics.sql, F-1
pgadb2c.cob, 5-14
pgadb2i.cob, F-2
pgadb2id.sql, 4-27
pgadb2i.pkb, 1-5, 1-15, 4-2, 4-5
pgadb2i.pkh, 1-5, 1-15, 4-5
pgadb2i.sql, B-1, B-12
pgareco.asm, 5-14
pgau.trc, 2-26, 2-29
pgddausr.sql, 4-38
pgddcr8.sql, 2-6, A-4
tipname.doc, 3-9, 4-14, 4-20
tipname.pkb, 6-8
tname.ctl, 3-6, 3-7
tnsnames.ora, 5-6
format conversion, G-8
function
PGAINIT, 1-2, 1-10, B-11, B-19
PGATERM, 1-2, 1-10, B-19, C-8
PGAXFER, 1-2, 1-10, 4-5, C-5
PGAXFER, restrictions, B-9
UTL_PG, D-17
UTL_RAW, D-2
functions
see remote procedural call (RPC)
see UTL_PG
see UTL_RAW

G

gateway
creating a TIP, 3-1
features, 1-6
functions, 1-11
initialization file, 1-2
language support, H-2
overview, 1-2
remote procedure, definition, 1-2
server trace output sample, 6-16
starting, 1-9
terms used, 1-2
three components of gateway architecture, 1-7
tracing, 6-13
gateway server, 5-9
function in commit-confirm architecture, 5-9
transaction log tables, 5-13
gateway server trace, 6-13, 6-14
output sample, 6-16
GENERATE statement ("command"), 1-14, 3-6, 3-8, 4-14, B-2, E-3
granting privileges for creating TIPs, 3-2
GROUP statement (PGAU), 3-8

H

HOST command, 2-33

I

IBM VS COBOL II
datatype conversion supported by PG DD and TIPs, G-4
support for double byte character sets, PIC G datatypes, 4-35
implicit APPC, 4-37
implicit versioning
sample definitions, E-4
implied APPC, 5-3
initialization file
definition, 1-2
initiating remote transactions, 1-10
initsid.ora file, 1-2, 5-6, 6-13, 6-14, 6-15, H-3

J

JUSTIFIED, G-8
JUSTIFIED LEFT, G-8
JUSTIFIED RIGHT, G-8

K

keywords
PGAU, 2-7

L

LANGUAGE parameter, H-3
LENGTH function, D-10
LENGTH IS field-2, G-9

M

MAKE_NUMBER_TO_RAW_FORMAT function, D-28
errors, D-29
MAKE_RAW_TO_NUMBER_FORMAT function, D-25
errors, D-26
MBCS See multi-byte character sets
messages
UTL_RAW interface, D-2
multi-byte character sets (MBCS), 4-35
application development support, 4-35
multi-conversational transactions, 1-11, 4-7, 4-12

N

National Language Support (NLS), 3-4, H-1
in the gateway, H-2
languages supported for data conversion, H-3
multi-byte character set support, 4-35
on various platforms, H-4
NLS LANGUAGE parameter
syntax, H-3
NUMBER_TO_RAW and RAW_TO_NUMBER argument values, D-37
NUMBER_TO_RAW function, D-22
errors, D-23
NUMBER_TO_RAW_FORMAT function, D-33
errors, D-33

O

OCCURS DEPENDING ON, G-11
OCCURS n TIMES, G-10
OLTP
See online transaction processor
one-shot transactions, 1-11, 4-5, 4-9, 5-8
online transaction processor (OLTP)
character set, H-4
commit-confirm transaction log, 5-4
configuring, 5-7
definition, 1-3
forget/recovery transaction, 5-4
function in the gateway, 1-9
functional requirements of the gateway, 5-8
in commit-confirm, 5-2
logic flow for successful commit, 5-10
parameters needed for NLS, H-4
remote, 1-1
security considerations, 4-26
transaction logging code, 5-4
Oracle global transaction ID, 5-2, 5-4, 5-8, 5-13, 5-14
Oracle integrating server, 1-7, 1-9, 1-10, 4-2
and OLTP, 1-8
architecture, 1-7
calling RPC functions, 5-10
component of commit-confirm architecture, 5-9
configuring for commit-confirm, 5-5
definition, 1-3
interraction with gateway server, 5-10
multiple servers, 1-8
role in the gateway, 1-11
steps to communication between server and mainframe, 1-12
stores PL/SQL, 1-4
support for NLS, H-4
Oracle logging server, 5-3, 5-9, 5-10
description, 5-9
interraction with gateway server, 5-10
Oracle Net, 1-3, 4-38, 5-6, 6-16, D-1
function, 1-7
restrictions for data conversion, D-1
supported protocols, 1-8
Oracle Procedural Gateway for APPC
compatibility with version 3.4.0, 4-30
development environment, 1-7
features, 1-6
functions, 1-11
overview, 1-2
See also, gateway server
OVERLAY function, D-10
overrides, 4-25
LOGMODE, 4-24
LUname, 4-24
Side profile, 4-24
TPname, 4-24

P

package
UTL_PG, 3-2
parameters
see NLS LANGUAGE
see PGAU commands
see remote procedural call (RPC)
see SET LOG_DESTINATION
see SET TRACE_LEVEL
persistent transactions, 1-11, 4-6, 4-10, 5-8
PG DD (Data Dictionary), 2-2, 2-15
active dictionary, A-4
sequence numbers, A-5
versioning, A-4
active dictionary tables
pga_call, A-10
pga_call_parm, A-11
pga_data, A-12
pga_data_attr, A-16
pga_data_values, A-17
pga_fields, A-14
pga_trans, A-6
pga_trans_attr, A-6
pga_trans_calls, A-9
pga_trans_values, A-8
data definitions for parameters over 32K in length, G-3
datatype conversion support for IBM VS COBOL II, G-4
definition, 1-3
definition names
valid characters in, 2-5
diagnostic
options, 6-3
references, 6-3
entries, creating a TIP, 3-7
environment dictionary, A-2
environment dictionary tables, A-3
pga_maint, A-3
pga_modes, A-4
pga_usage, A-4
in writing PGAU statements, 3-5
keyword form in storage, 2-7
maintenance, 2-4
overview, A-2
preparing client application, 4-3
purpose of REPORT command, 2-41
relationship to PGAU, 2-2
remote transaction definitions, 2-4
ROLLBACK command, 2-3
select scripts, 6-4
storage of information needed for PGAU GENERATE to perform, 4-14
transaction attributes, 4-25
USAGE (SKIP), G-13
version definition tables, 2-6
PGA
administrator, 2-2
definition, 1-3
PGA Server (also called, Gateway or Gateway Server), G-2
pga_call table, A-10
pga_call_parm table, A-11
PGA_CC_PENDING table
commit-confirm transaction log, 5-13
pga_data table, A-12
pga_data_attr, A-16
pga_data_values table, A-17
pga_fields table, A-14
pga_maint constant, A-3
pga_modes constant, A-4
pga_trans table, A-6
pga_trans_attr table, A-6
pga_trans_calls table, A-9
pga_trans_values table, A-8
pga_usage, A-4
pga_usage constant, A-4
pgaccau.sql file, 5-5
pgacclg.asm file, 5-14
pgacics.sql file
sample program, F-1
pgadb2c.cob file, 5-14
pgadb2i, 1-15
pgadb2i.cob file, F-2
pgadb2id.sql file, 4-5, 4-27
pgadb2i.pkb, 1-5
pgadb2i.pkb file, 1-15, 4-2, 4-5
pgadb2i.pkh file, 1-5, 1-15
pgadb2i.sql file, 4-5, B-1, B-12
PGAINIT, B-11, B-19, C-2
PGAINIT function, 1-2, 1-10
pgareco.asm file, 5-14
PGATCTL, C-8
PGATERM, B-19, C-8
PGATERM function, 1-2, 1-10
PGATRAC, C-10
PGAU, 4-2
commands- also called "statements", 2-7
COMMIT processing, 2-3
defining and testing a TIP, 2-5
definition, 2-1
used to generate TIPs, 1-3
definition names, 2-5
definition versioning, 2-6
definitions, 2-4
functions, 2-2
generate TIP, 1-9
generation, 2-4
invoking, 2-3, 2-4
keywords, 2-7
NLS Language usage, H-3
overview, 2-2
ROLLBACK processing, 2-3
sample input, E-1
terminating a statement, 2-7
writing statements, 3-5
PGAU commands, 1-14, 2-7
CONNECT, 2-4, 2-8
CONNECT, parameters, 2-8
DEFINE CALL, 1-14, 2-2, 2-9, 2-43, 3-5, 4-31
call list, 3-3
parameters, 2-9
sample, E-3
DEFINE DATA, 1-14, 2-2, 2-11, 2-42, 3-5, 4-14, 4-31, A-12
parameters, 2-11
sample, E-2
DEFINE DATA, datatype conversions
USAGE (ASIS), G-13
USAGE (PASS), G-4
USAGE (SKIP), G-13
DEFINE PGAU, call list, 3-4
DEFINE TRANSACTION, 1-14, 2-2, 2-15, 3-6, 4-31
sample, E-3
DEFINE TRANSACTION, parameters, 2-15, 3-4
defining correlation between TIP and RTP, 2-2
DESCRIBE, 2-20
DESCRIBE, parameters, 2-20
DISCONNECT, 2-21
DISCONNECT, parameters, 2-21
EXECUTE, 2-22
EXECUTE, parameters, 2-22
EXIT, 2-23
EXIT, parameters, 2-23
formatting of Call and Transaction reports, 2-43
four main types, in control file, 1-14
GENERATE, 1-14, 2-2, 2-24, 3-6, 3-8, 3-9, 4-14, B-2
error messages, 6-4
parameters, 2-24
problem analysis, 6-3
sample, E-3
support and non-support for parameters over 32K length, G-3
traces, 6-2
GROUP, 2-31, 3-8
HOST, 2-33
parameters, 2-33
PRINT, 2-34
REDEFINE DATA, 2-35, A-12
sample, E-8
REM, 2-40
REM, parameters, 2-40
REPORT, 2-41
output sample, E-9
REPORT, parameters, 2-41
SET, 2-44
SET, parameters, 2-44
SHOW, 2-47
SHOW, parameters, 2-47
SPOOL, 2-49
SPOOL, parameters, 2-49
TRANSACTION, 2-43
UNDEFINE CALL, 2-50
UNDEFINE CALL, parameters, 2-50
UNDEFINE DATA, 2-51
UNDEFINE DATA, parameters, 2-51
UNDEFINE TRANSACTION, 2-53
UNDEFINE TRANSACTION, parameters, 2-53
UNDEFINE, sample, E-9
VARIABLE, 2-54
VARIABLE, parameters, 2-54
PGAU script file
adding spool and echo, 3-8
creating, 3-6
PGAU statements , See PGAU commands
pgau.trc file, 2-26, 2-29
PGAXFER, C-5
PGAXFER function, 1-2, 1-10, 4-5
pgddausr.sql file, 4-38
pgddcr8.sql file, 2-6, A-4
PGDL (Procedural Gateway Definition Language), 2-2, C-1
definition, 1-3
PIC 9, 6-6, G-7
PIC G, 6-6
datatypes, 4-35
PIC X, 6-5, G-4
PKGEX(DC) diagnostic option, 6-8
PKGEX(DR)
GENERATE diagnostic option, 6-3
PL/SQL, 1-3, D-2
call, A-9, A-10
code, C-2
code generator, 1-7, 6-5
data length limits, 6-6
datatypes, 4-9, 4-10, 4-12, 4-15, B-6, B-14, B-16, B-17, E-3
converted to RAW, 1-10
developing TIPs, G-1
enabling a trace, 6-15
invoking PG4APPC, 1-12
naming algorithms, G-13
delimiters, G-13
duplicate names, G-15
qualified compound names, G-14
parameter restrictions, B-10
parameters, 4-20, B-7
record, B-13, B-16
record format, E-6
record types, B-11
simple procedure, F-1
stored procedure, 1-12
transferring data
using RAW datatype, D-1
variable names, G-14
datatype conversion, G-14
variables, 3-9, G-10, G-11, G-14
PL/SQL package, 2-4, 2-9, 2-50, 2-53, 3-2, 4-5, 6-3, B-2, C-1
See TIP
components, 4-4
contents
package specification, 4-4
DBMS_PIPE, 3-2
definition, 1-4
execute authority, 4-28
function, 1-9, 4-2
grants required, 3-2
loading the tip, B-19
pagcics, 1-12
parameter, 2-27
specifying names, 4-19
stored procedure specification, 1-6
PL/SQL stored procedure, 5-5, 5-10
changing trace level, C-8
starting up communication with mainframe, 1-12
used for logging transactions, 5-5
PL/SQL stored procedure specification
See PL/SQL package
PRINT command, 2-34
privileges
needed to use TIPs, 4-37
problem analysis
of data conversion and truncation errors, 6-6
with PG DD diagnostic references, 6-3
with PG DD select scripts, 6-4
with TIP runtime traces, 6-8
procedural gateway administration (PGA), 1-3
Procedural Gateway Administration Utility - See PGAU, 1-9
procedural gateway for APPC
components, G-2
See Also, Oracle Procedural Gateway for APPC
See gateway server, G-2
product publications, xiii

R

RAW, B-14, D-7
RAW_TO_NUMBER FORMAT function, D-31
RAW_TO_NUMBER function, D-19
errors, D-20
RAW_TO_NUMBER_FORMAT function
errors, D-31
recompilation errors
causes, B-5
REDEFINE DATA statement, A-12, E-8
REDEFINES, G-12
REM command, 2-40
remote host transactions (RHT)
APPC conversation sharing, 4-28
attributes needed, 4-19
client application, 4-10
defined using the PGAU DEFINE TRANSACTION statement, 4-18
evaluating, 3-2
multi-conversational, client applications, 4-12
one-shot, client applications, 4-9
persistent, client applications, 4-10
requirements
understanding, 4-4
steps involved in, 4-9
types, 1-11, 4-5
remote procedural call (RPC), A-10
calling the gateway, C-1
definition, 1-4
executing gateway functions, C-2
functions, 1-9
in TIP development, B-11
parameters, C-8
PGAINIT, B-19
PGAINIT and PGAINIT_SEC, C-2
PGAINIT and PGAINIT_SEC, parameters, C-2
PGATCTL, C-8
PGATERM, B-19, C-8
PGATERM, parameters, C-8
PGATRAC, C-10
PGATRAC, parameters, C-10
PGAXFER, C-5
restrictions, B-9, B-10
PGAXFER, parameters, C-5
processing, 1-1
remote procedure
definition, 1-2
remote transaction program (RTP), 1-3, 4-8
activities, 4-7
definition, 1-4
in TIP development, B-11
purpose, 4-4
restrictions, B-10
synchronized APPC SEND and RECEIVE in TIPs, B-7
remote transaction termination
PGATERM, 1-10
RENAMES, G-11
REPORT statement, 3-6
restriction
gateway non-support of two-phase commit, 4-8
restrictions in Oracle Procedural Gateway for APPC, B-9
REVERSE function, D-12
RHT, See remote host transactions
ROLLBACK command, 2-3
ROLLBACK processing, 2-3
RPC interface
PGAINIT, C-2
PGATCTL, C-8
PGATERM, C-8
PGATRAC, C-10
PGAXFER, C-5
See also, remote procedural call (RPC)
RPC, See remote procedural call
RTP, See remote transaction program
runtime traces, 6-8
controls, 6-10
conversion warnings, 6-10
data conversion tracing, 6-11
gateway exchange tracing, 6-11
runtime function entry/exit tracing, 6-11

S

sample
applications, 5-14
CICS APPC transaction, F-2
PGAU DEFINE CALL command, E-3
PGAU DEFINE DATA command, E-2
PGAU DEFINE TRANSACTION command, E-3
PGAU GENERATE command, E-3
PGAU REDEFINE DATA command, E-8
PGAU REPORT output, E-9
PGAU UNDEFINE command, E-9
TIP output, E-21
TIP trace output, E-19
sample definitions
implicit versioning, E-4
script file, 3-6
SET command, 2-44
SET LOG_DESTINATION parameter, 6-7, 6-8, 6-14
SET TRACE_LEVEL parameter, 6-7, 6-14, 6-15, 6-16, C-8, C-9, C-10
SHOW command, 2-47
Side Information Profile, 2-18, C-5
simple PG4APPC communication, 1-11
SNA APPC (Advanced Program-to-Program Communication), 1-2
specification file, 1-15
SPOOL command, 2-49
SQL*Plus
connecting server and mainframe, 1-12
invoking, 3-8
recompiling TIP body changes, B-3
running scripts, 4-37
test scripts, 6-5
use in configuring Oracle integrating server, 5-5
starting the gateway, 1-9
statements
see PGAU commands
storage measurements, xvi
SUBSTR function, D-12
supported languages, H-2
SYNCHRONIZED, G-12
SYNCHRONIZED LEFT, G-13
SYNCHRONIZED RIGHT, G-12

T

terminal-oriented transactions
modifying, 4-36
terminating a TIP conversation, 4-27
terms, gateway terms defined, 1-2
TIP, 4-2
APPC conversation sharing, 4-28, 4-30
architecture, B-10, B-11, B-18
background references, B-2
body, B-11
CALL correspondence, 4-16
call correspondence order restrictions, 4-18
call, to initiate and terminate connection to RTP, B-5
calling
and controlling, 4-2
from the client application, 4-20
client application development
content and purpose, 4-4
compiling, 3-8
content documentation (tipname.doc), 3-9
content file sections
GENERATION Status, 3-9
TIP Default Calls, 3-9
TIP Transaction, 3-9
TIP User Calls, 3-9
TIP User Declarations, 3-9
TIP User Variables, 3-9
control file, 2-2
controlling runtime conversion warnings, 6-10
controlling runtime data conversion tracing, 6-11
controlling runtime function tracing, 6-11
controlling runtime gateway exchange tracing, 6-11
conversation sharing used to circumvent large TIPs, 4-31
conversion, 4-35
converting PL/SQL datatypes to RAW, 1-10
creating, 3-1
custom TIP writing, B-1
customized interface for each remote host transaction (RTP), 4-8
DATA correspondence, 4-14
datatype conversion support for IBM VS COBOL II, G-4
declaring variables to create a TIP, 4-20
defining and generating, 3-7
definition, 1-4
definition errors, 6-2
dependent TIP body or specification changes, B-4
diagnostic parameters, 4-35
driver procedures, 1-15
flexible call sequence, 4-17
four steps to generate, 1-13
functions, 1-9
generated by PGAU, 4-2
granting privileges to use, 3-2, 4-37
independent TIP body changes, B-3
initializations, 4-24, B-18
overriding, 4-24
initializing the conversation, 4-22
internals, B-1
operation, B-19
output, sample, E-21
override parameters, 4-35
overriding default attributes, 4-25
overview, 1-13
parameter length checking, G-3
privileges needed, 3-2, 4-37
programming, B-10, B-11, B-18
public functions
tip_init, 4-6
tip_inqr, 4-6
tip_mode, 4-6
tip_term, 4-6
tip_updt, 4-6
recompiling, B-3, B-4
remote transaction
correspondence, 4-14
remote transaction initiation (PGAINIT), 1-10
requirements for corresponding with RHT, 4-14
requirements of the client application, 4-9
service, 4-29
specification file, 3-7
synchronizing SEND/RECEIVE, B-7
terminate function, B-20
terminating the conversation, 4-27
trace controls, 6-10
trace output sample, E-19
tracing, 6-7
TRANSACTION correspondence, 4-18
usage, B-19
TIP control file commands, 1-14
TIP specification, 1-9, 4-2, B-2, B-3, B-10
changes, B-4
errors, B-5
file, 1-15
TIP warnings and tracing
suppressing, 6-12
tipname.doc file, 3-9, 4-14, 4-20
tipname.pkb file, 6-8
tname.ctl file, 3-6, 3-7
tnsnames.ora file, 5-6
trace option, 6-1
TIP definition errors, 6-2
TRACE_LEVEL, 6-14
traces, 6-10, 6-11
diagnostic, 6-7
enable gateway server trace, 6-14
enabling APPC trace from PL/SQL, 6-15
gateway server, 6-13
purpose of initializing conversations, 4-22
runtime, 6-8
trace controls, 6-10
sample gateway server output, 6-16
suppressing, 6-12
TIP, 6-8, 6-12
TRANSACTION correspondence, 4-18
Transaction Interface Package
See TIP
TRANSLATE function, D-13
TRANSLITERATE function, D-14
transparency, 1-6
two-phase commit, 4-8
platform support for, 2-18
supported for AIX, 4-7
transactional support, 1-6

U

UNDEFINE statement, 3-6, E-9
USAGE(ASIS), G-13
USAGE(PASS), G-4
datatype conversion, G-4
FILLER, G-8
PIC 9, G-7
PIC G, G-5
PIC X, G-4
format conversion
OCCURS DEPENDING ON, G-11
OCCURS n TIMES, G-10
USAGE(SKIP), G-13
UTL_PG
input parameters
wmsgbsiz, D-18
output parameters
wmsgblk, D-18
parameters (input and output), D-17
PL/SQL package, 3-2
UTL_PG function, B-18, D-17
MAKE_NUMBER_TO_RAW_FORMAT, D-28
MAKE_RAW_TO_NUMBER_FORMAT, D-25
NUMBER_TO_RAW, D-22
NUMBER_TO_RAW and RAW_TO_NUMBER argument values, D-37
NUMBER_TO_RAW_FORMAT, D-33
RAW_TO_NUMBER, D-19
RAW_TO_NUMBER_FORMAT, D-31
WMSG, D-35
WMSGCNT, D-34
UTL_PG input parameters
compname, D-18
compopts, D-18
envrnmnt, D-18
mask, D-17
maskopts, D-18
nlslang, D-18
wind, D-18
UTL_PG PL/SQL package
definition, 1-4
description, G-2
UTL_RAW function
BIT_AND, D-2
BIT_COMPLEMENT, D-3
BIT_OR, D-3
BIT_XOR, D-4
CAST_TO_RAW, D-5
CAST_TO_VARCHAR2, D-6
COMPARE, D-6
CONCAT, D-7
CONVERT, D-8
COPIES, D-9
LENGTH, D-10
OVERLAY, D-10
REVERSE, D-12
SUBSTR, D-12
TRANSLATE, D-13
TRANSLITERATE, D-14
XRANGE, D-16
UTL_RAW PL/SQL package, 3-2, D-1
definition, 1-4
description, G-2
functions, D-2

V

VARIABLE command, 2-54

W

WMSG function, D-35
errors, D-36
WMSGCNT function, D-34
WMSGCNTfunction
errors, D-34
writing PGAU statements, 3-5

X

XRANGE function, D-16
Go to previous page
Oracle
Copyright © 2001 Oracle Corporation.
All Rights Reserved.
Go To Documentation Library
Library		 Go To Product List
Product		 Go To Table Of Contents
Contents