The Contents of the SERVER_NAME Field
The SERVER_NAME field contains different information after you execute the following statements.
- Executed Statement
- SERVER_NAME Field Contents
- CONNECT
- Contains the name of the database server to which you connect or fail to connect. Field is blank if you do not have a current connection or if you make a default connection.
- DATABASE
- Contains the name of the database server on which the specified database resides.
- DISCONNECT
- Contains the name of the database server from which you disconnect or fail to disconnect. If you disconnect and then you execute a DISCONNECT statement for a connection that is not current, the SERVER_NAME field remains unchanged.
- DISCONNECT ALL
- Sets the field to blank if the statement executes successfully. If the statement fails, SERVER_NAME contains the names of all the database servers from which you did not disconnect. (This information does not mean that the connection still exists.)
- SET CONNECTION
- Contains the name of the database server to which you switch or fail to switch
If CONNECT succeeds, SERVER_NAME is set to one of the following
values:
- The INFORMIXSERVER value (if the connection is to a default database server, because CONNECT specified no database server)
- The name of the database server (if the connection is to a specific database server)