Contents

List of Examples

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Product Name
• Related Documents
• Conventions

1 Introduction

• 1.1 Message Queuing Systems
• 1.2 The Oracle Procedural Gateway for Message Queuing Systems
• 1.3 The PG4MQ Visual Workbench Development Environment
• • 1.3.1 The PG4MQ Visual Workbench
  • • 1.3.1.1 Creating Data Profiles
    • 1.3.1.2 Creating Message Queue Profiles
    • 1.3.1.3 Creating Interface Profiles and Generating the MIP
    • 1.3.1.4 Testing the Gateway
    • 1.3.1.5 Compiling the MIP
    • 1.3.1.6 Using the MIP Templates
    • 1.3.1.7 Preparing the MIP for Production
  • 1.3.2 The PG4MQ Visual Workbench Repository

2 Release Information

• 2.1 Product Set
• 2.2 Migration Considerations
• 2.3 Changes and Enhancements, Release 10.2.0.1.0
• • 2.3.1 Accessing release 10.2.0.1.0 and all earlier releases of PG4MQ Visual Workbench Repositories.
• 2.4 Known Problems
• • 2.4.1 Maximum Open Cursors
  • 2.4.2 Incorrect Precision of PL/SQL Data Types
  • 2.4.3 The MIP Is Too Large

3 Requirements

• 3.1 Hardware Requirements
• • 3.1.1 Processor
  • 3.1.2 Memory
  • 3.1.3 Disk Space
• 3.2 Software Requirements
• • 3.2.1 PG4MQ Visual Workbench Components
  • 3.2.2 Operating System
  • 3.2.3 Oracle Procedural Gateway
  • 3.2.4 Oracle Server
  • 3.2.5 File Transfer

4 Preinstallation

• 4.1 Preinstallation Tasks
• 4.2 About Oracle Universal Installer

5 Installation

• 5.1 Installation
• • 5.1.1 Starting the Oracle Universal Installer
  • 5.1.2 Installing Oracle Procedural Gateway Visual Workbench for WebSphere MQ
• 5.2 Removing the Software
• • 5.2.1 Removing Oracle Procedural Gateway Visual Workbench for WebSphere MQ using Oracle Universal Installer:
  • • 5.2.1.1 Starting the Oracle Universal Installer
• 5.3 Visual Workbench Installation Complete
• 5.4 Installing the Visual Workbench Repository
• • 5.4.1 Preinstallation Tasks
  • • 5.4.1.1 Step 1: Choose a repository server
    • 5.4.1.2 Step 2: Locate the installation scripts
    • 5.4.1.3 Step 3: Ensure that the UTL_RAW package is installed
    • 5.4.1.4 Step 4: Ensure that the DBMS_OUTPUT package is enabled
    • 5.4.1.5 Step 5: Ensure that the caths.sql script has been run
    • 5.4.1.6 Step 6: Create a database link
  • 5.4.2 Visual Workbench Repository Installation Tasks
  • • 5.4.2.1 Step 1: Enter the database connection information
    • 5.4.2.2 Step 2: Check for existing Workbench Repository
    • 5.4.2.3 Step 3: Check for required PL/SQL packages
    • 5.4.2.4 Step 4: Install the UTL_PG package
    • 5.4.2.5 Step 5: Create the admin user and all repository tables
    • 5.4.2.6 Step 6: Create public synonyms and development roles
  • 5.4.3 After the Repository Is Created
  • 5.4.4 Remove the Visual Workbench Repository
  • • 5.4.4.1 Step 1: Enter the database connection information
    • 5.4.4.2 Step 2: Check for existing Workbench repository

6 Using the Oracle Procedural Gateway Visual Workbench for WebSphere MQ

• 6.1 Overview of PG4MQ Visual Workbench Development
• 6.2 Starting the PG4MQ Visual Workbench and Connecting to a Repository
• 6.3 Creating a Data Profile
• 6.4 Updating a Data Profile
• • 6.4.1 Removing a Data Profile
• 6.5 Creating a Message Queue Profile
• 6.6 Updating a Message Queue Profile
• 6.7 Removing a Message Queue Profile
• 6.8 Creating an Interface Profile and Generating a MIP
• • 6.8.1 Alternative method for starting the Wizard to create an interface
  • 6.8.2 Viewing the Generated Code
• 6.9 Updating a MIP
• • 6.9.1 Alternative method for starting the Wizard to update an interface
• 6.10 Testing the Gateway
• 6.11 Compiling the MIP
• 6.12 Using the MIP Templates
• • 6.12.1 Completing the Templates
  • 6.12.2 Using a Template to Test the MIP
  • • 6.12.2.1 Testing the ENQUEUE Procedure Template
    • 6.12.2.2 Testing the DEQUEUE Procedure Template
• 6.13 Preparing the MIP for Production
• • 6.13.1 Before You Compile the MIP on the Production Oracle Server
  • 6.13.2 Compiling the MIP for the Production Oracle Server
  • • 6.13.2.1 Granting Execution Privileges to a MIP
  • 6.13.3 Testing the MIP on a Production System

7 Using the Generated MIP

• 7.1 About the Message Interface Package (MIP)
• • 7.1.1 What's in a MIP?
  • • 7.1.1.1 QOPEN and QCLOSE
    • 7.1.1.2 ENQUEUE and DEQUEUE
  • 7.1.2 MIP Specification Example
• 7.2 MIP Procedures
• 7.3 QOPEN Procedure
• • 7.3.1 QOPEN Syntax
• 7.4 QCLOSE Procedure
• • 7.4.1 QCLOSE Syntax
• 7.5 ENQUEUE Procedure
• • 7.5.1 ENQUEUE Naming and Name Resolution
  • 7.5.2 Basic ENQUEUE Procedure
  • • 7.5.2.1 Syntax
    • 7.5.2.2 Example
  • 7.5.3 Advanced ENQUEUE Procedure
  • • 7.5.3.1 Syntax
    • 7.5.3.2 Example
• 7.6 DEQUEUE Procedure
• • 7.6.1 DEQUEUE Naming and Name Resolution
  • 7.6.2 Basic DEQUEUE Procedure
  • • 7.6.2.1 Syntax
    • 7.6.2.2 Example
  • 7.6.3 Advanced DEQUEUE Procedure
  • • 7.6.3.1 Syntax
    • 7.6.3.2 Example
• 7.7 Type Definitions
• • 7.7.1 OPEN_OPTIONS_Typ
  • • 7.7.1.1 Syntax
  • 7.7.2 ENQUEUE_OPTIONS_Typ
  • • 7.7.2.1 Syntax
  • 7.7.3 DEQUEUE_OPTIONS_Typ
  • • 7.7.3.1 Syntax
• 7.8 MESSAGE_PROPERTIES_Typ
• • 7.8.1 Syntax
• 7.9 PGM_BQM Package
• • 7.9.1 Exceptions
  • 7.9.2 Naming
• 7.10 Using the MIP for WebSphere MQ
• • 7.10.1 PGM_SUP Package
  • 7.10.2 Exceptions
  • • 7.10.2.1 MIP Restrictions
• 7.11 Data Conversion Package
• 7.12 COBOL Data Type Conversion
• • 7.12.1 PIC X
  • 7.12.2 PIC G
  • 7.12.3 PIC 9
  • 7.12.4 FILLER
• 7.13 COBOL Format Conversion
• • 7.13.1 JUSTIFIED and JUSTIFIED RIGHT
  • 7.13.2 JUSTIFIED LEFT
  • 7.13.3 OCCURS n TIMES
  • 7.13.4 OCCURS m TO n TIMES DEPENDING ON field-2
  • 7.13.5 RENAMES item-2 THRU item-3
  • 7.13.6 RENAMES item-2 WHEN item-3=value
  • 7.13.7 SYNCHRONIZED and SYNCHRONIZED RIGHT
  • 7.13.8 SYNCHRONIZED LEFT
• 7.14 PL/SQL Naming Algorithm
• • 7.14.1 Delimiters
  • 7.14.2 Qualified Compound Names
  • 7.14.3 Truncated and Non-Unique Names
  • 7.14.4 Duplicate Names

A Preparing the Production Oracle Server

• A.1 Introduction
• A.2 Verifying and Installing PL/SQL Packages
• A.3 Removing the PL/SQL Packages

Index