Sending a Message to a WebSphere MQ Queue

Sybase WorkSpace enables you to send a message to a specified endpoint in a WebSphere MQ queue. This message can be defined in a stored procedure or trigger.

1. For the appropriate ASE connection profile and database, select the appropriate procedural object.

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

2. 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 ASE Real-Time Messaging Wizard icon on the toolbar.

3. Select Queue-Related Functions (MQSeries) > Send a Message , and click Next.
4. Specify an ASE JMS provider, and provide endpoint information.

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

5. Click Next.
6. In the Specify Message Body dialog, select one of the following:

   Option	Action
   Variable	Select a local variable or parameter before the current cursor position. The selected variable or parameter becomes the message body in the current stored procedural object definition.
   Text	Enter the message text, or use Browse to locate a text file for the message body.
   Bytes	Enter the message body in hexadecimal format. You can also use Browse to locate a hexadecimal file that you can copy into the message body.
   Select Statement	Select SQL... to invoke the Visual SQL dialog.

7. Click Next to specify message options.

   Tab	Description
   Options	Contains the default JMS options: Message Type – select Text or Bytes. Message Schema – use User-Defined Schema to activate the User-Defined Schema frame. Use Browse to locate the XML schema file.
   Properties	Customize JMS system properties: mode, priority, correlation, reply queue, reply topic, and time-to-live. Sybase provides default values that you can change. The Correlation field remains dimmed unless you select it.
   User-Defined Properties	Click Add. Enter the name and value of the property you want to add. (Optional) Select String Type. Click OK.

8. 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.