Chapter 4: ASE Replicator Procedures

sp_helplocator

Description

Returns fields in a locator string.

Syntax

sp_helplocator value

Parameters

value: The value of the locator string that identifies a transaction in the stable queue. The value of the locator string must be enclosed in quotes.

Examples

Example 1

sp_helplocator "000000000003ad0000022d4d000b00022d4d00061e0035000000000000000000"

Returns the fields in the locator string with the value specified, as follows:

item           hex_value     value
Generation ID    0000          0
txid_page        00022d4d      142669
txid_row         0006          6
log_ts_high      0000          0
log_ts_low       0003ad00      240896
opid_page        00022d4d      142669
opid_row         000b          11
op_code          1e            30
conn_id          0035          53

Usage

When listing fields in a locator string, the following result set is returned:

**Table 4-10: ASE Replicator locator field information**
Column	Datatype	Description
item	varchar(20)	Name of the field
hex_value	varchar(10)	Hexadecimal value of the field
value	varchar(10)	Decimal value of the field

sp_helplocator is for use primarily in troubleshooting procedures.
You can use sp_helplocator to return the fields in locator values returned by sp_helplastcommit.
When an error occurs, an error message is returned.