Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

Message Queuing Systems

The Oracle Procedural Gateway for Message Queuing Systems

The Visual Workbench Development Environment

The Visual Workbench

Creating Data Profiles

Creating Message Queue Profiles

Creating Interface Profiles and Generating the MIP

Testing the Gateway

Compiling the MIP

Using the MIP Templates

Preparing the MIP for Production

The Visual Workbench Repository

2 Release Information

Product Set

Migration Considerations

Changes and Enhancements, Release 9.0.1.1.1

Enhancements

Accessing Release 9.0.1.1.1 and all prior releases of PG4MQ Visual Workbench Repositories.

Known Problems

Maximum Open Cursors

Incorrect Precision of PL/SQL Datatypes

The MIP Is Too Large

3 Requirements

Hardware Requirements

Processor

Memory

CD-ROM Drive

Disk Space

Software Requirements

Visual Workbench Components

Operating System

Oracle Procedural Gateway

Oracle Server

File Transfer

4 Pre-installation

Pre-installation Tasks

About Oracle Universal Installer

5 Installation

Installation

Starting the Oracle Universal Installer

Installing Oracle9i PG4MQ Visual Workbench step by step

Deinstallation

To deinstall Oracle9i PG4MQ Visual Workbench with Oracle Universal Installer:

Starting the Oracle Universal Installer

Visual Workbench Installation Complete

Installing the Visual Workbench Repository

Preinstallation Tasks

Step 1: Choose a repository server

Step 2: Locate the installation scripts

Step 3: Ensure the UTL_RAW package is installed

Step 4: Ensure the DBMS_OUTPUT package is enabled

Step 5: Ensure that the caths.sql script has been run

Step 6: Create a database link

Visual Workbench Repository Installation Tasks

Step 1: Enter the database connection information

Step 2: Check for existing Workbench Repository

Step 3: Check for required PL/SQL packages

Step 4: Install the UTL_PG package

Step 5: Create the admin user and all repository tables

Step 6: Create public synonyms and development roles

After the Repository is Created

Deinstall the Visual Workbench Repository

Step 1: Enter the database connection information

Step 2: Check for existing Workbench repository

6 Using the Visual Workbench

Overview of Visual Workbench Development

Starting the Visual Workbench and Connecting to a Repository

Creating a Data Profile

Updating a Data Profile

Removing a Data Profile

Creating a Message Queue Profile

Updating a Message Queue Profile

Removing a Message Queue Profile

Creating an Interface Profile and Generating a MIP

Viewing the Generated Code

Updating a MIP

Testing the Gateway

Compiling the MIP

Using the MIP Templates

Completing the Templates

Using a Template to Test the MIP

Testing the ENQUEUE Procedure Template

Testing the DEQUEUE Procedure Template

Preparing the MIP for Production

Before You Compile the MIP on the Production Oracle Server

Compiling the MIP for the Production Oracle Server

Granting Execution Privileges to a MIP

Testing the MIP on a Production System

7 Using the Generated MIP

About the Message Interface Package (MIP)

What's in a MIP?

QOPEN and QCLOSE

ENQUEUE and DEQUEUE

MIP Specification Example

The MIP Procedures

The QOPEN Procedure

The QCLOSE Procedure

The ENQUEUE Procedure

ENQUEUE Naming and Name Resolution

Basic ENQUEUE Procedure

Advanced ENQUEUE Procedure

The DEQUEUE Procedure

DEQUEUE Naming and Name Resolution

Basic DEQUEUE Procedure

Advanced DEQUEUE Procedure

Type Definitions

OPEN_OPTIONS_Typ

ENQUEUE_OPTIONS_Typ

DEQUEUE_OPTIONS_Typ

MESSAGE_PROPERTIES_Typ

The PGM_BQM Package

Exceptions

Naming

Using the MIP for IBM MQSeries

The PGM_SUP Package

Exceptions

MIP Restrictions

The Data Conversion Package

COBOL Datatype Conversion

PIC X

PIC G

PIC 9

FILLER

COBOL Format Conversion

JUSTIFIED and JUSTIFIED RIGHT

JUSTIFIED LEFT

OCCURS n TIMES

OCCURS m TO n TIMES DEPENDING ON field-2

RENAMES item-2 THRU item-3

RENAMES item-2 WHEN item-3=value

SYNCHRONIZED and SYNCHRONIZED RIGHT

SYNCHRONIZED LEFT

PL/SQL Naming Algorithm

Delimiters

Qualified Compound Names

Truncated and Non-Unique Names

Duplicate Names

A Preparing the Production Oracle Server

Introduction

Verifying and Installing PL/SQL Packages

Removing the PL/SQL Packages

Index