Receiving a Message from a WebSphere MQ Queue

Sybase WorkSpace enables you to receive a message from a specified end point in an WebSphere MQ queue. This message can be defined in a stored procedure or trigger.

Prerequisites

To receive a message from a WebSphere MQ queue, you must have IBM WebSphere MQ running and an open Adaptive Server Enterprise connection profile with Real-Time Messaging configured. A message receiver/queue must be available in the WebSphere MQ server to serve as the endpoint, or destination, for the received message.

From Enterprise Explorer, find the ASE connection profile.

Select the procedural object for which you want to add messaging syntax.

Procedural Object	How to select
Stored procedure	Expand the Stored Procedures folder, right-click the procedure, and select Edit.
Trigger	Expand the Tables folder, expand the table, and then the Triggers folder. Right-click the trigger and select Edit.

In the Source page, place the cursor in the desired location within the SQL code, right-click and select Sybase_ASE_15.x > Real-time Messaging Wizard .
You can also open the wizard from the icon on the toolbar.
Select Queue-related Functions (MQSeries) > Receive a Message, and click Next.

Specify an ASE JMS provider name, and provide endpoint information.

Field	Description
Host Name	Endpoint host name
Port	Endpoint port number
Queue Manager	Endpoint queue manager
Remote Queue Manager	Remote queue manager
Client Channel	Endpoint client channel
Queue	Endpoint queue

Click Next to specify message options.
Enter the message options.

Tab Description

Options Choose a message type and enter a value in the Values field.

Return Datatype Choose a return datatype.
Click Finish.
Note: Because ASE messaging constructs are functions, select appears before the messaging construct. You can also assign the messaging function to a local variable that has already been declared.

Tab	Description
Options	Choose a message type and enter a value in the Values field.
Return Datatype	Choose a return datatype.