msgconsume

Description

EAServer JMS only – provides a SQL interface to consume messages that are published to different topics.

Syntax

msgconsume_call ::=
	msgconsume (subscription_name, option_and_returns)
		subscription_name:= basic_character_expression
		option_and_returns ::= [option_clause] [returns_clause]
			option_clause::= [,] option option_string
			returns_clause ::= [,] returns sql_type
				subscriber_name ::= basic_character_expression
				sql_type ::= 
					varchar(integer) | java.lang.String | text)
					| varbinary(integer) | image

Parameters

Examples

Example 1

Defines a subscription on the client server, before consuming a message:

sp_msgadmin 'register', 'subscription', 'subscription_1',
     'my_jms_provider?topic=topic.sample,user=user1,password=pwd',
     'Supplier=12345',null,'durable1', 'client1'

Before consuming messages from a subscription, Sybase recommends that the subscription be subscribed:

select msgsubscribe('subscription_1')
declare @mymsg varchar(16384)
select @mymsg = msgconsume('subscription_1')

Example 2

Declares variables and receives a message from the specified subscription:

declare @mymsg varchar (16384)	
select @mymsg = msgconsume('subscription_1', 
     option 'timeout=0')

Forwards a message:

select msgsend
     (msgconsume('subscription_1'), 'my_jms_provider?queue=queue.sample')

Reads a message and returns it as a varbinary:

select msgconsume('subscription_1' returns varbinary(500))

Usage