When the CONNECTION_NAME Is Not Updated

The CONNECTION_NAME field is not updated in the following cases:
  • A CONNECT statement fails.
  • A DISCONNECT statement fails (but this does not include the DISCONNECT ALL statement).
  • A SET CONNECTION statement fails.

The CONNECTION_NAME field retains the value set in the previous SQL statement. If any of the preceding conditions occurs on the first SQL statement that executes, the CONNECTION_NAME field is blank.

An implicit connection has no name. After a DATABASE statement successfully creates an implicit connection, the CONNECTION_NAME field is blank.