Skip Headers
Oracle Procedural Gateway® Visual Workbench for WebSphere MQ Installation and User's Guide
10g Release 2 (10.2) for Microsoft Windows (32-Bit)

Part Number B19082-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

Index

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

A

Acknowledgment parameter
for message queue profile, 6.5
with Response Queue, 6.5
administrative user, creating, 5.4.2.5

C

character sets
in data profiles, 6.3
choosing a repository server, 5.4.1.1
CLOSE_CACHED_OPEN_CURSOR initialization parameter, 2.4.1
COBOL
copybook, 6.1
copybook file parameter, 6.3
data definition, 6.3
data profile, 6.4, 6.4.1
data profile (example), 6.3
data type conversion, 7.12
FILLER data type conversion, 7.12.4
format conversion, 7.13
JUSTIFIED, 7.13.1
JUSTIFIED LEFT, 7.13.2
JUSTIFIED RIGHT, 7.13.1
messages, 6.1
OCCURS clause, 7.13.3, 7.13.4
PIC 9 data type conversion, 7.12.3
PIC G data type conversion, 7.12.2
PIC X data type conversion, 7.12.1
RENAMES clause, 7.13.5, 7.13.6
supported version, 1.3.1.1
SYNCHRONIZED, 7.13.7
SYNCHRONIZED LEFT, 7.13.8
SYNCHRONIZED RIGHT, 7.13.7
version, parameter for data profile, 6.3
code
data mapping, 6.8.2
template, 6.8.2
viewing the generated code, 6.8.2
compatibility
MIP and beta version MIP, 2.2, 6.8.1
compilation errors, 6.11
compiling the MIP, 6.11
Connect dialog box, 6.2
connecting to a repository, 6.2
copybook
and data mapping information, 6.3
COBOL, 6.1
sample files, 6.3
correlation parameter, 7.10.2.1
creating
a message queue profile, 6.5
an interface profile and generating a MIP, 6.8
data profiles, 6.3
the administrative user, 5.4.2.5
cursors, maximum open, 2.4.1

D

data conversion
COBOL, 7.12
FILLER, 7.12.4
package
description, 7.11
duplicate names of record types, 7.14.4
EMPLOYEE, 7.11
gateway test code, 6.10
in run-time environments, 7.11
name prefixed as the leftmost qualifier, 7.14.2
using MIP templates, 6.12
using PL/SQL RECORDs of TABLEs, 7.13.3
warnings with JUSTIFIED LEFT, 7.13.2
with WHEN criterion, 7.13.6
PIC 9, 7.12.3
PIC G, 7.12.2
PIC X, 7.12.1
PIC X example, 7.12.1
PL/SQL mapping example, 7.11
PL/SQL naming algorithm, 7.14.1
required PL/SQL packages, 7.11
Data Definition Name
parameter for data profile, 6.3
data dictionary
checked by pgvwbrepos.sql script, 5.4.2.2
data mapping package, 6.8.2
data profile
COBOL, 6.4, 6.4.1
creating, 6.3, 6.3
Define COBOL Data Definition dialog box, 6.3
definition, 6.3, 7.1.1
EMPLOYEE, 7.1.2
ENQUEUE and DEQUEUE procedures, 7.1.1.2
generated data mapping, 6.8.2
introduction, 1.3.1.1
message exchange, 6.1
PL/SQL mapping, 6.3
removing, 6.4.1
updating, 6.4
database link
connecting MIP to a procedural gateway, 7.1.1
data-mapping code
invoked by MIP, 7.1.1
DBMS_OUTPUT package, 5.4.1.4, 5.4.2.3, 6.13.1, 7.11, A.1, A.2
DBMS_PIPE package, 5.4.2.3, 6.13.1, A.1, A.2
default
character set (NLS), 6.3
gateway test, 6.10
port number, 6.2
SID, 6.2
Define COBOL Data Definition dialog box, 6.3, 6.4
delimiters, in data conversion, 7.14.1
Delivery Mode
parameter for message queue profile, 6.5
DEQUEUE
advanced procedure, 7.6.3
and "no messages available" exception, 6.12.2.2
basic procedure, 7.6.2
data conversion package and, 7.11
DEQUEUE_OPTIONS_Typ, 7.7.3, 7.7.3
in the MIP, 7.6
MESSAGE_PROPERTIES_Typ, 7.8
mode, 6.5
naming and name resolution, 7.6.1
procedure, 6.12, 6.12.1, 7.1.1, 7.1.1.2
template, 6.12.1
test, 6.12.2.2
testing
the procedure template, 6.12.2.2
through the gateway, 6.10
Visibility parameter, 6.5
Wait Interval parameter, 6.5
Dequeue Mode
parameter for message queue profile, 6.5
dequeue_options parameter, 7.6.3, 7.7.3
DEQUEUE_OPTIONS_Typ type definition, 7.7.3
DESCRIBE statement, 5.4.1.3, 5.4.1.4
development, overview of process, 6.1
dialog box
Connect, 6.2
Define COBOL Data Definition, 6.3, 6.4
Error Messages, 6.11
Message Interface Package Compiler, 6.11, 6.13.2
Message Interface Package Tester, 6.10, 6.12.2.1, 6.12.2.2
WebSphere MQ Properties, 6.5
directory, script file, 5.4.1.2
DO_DEPOSIT
ENQUEUE DEPOSIT example, 6.12
MIP example, 6.8.2, 6.8.2
duplicate names, in data conversion, 7.14.4

E

EMPLOYEE data profile, 7.1.2
ENQUEUE
advanced procedure, 7.5.3
basic procedure, 7.5.2
data conversion package and, 7.11
DEPOSIT template, 6.12
ENQUEUE_OPTIONS_Typ, 7.7.2, 7.7.2
in the MIP, 7.5
MESSAGE_PROPERTIES_Typ, 7.8
naming and name resolution, 7.5.1
on the General panel, 6.10
procedure, 6.12, 6.12.1, 7.1.1, 7.1.1.2, 7.5.2
procedure, advanced, 7.5.3
sample code example, 6.12.1
sample ENQUEUE DEPOSIT template code, 6.12
template, 6.12.1
testing the ENQUEUE procedure template, 6.12.2.1
testing the procedure template, 6.12.2.1
testing through the gateway, 6.10
Visibility parameter, 6.5
enqueue_operations parameter, 7.5.3
enqueue_options parameter, 7.7.2
ENQUEUE_OPTIONS_Typ type definition, 7.7.2
error
compilation, 6.11
error message
ORA-01000, 2.4.1
ORA-20004, 2.4.3
Error Messages dialog box, 6.11
exceptions
no messages available (DEQUEUE test), 6.12.2.2
PL/SQL, 7.9.1
Expiration
parameter for message queue profile, 6.5

F

file
tnsnames.ora, 6.13.1
file transfer program, 5.4.1.2
FILLER, 7.12.4
format conversion, COBOL, 7.13

G

gateway
testing, 6.10
gateway test code, 6.10
gateway test, default, 6.10
General panel, 6.2
generated code package, 6.8.2
generated code, viewing, 6.8.2
generated package, 6.11
GRANT statement, syntax, 6.13.2.1

H

hardware requirements, 3.1
HIRE interface profile, 7.1.2
host file, 6.2
host name
parameter for connecting, 6.2
HR message queue profile, 7.1.2

I

IBMVSCOBOLII, 6.3
IN parameter, 7.13.1, 7.13.7
initialization parameter
CLOSE_CACHED_OPEN_CURSOR, 2.4.1
input parameter, 7.3, 7.5.3, 7.5.3.2, 7.6.3, 7.6.3.2, 7.8
installation scripts, 5.4.1.2
installing
the repository, 5.4
installing the PG4MQ Visual Workbench client, 5
inter-application messages, 6.5
interface procedures
four in a MIP, 7.1.1
interface profile, 6.1
before you compile the MIP, 6.13.1
compatibility with beta release, 6.8.1
creating, 6.8
generating a MIP, 7.1
HIRE, 7.1.2
introduction, 1.3.1.3
MIP too large, 2.4.3
removing a message queue profile, 6.7
updating a message queue profile, 6.6
invalid parameter, 7.3.1
IP address, in the Host Name field, 6.2

J

JUSTIFIED, 7.13.1
JUSTIFIED LEFT, 7.13.2
JUSTIFIED RIGHT, 7.13.1

K

known problems, 3.2.4

M

mapping
to PL/SQL, 6.3, 6.3, 6.3
maximum open cursors, 2.4.1
message interface package (see MIP)
Message Interface Package Tester dialog box, 6.12.2.2
message queue profile, 6.1
creating, 6.5
HR, 7.1.2
introduction, 1.3.1.2
removing, 6.7
updating, 6.6
UPS, 6.5
message queue properties
Acknowledgment, 6.5
Delivery Mode, 6.5
Dequeue Mode, 6.5
Expiration, 6.5
Message Type, 6.5
Priority, 6.5
Profile Name, 6.5
Queue Name, 6.5
Response Queue, 6.5
Security ID, 6.5
Visibility, 6.5, 6.5
Wait Interval, 6.5
message queuing systems, 1.1
Message Type
parameter for message queue profile, 6.5
message_properties parameter, 7.5.3, 7.6.3
MESSAGE_PROPERTIES_Typ, 7.8
MESSAGE_PROPERTIES_Typ type definition, 7.8
message_type parameter, 7.10.2.1
MIP
adding code to a template, 6.12.1
compiling, 6.11
contains ENQUEUE and DEQUEUE procedures, 7.1.1.2
contents of, 7.1.1
data profile in, 7.1.1
database link, 7.1.1
definition, 7.1
DEQUEUE procedure, 7.6.1
ENQUEUE procedure, 7.5
example, 7.1.2
example, DO_DEPOSIT, 6.8.2, 6.8.2
for correct PL/SQL precision, 2.4.2
generated data mapping package, 6.8.2
generated templates, 6.8.2
generating, 6.8
generating gateway test code, 6.10
incompatible with beta version, 2.2, 6.8.1
introduction
description, 1.3
introduction to generating, 1.3.1.3
message queue profile, 7.1.1
migration considerations, 2.2
overview of PG4MQ Visual Workbench development, 6.1
parameter restrictions (a table), 7.10.2.1
preparing for production, 1.3.1.7, 6.13
procedures, 7.2
testing the gateway for, introduction to, 1.3.1.4
too large, 2.4.3
updating, 6.9
using a template to test, 6.12.2
using the templates, 6.12
using the templates, introduction, 1.3.1.6
msgid parameter, 7.5.3, 7.6.3, 7.10.2.1

N

naming algorithm, PL/SQL, 7.14
national language support
parameter for data profile, 6.3
NLS, see national language support
no messages available, DEQUEUE application, 6.12.2.2
NULL
DEQUEUE procedure action, 7.6.3
ENQUEUE procedure action, 7.5.3
example syntax, 7.1.2, 7.1.2, 7.7.1.1, 7.7.2.1, 7.7.3.1, 7.8.1, 7.11
invalid for "open_mode", 7.7.1.1
invalid for "payload", 7.5.2.1, 7.5.3.1, 7.6.2.1
QOPEN syntax, 7.3.1

O

OCCURS clause, 7.13.3, 7.13.4
open_options parameter, 7.7.1
OPEN_OPTIONS_Typ type definition, 7.7.1
openOpts.open_mode parameter, 7.5.3.2
ORA-01000 error message, 2.4.1
ORA-20004 error message, 2.4.3
Oracle Procedural Gateway for message queuing systems, 1.2
Oracle SID
parameter for connecting, 6.2
ORCL, default SID, 6.2
OUT parameter, 7.13.1, 7.13.7
output parameter, 7.5.1, 7.6.1, 7.6.2.2, 7.6.3.2, 7.8

P

package
data conversion, 6.10, 6.12, 7.11, 7.11, 7.11, 7.13.2, 7.13.3, 7.13.6, 7.14.2, 7.14.4
data mapping, 6.8.2
DBMS_OUTPUT, 5.4.1.4, 5.4.2.3, 6.13.1, A.1, A.2
DBMS_PIPE, 5.4.2.3, 6.13.1, A.1, A.2
generated, 6.11
generated code, 6.8.2
PGM_BQM, 5.4.2.5, 6.13.1, 7.9, 7.10.2, A.1, A.2
PGM_SUP, 5.4.2.5, 6.13.1, 7.10.1, A.1, A.2
PL/SQL, 1.3.1.3, 2.4.2, 6.13.1, 7.1, 7.11, A.1, A.2, A.3
test code, 6.13.3
UTL_PG, 5.4.2.4, 6.13.1, A.1, A.2
UTL_RAW, 5.4.1.3, 5.4.2.3, 6.13.1, A.1, A.2
panel
General, 6.2
parameter
Acknowledgment, 6.5, 6.5
COBOL copybook file, 6.3
correlation, 7.10.2.1
Data Definition Name, 6.3
data length, 7.13.5
Delivery Mode, 6.5
Dequeue Mode, 6.5
dequeue_options, 7.6.3, 7.7.3
enqueue_operations, 7.5.3
enqueue_options, 7.7.2
Expiration, 6.5
host name, 6.2
if NULL, 7.5.3, 7.6.3
IN, 7.13.1, 7.13.7
initialization, CLOSE_CACHED_OPEN_CURSOR, 2.4.1
input, 7.3, 7.5.3, 7.5.3.2, 7.6.3, 7.6.3.2, 7.8
invalid, 7.3.1
Message Type, 6.5
message_properties, 7.5.3, 7.6.3
message_type, 7.10.2.1
MIP restrictions (a table), 7.10.2.1
msgid, 7.5.3, 7.6.3, 7.10.2.1
national language support, 6.3
open_options, 7.7.1
openOpts.open_mode, 7.5.3.2
Oracle SID, 6.2
OUT, 7.13.1, 7.13.7
output, 7.5.1, 7.6.1, 7.6.2.2, 7.6.3.2, 7.8
password, 6.2
payload, 7.5.1, 7.6.1, 7.6.3
port number, 6.2
Priority, 6.5
priority, 7.10.2.1
Profile Name, 6.5
Queue Name, 6.5
queue_name, 7.5.3, 7.6.3, 7.10.2.1
Response Queue, 6.5, 6.5
response_queue, 7.10.2.1
Security ID, 6.5
security_id, 7.10.2.1
to control sending and receiving messages, 7.1.1.2
user name, 6.2
Visibility, 6.5, 6.5
visibility, 7.7.3.1
Wait Interval, 6.5
password, parameter for connecting, 6.2
payload parameter, 7.5.1, 7.6.1, 7.6.3
PG4MQ Visual Workbench
components, 1.3
development environment, 3.2.1
development privileges for repository, 5.4.3
installing the client, 5
installing the repository, 5.4
overview of development process, 6.1
remove repository, 5.4.4
repository, 1.3.2
repository directory tree, 6.2
starting, 6.2
uses, 1.3.1
window, 6.2
PG4MQ Visual Workbench Wizard, 6.1, 6.8
PGM_BQM package, 5.4.2.5, 6.13.1, 7.9, 7.10.2, A.1, A.2
PGM_SUP package, 5.4.2.5, 6.13.1, 7.10.1, 7.10.1, A.1, A.2
pgm8.sql, A.2
PGMADMIN, 5.4.2.5, 5.4.4.1, 6.2
pgmbqm8.sql script, A.2
pgmdeploy9.sql script, A.1
PGMDEV role, 5.4.3
pgmsup8.sql script, A.2
pgmundeploy9.sql script, A.1
pgvwbremove.sql script, 5.4.4
pgvwbrepos.sql script, 5.4.2, 5.4.3
PIC 9, 7.12.3
PIC G, 7.12.2
PIC X, 7.12.1
PL/SQL
Code, 6.8.2
code, 6.11
code panel, 6.12
data conversion package, 7.11
incorrect precision of types, 2.4.2
installing missing packages, A.1
interface, 6.8
mapping, 6.3, 6.3, 6.3, 6.3
MIP in a PL/SQL program, 6.12
naming algorithm, 7.14
delimiters, 7.14.1
duplicate names, 7.14.4
qualified compound names, 7.14.2
truncated and non-unique names, 7.14.3
package, 1.3.1.3, 2.4.2, 6.13.1, 7.1, 7.11, A.1, A.2, A.3
packages required for data conversion, 7.11
removing packages, A.3
verifying packages exist, A.1
port number
default, 6.2
parameter for connecting, 6.2
priority parameter, 7.10.2.1
priority, parameter for message queue profile, 6.5
private access privileges, 5.4.2.6
private repository, 5.4.4.2
privileges, private access, 5.4.2.6
privileges, public access, 5.4.2.6
problems, incorrect precision of PL/SQL types, 2.4.2
procedural gateway
database link for access, 5.4.1.6
procedure
DEQUEUE, 6.12, 6.12.1, 7.1.1, 7.1.1.2
ENQUEUE, 6.12, 6.12.1, 7.1.1, 7.1.1.2, 7.5.2
ENQUEUE, advanced, 7.5.3
QCLOSE, 7.1.1, 7.4
QOPEN, 7.1.1, 7.3
production
introduction to preparing the MIP for production, 1.3.1.7
preparing the MIP for production, 6.13
profile
data, for message exchange, 6.1
HR, 7.1.2
interface, 6.1
message queue, 6.1
Profile Name
parameter for message queue profile, 6.5
program
file transfer, 5.4.1.2
prvtpg.sql script, A.2
prvtrawb.plb script, 5.4.1.3
public access privileges, 5.4.2.6

Q

QCLOSE
close an open queue, 7.1.1.1
procedure, 7.1.1, 7.4
syntax, 7.4.1
QOPEN
open a specified queue, 7.1.1.1
procedure, 7.1.1, 7.3
syntax, 7.3.1
qualified compound names, in data conversion, 7.14.2
Queue Name
parameter for message queue profile, 6.5
queue_name parameter, 7.5.3, 7.6.3, 7.10.2.1

R

remove
the PG4MQ Visual Workbench repository, 5.4.4
removing a data profile, 6.4.1
removing a message queue profile, 6.7
RENAMES clause, 7.13.5, 7.13.6
repository
and compiling, 6.11
choosing a server, 5.4.1.1
connecting to, 6.2
development privileges, 5.4.3
directory tree, PG4MQ Visual Workbench, 6.2
installation scripts, 5.4.1.2
installing, 5.4
installing the repository, 5.4
PG4MQ Visual Workbench, 1.3.2
private, 5.4.4.2
remove, 5.4.4
server, definition, 5.4.1.1
requirements
hardware, 3.1
software, 3.2
Response Queue
parameter for acknowledgment message, 6.5
parameter for message queue profile, 6.5
response_queue parameter, 7.10.2.1
role
PGMDEV, 5.4.3

S

sample copybook files, 6.3
script
file directory, 5.4.1.2
pgmbqm8.sql, A.2
pgmdeploy9.sql, A.1
pgmsup8.sql, A.2
pgmundeploy9.sql, A.1
pgvwbremove.sql, 5.4.4
pgvwbrepos.sql, 5.4.2, 5.4.3
prvtpg.sql, A.2
prvtrawb.plb, 5.4.1.3
utlpg.sql, A.2
utlraw.sql, 5.4.1.3
Security ID
parameter for message queue profile, 6.5
security_id parameter, 7.10.2.1
SID
(system identifier) parameter, 6.2
default, 6.2
software requirements, 3.2
starting the PG4MQ Visual Workbench, 6.2
statement
DESCRIBE, 5.4.1.3, 5.4.1.4
GRANT, 6.13.2.1
SYNCHRONIZED, 7.13.7
SYNCHRONIZED LEFT, 7.13.8
SYNCHRONIZED RIGHT, 7.13.7
system identifier (SID) parameter, 6.2

T

template
adding code to, 6.12.1
MIP, 6.8.2
testing the DEQUEUE, 6.12.2.2
testing the ENQUEUE, 6.12.2.1
using the MIP, 6.12
using the MIP, introduction, 1.3.1.6
using to test the MIP, 6.12.2
template code, 6.8.2
to test the MIP, 6.11
test code package, 6.13.3
testing
introduction to testing the gateway for a MIP, 1.3.1.4
testing the gateway for a MIP, 6.10
tnsnames.ora file, 6.13.1
truncated and non-unique names
in data conversion, 7.14.3
type definition
an introduction, 7.7
DEQUEUE_OPTIONS_Typ, 7.7.3
ENQUEUE_OPTIONS_Typ, 7.7.2
MESSAGE_PROPERTIES_Typ, 7.8
OPEN_OPTIONS_Typ, 7.7.1

U

updating
data profile, 6.4
message queue profile, 6.6
MIP, 6.9
UPS
message queue profile, 6.5
user name, parameter for connecting, 6.2
UTL_PG package, 5.4.2.4, 6.13.1, 7.11, A.1, A.2
UTL_RAW package, 5.4.1.3, 5.4.2.3, 6.13.1, 7.11, A.1, A.2
utlpg.sql script, A.2
utlraw.sql script, 5.4.1.3

V

viewing the generated code, 6.8.2
Visibility
DEQUEUE parameter for message queue profile, 6.5
ENQUEUE parameter for message queue profile, 6.5
visibility parameter, 7.7.3.1

W

Wait Interval
and "no messages available" exception (DEQUEUE test), 6.12.2.2
parameter for message queue profile, 6.5
WebSphere MQ
using the MIP for, 7.10.1
WebSphere MQ Properties dialog box, 6.5
Wizard
PG4MQ Visual Workbench, 6.1, 6.8