1 – connection-name
Specifies a name for the association between the group of databases being attached (the environment) and the database and request handles that reference them (the connection). You can specify the connection name as the following: o String literal enclosed within single quotation marks o Parameter (in module language) o Variable (in precompiled SQL)
2 – DEFAULT
Specifies one or more databases to be attached as a unit. Use the DEFAULT keyword to specify the default connection. The default connection is all the databases that were attached interactively, or all those made known to the module at compile time through DECLARE ALIAS statements.