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