xact_connmigrate

(Cluster environments only) Determines whether or not a connection can process an external transaction.

Syntax

xact_connmigrate_check(“txn_name”)

Example 1 – SHows an XA transaction “txn_name” running on instance “ase1”.
```
select xact_connmigrate_check("txn_name")
```
```
--------
    1
```
Example 2 – Shows an XA transaction “txn_name” running on instance “ase2”. The connection can migrate.
```
select xact_connmigrate_check("txn_name")
```
```
--------
    1
```
Example 3 – Shows an XA transaction “txn_name” running on instance “ase2”. The connection cannot migrate.
```
select xact_connmigrate_check("txn_name")
```
```
--------
    0
```

If an XID is specified, xact_connmigrate_check returns:

1 if the connection is to the instance running the specified transaction, or the connection is to another instance in a migratable state
0 if the connection or transaction ID does not exist, or the connection is to another instance that is not in a migratable state

If an XID is not specified, xact_connmigrate_check returns:

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute xact_connmigrate_check.