Additional Data for Task Results

Go Up to Querying Service Tasks

The isc_info_svc_limbo_trans result item returns multiple sets of data. If there are multiple limbo transactions to report, the result buffer contains multiple clusters. The contents of the buffer end when a cluster is identified with the isc_info_flag_end value. The following table describes the cluster identifiers for the limbo transaction information.

Services API limbo transaction arguments

Argument	Purpose	Return length	Return value
isc_dpb_single_tra_id	Specifies a single-database limbo transaction ID	4 bytes	Unsigned long
isc_spb_multi_tra_id	Specifies a multi-database limbo transaction ID	4 bytes	Unsigned long
isc_spb_tra_host_site	Hostname of the client host that initiated the transaction; for multi-database transactions only	2 bytes + string	String
isc_spb_tra_advise	Server recommendation for resolution of a limbo transaction; value is one of the following: isc_spb_tra_advise_commit isc_spb_tra_advise_rollback isc_spb_tra_advise_unknown	1 byte	Byte
isc_spb_tra_remote_site	Hostname of a server on which the transaction is in a limbo state	2 bytes + string	String
isc_spb_tra_db_path	Path of the primary file of the database in which the transaction is in a limbo state	2 bytes + string	String
isc_spb_tra_state	Introduces a byte specifying the state of the limbo transaction; value is one of the following: isc_spb_tra_state_limbo isc_spb_tra_state_commit isc_spb_tra_state_rollback isc_spb_tra_state_unknown (this state should never occur)	1 byte	Byte
isc_info_flag_end	Signals the end of arguments to isc_info_svc_limbo_trans	—	—

Advance To:

• Using the Services API with RAD Studio