Re: Knowing DR server status
Juan R. Guzman wrote:
>
> If I have DR upp and running, how can I, under Informix 7.11UC1, with a
> select statement, find out if the server I'm on is the primary or> secondary?
When you connect to the database the sqlda structure has a flag that
will tell you if it is a primary or secondary server. It is the seventh
field of the sqlwarn structure (sqlda.sqlwarn[6] ESQL/C,
sqlda.sqlwarn[7]
in 4GL). See the Guide to SQL Tutorial (P. 5-10 in the 7.1 fine manual
set).
Cosmo