Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to Oracle Database Gateway for WebSphere MQ
- 1.1 Introduction to Message Queuing
- 1.2 Introduction to WebSphere MQ
- 1.3 Introduction to the Gateway
- 2 Release Information for Oracle Database Gateway for WebSphere MQ
- 3 System Requirements for Oracle Database Gateway for WebSphere MQ
- 4 Preinstallation Information for Oracle Database Gateway for WebSphere MQ
- 5 Installing Oracle Database Gateway for WebSphere MQ
- 6 Removing Oracle Database Gateway for WebSphere MQ
-
7
Configuring Oracle Database Gateway for WebSphere MQ
- 7.1 Configuration Overview
- 7.2 Configuring the Gateway
- 7.3 Configuring Oracle Net for the Gateway
- 7.4 Configuring Oracle Net for Oracle Database
- 7.5 Creating a Transaction Log Queue
- 7.6 Administering the Database Links Alias Library
-
7.7
Installing the Oracle Visual Workbench Repository
-
7.7.1
Preinstallation Tasks
- 7.7.1.1 Step 1: Choose a Repository Server
- 7.7.1.2 Step 2: Locate the Installation Scripts
- 7.7.1.3 Step 3: Upgrade the Visual Workbench Repository
- 7.7.1.4 Step 4: Ensure that the UTL_RAW Package is Installed
- 7.7.1.5 Step 5: Ensure that the DBMS_OUTPUT Package is Enabled
- 7.7.1.6 Step 6: Create a Database Link
-
7.7.2
Visual Workbench Repository Installation Tasks
- 7.7.2.1 Step 1: Enter the Database Connection Information
- 7.7.2.2 Step 2: Check for Existing Workbench Repository
- 7.7.2.3 Step 3: Check for The Required PL/SQL Packages
- 7.7.2.4 Step 4: Install the UTL_PG Package
- 7.7.2.5 Step 5: Create the Administrative User and All Repository Tables
- 7.7.2.6 Step 6: Create Public Synonyms and Development Roles
- 7.7.3 After the Repository is Created
- 7.7.4 Deinstall the Visual Workbench Repository
-
7.7.1
Preinstallation Tasks
- 7.8 Preparing the Production Oracle Database
- 8 Oracle Database Gateway for WebSphere MQ Running Environment
-
A
The PGM, PGM_UTL8, and PGM_SUP Packages
- A.1 PGM Package, DG4MQ Gateway Procedures, and Data Type Definitions
- A.2 MQCLOSE Procedure
- A.3 MQGET Procedure
- A.4 MQOPEN Procedure
- A.5 MQPUT Procedure
-
A.6
PGM_SUP Package
- A.6.1 PGM.MQGMO Values
-
A.6.2
PGM.MQMD Values
- A.6.2.1 CODEDCHARSETID Field
- A.6.2.2 ENCODING Field
- A.6.2.3 ENCODING Field, Values for Binary Integers
- A.6.2.4 ENCODING Field, Values for Floating Point Numbers
- A.6.2.5 ENCODING Field, Mask Values
- A.6.2.6 ENCODING Field, Values for Packed Decimal Integers
- A.6.2.7 EXPIRY Field
- A.6.2.8 FEEDBACK Field
- A.6.2.9 FORMAT Field
- A.6.2.10 MSGTYPE Field
- A.6.2.11 PERSISTENCE Field
- A.6.2.12 PRIORITY Field
- A.6.2.13 PUTAPPLTYPE Field
- A.6.2.14 REPORT Field
- A.6.2.15 VERSION Field
- A.6.2.16 Report Field, Mask Values
- A.6.3 PGM.MQOD Values
- A.6.4 PGM.MQPMO Values
- A.6.5 MQCLOSE Values
- A.6.6 MQOPEN Values
- A.6.7 Maximum Lengths for Fields of PGM Type Definitions
- A.6.8 Error Code Definitions
-
B
UTL_RAW Package
- B.1 Message Data Types
-
B.2
UTL_RAW Functions
- B.2.1 UTL_RAW.TO_RAW
- B.2.2 UTL_RAW.BIT_AND
- B.2.3 UTL_RAW.BIT_COMPLEMENT
- B.2.4 UTL_RAW.BIT_OR
- B.2.5 UTL_RAW.BIT_XOR
- B.2.6 UTL_RAW.CAST_TO_RAW
- B.2.7 UTL_RAW.CAST_TO_VARCHAR2
- B.2.8 UTL_RAW.COMPARE
- B.2.9 UTL_RAW.CONCAT
- B.2.10 UTL_RAW.CONVERT
- B.2.11 UTL_RAW.COPIES
- B.2.12 UTL_RAW.LENGTH
- B.2.13 UTL_RAW.OVERLAY
- B.2.14 UTL_RAW.REVERSE
- B.2.15 UTL_RAW.SUBSTR
- B.2.16 UTL_RAW.TRANSLATE
- B.2.17 UTL_RAW.TRANSLITERATE
- B.2.18 UTL_RAW.XRANGE
- C Oracle Database Gateway for WebSphere MQ Initialization Parameters
- Index