#!/usr/bin/sh
##
## Copyright (c) 2004
## Sybase, Inc
## Dublin, CA 94568
## All Rights Reserved
##
if [ $# != 2 ]
	then echo "print_global_variables ASE, DBNAME"
	exit
fi

#
##	$1	-> ASE
##	$2	-> DBNAME holding stored procedure examples
#
echo " "
echo " "
echo " "

echo " "
echo " "
echo "		=========================================== "
echo "		Example to send a single message to a queue"
echo "		=========================================== "
echo " "
echo " "
isql -UUsrMsg -PUsrMsg_Pwd -S$1 -D$2 << EOF
set nocount on
go
set proc_return_status off
go
QueueSender "tibco_jms_dev","queue.sample","sample_user", "sample_pwd", "Sending message to a queue and printing global variables"
go
select "Message Id" = rtrim(@@msgid)
select "Message Header " = rtrim(@@msgheader)
select "Message Properties " = rtrim(@@msgproperties)
select "Message Timestamp " = rtrim(@@msgtimestamp)
select "Message Status " = @@msgstatus
select "Reply to Topic information" = rtrim(@@msgreplytoinfo)
select "Message Schema " = rtrim(@@msgschema)
go
EOF


echo " "
echo " "
echo " "
echo ".... Use consume_from_queue to retrive the message...."
echo " "
echo " "
echo " "
