|
xa_bqual()
The
system function
xa_bqual() returns the
"branch qualifier"
component of a
ASCII
transaction id
in binary format.
This is required if an external
transaction
in
ASE
is blocked in a system with
distributed transactions.
The blocking transaction can be identified using the
stored procedures
sp_lock
and
sp_transaction
and eventually termniated using the
"XA Transaction Manager".
But the stored procedures sp_lock and sp_transaction
only return the value of the
xactname
in ASCII format, whereas the "XA Transaction Manager" expects
a value in binary format.
So the function xa_bqual can be used to determine the
respective
branch qualifier of a transaction in the right format
for the "XA Transaction Manager".
The return value of the function xa_bqual can be
NULL,
if the transaction id cannot be decoded,
or if it is specified in an invalid format.
xa_bqual is often used in connection with the function
xa_gtrid().
The function is a
T-SQL
extension. It can be executed by any
User.
Syntax of the System Function xa_bqual()
The parameters of the System Function xa_bqual()
"xid"
The parameter "xid" is the identification number (id)
of a
ASE
transaction. The "xid" can be retrieved from the
column
"xactname"
of the
system table
systransactions
or using the
stored procedure
sp_transactions.
xa_bqual does not validate the transaction id; it just
returns an unformated string.
"int"
The parameter "int" specifies an
integer
value. This is currently set to "0" by default and
reserved for future use.
Example for the System Function xa_bqual()
select xa_bqual("0000000B_FfgIT345iG7bF1#AGffzaM_8DZ61E1", 0)
go
--------------------------------------------------------------------------
0x238f06ba81
The return value is the "branch qualifier" in binary format of the
ASE transaction id "0000000B_FfgIT345iG7bF1#AGffzaM_8DZ61E1".
See also:
col_length(),
col_name(),
curunreservedpgs(),
data_pages(),
data_pgs(),
datachange(),
datalength(),
db_id(),
db_name(),
derived_stat(),
host_id(),
host_name(),
identity_burn_max(),
index_col(),
index_colorder(),
is_quiesced(),
isnull(),
datachange(),
license_enable(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pageinfo(),
pagesize(),
partition_id(),
partition_name(),
partition_object_id(),
pointer_size(),
pnt_data_pgs(),
pssinfo(),
reserved_pages(),
reserved_pgs(),
row_count(),
rowcnt(),
showplan_in_xml(),
syb_quit(),
syb_sendmsg(),
tempdb_id(),
tran_dumptable_status(),
tsequal(),
used_pages(),
used_pgs()
xa_bqual()
and
Functions.
See also:
ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
