Display the version number for a specified connection.
call sp_iqmpxgetconnversion ( )
On a Multiplex Query server, returns in an UNSIGNED BIGINT the version number that the current connection will use for the current transaction. On a Write server, always returns 0.
The version number is a database-wide monotonically-increasing integer that increases any time the write server commits new data in the IQ Main store.
This procedure lets you determine versions across connections on one or more multiplex query servers in a multiplex environment.
For instance, assume that two different connections are made to IQ multiplex query servers at nearly the same time, and you need to coordinate by SELECT statements between the two connections so that they are using the same version of the data. If any transaction committed between the moment of the first and the second connections, they will see two different versions.
This procedure lets you determine whether both connections are using the same version of the data.
You cannot determine whether write server connections will see the same version of the data.
