#!/usr/bin/sh
##
## Copyright (c) 2004
## Sybase, Inc
## Dublin, CA 94568
## All Rights Reserved
##
if [ $# != 2 ]
	then echo "send_in_transaction_full 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 "		using transactional behaviour to NONE"
echo "		========================================== "
echo " "
echo " "
isql -UUsrMsg -PUsrMsg_Pwd -S$1 -D$2 << EOF
set nocount on
set proc_return_status off
go
truncate table t1
go
set transactional messaging NONE
go
print " "
print " "
print " "
print "Start a New Transaction"
print " "
print " "
print " "
go
begin transaction none_1
go
insert t1 values (200,"Transactional Behaviour Full, all correct")
go
print " "
print " "
print " "
print "Transaction count after insert '%1!'", @@trancount
print "==================================="
print " "
print " "
print " "
go
exec QueueSender "tibco_jms_dev","queue.sample","sample_user", "sample_pwd", "Sending message to a queue with transactional messaging set to NONE"
go
print " "
print " "
print " "
print "Transaction count after sending message '%1!'", @@trancount
print "============================================"
print " "
print " "
print " "
go
commit transaction
go
print " "
print " "
print " "
print "Start a New Transaction. Sending message to provider will fail"
print " "
print " "
print " "
go
begin transaction none_2
go
insert t1 values (300,"Transactional Behaviour Full, msgsend() will fail")
go
print " "
print " "
print " "
print "Transaction count after insert '%1!'", @@trancount
print "==================================="
print " "
print " "
print " "
go
exec QueueSender "tibco_jms_dev","queue.sample","sample_user", "sample_pwd", "Sending message to a queue with transactional messaging set to NONE"
go
print " "
print " "
print " "
print "Transaction count after insert '%1!'", @@trancount
print "==================================="
print " "
print " "
print " "
go
if @@trancount = 0
begin
	print " "
	print " "
	print " "
	print "============================"
	print "Transaction has been aborted"
	print "============================"
	print " "
	print " "
	print " "
end
else
begin
	print " "
	print " "
	print " "
	print "============================"
	print "Transaction has been aborted"
	print "============================"
	print " "
	print " "
	print " "
	commit transaction
end
go
EOF


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