#!/usr/bin/sh
##
## Copyright (c) 2004
## Sybase, Inc
## Dublin, CA 94568
## All Rights Reserved
##
if [ $# != 4 ]
	then echo "full_subscription_sample ASE_1, DBNAME_1, ASE_2, DBNAME_2"
	exit
fi

#
##	$1	-> ASE
##	$2	-> DBNAME holding stored procedure examples
##	$3	-> ASE
##	$4	-> DBNAME holding stored procedure examples
#
echo " "
echo " "
echo "		========================================== "
echo "		Full example for subscription messages "
echo "		========================================== "
echo " "
echo " "
isql -UUsrMsg -PUsrMsg_Pwd -S$1 -D$2 << EOF
set proc_return_status off
go
set nocount on
go
print "Removing subscription sub1"
exec sp_msgadmin 'remove','subscription','sub1'
go
/*
** First register the subscription on the ASE acting as a publisher
*/
print "Registering subscription sub1"
go
sp_msgadmin 'register', 'subscription','sub1',
"tibco_jms_dev?topic=topic.sample,user=sample_user,password=pwd"
go
EOF

isql -UUsrMsg -PUsrMsg_Pwd -S$3 -D$4 << EOF
set proc_return_status off
go
set nocount on
go
print "Removing subscription sub1"
exec sp_msgadmin "remove", "subscription", "sub1"
go
/*
** First register the subscription on the ASE acting as a consumer
*/
print "Registering subscription sub1"
go
sp_msgadmin "register", "subscription","sub1",
  "tibco_jms_dev?topic=topic.sample,user=sample_user,password=pwd",
  "Supplier=12345",null,"durable1","client1"
go
EOF



isql -UUsrMsg -PUsrMsg_Pwd -S$1 -D$2 << EOF
set proc_return_status off
go
set nocount on
go
/*
** Client will publish a message to the specific subscription
*/
print "Publishing message to subscription sub1"
go
PublishToSubscription "sub1",
		"Publishing message to subscription sub1",
		null,
		"Supplier=12345"
go
EOF

isql -UUsrMsg -PUsrMsg_Pwd -S$3 -D$4 << EOF
set proc_return_status off
go
set nocount on
go
/*
** Client wants to consume the message published to sub1 with specific selector
*/
print "Consuming messages from subscription sub1"
go
ConsumeFromSubscription "sub1"
go

EOF
