DEFAULT Option

The DEFAULT option specifies the default connection for a SET CONNECTION statement. The default connection is one of the following connections:
  • An explicit default connection (a connection established with the CONNECT TO DEFAULT statement)
  • An implicit default connection (any connection established with the DATABASE or CREATE DATABASE statements)

Use SET CONNECTION without a DORMANT option to reestablish the default connection, or with that option to make the default connection dormant.

For more information, see The DEFAULT Connection Specification and The Implicit Connection with DATABASE Statements.