1 – ALL
Specifies all active connections.
2 – connection-name
Specifies a name for the association between the group of databases being attached (the environment) and the database and queries that reference them (the session). You can specify the connection name as the following: o A string literal enclosed in single quotation marks o A parameter (in module language) o A variable (in precompiled SQL)
3 – CURRENT
Specifies the current connection.
4 – DEFAULT
Specifies the default connection.