sp_iqmpxversionfetch procedure

Function

Fetches the current version information for thisserver into argument variables.

Syntax

sp_iqmpxversionfetch( out CatalogID unsigned bigint,
out VersionID unsigned bigint,
out OAVID unsigned bigint,
out ServerType char(1),
out CatalogSync char(1),
out WCatalogID unsigned bigint,
out WVersionID unsigned bigint,
)

Description

**Table 9-42: sp_iqmpxversionfetch arguments returned**
Column	Data type	Description
CatalogID	unsigned bigint	Catalog version on this server
VersionID	unsigned bigint	Latest version available on this server
OAVID	unsigned bigint	Oldest active version on this server
ServerType	char(1)	Type of server: ‘S,’ ‘W,’ or ‘Q’
CatalogSync	char(1)	In catalog synchronization? ‘T’ or ‘F’
WCatalogID	unsigned bigint	Catalog version on the write server
WVersionID	unsigned bigint	Latest version available on the write server