connection_name uniquely identifies the Adaptive Server connection. It can be a quoted literal. You can create an unlimited number of connections in an application program, one of which can be unnamed. connection_name has a maximum size of 255 characters.
When you use connection_name in a connect statement, all subsequent Embedded SQL statements that specify the same connection automatically use the server indicated in the connect statement. If the connect statement specifies no server, the default server is used. See the Open Client and Open Server Programmer’s Supplement for details on how the default server is determined.
To change the current server connection, use the set
connection statement described in “Changing the current connection”.
An Embedded SQL statement should only reference a connection_name specified in a connect statement. At least one connect is required for each server that the application program uses.
