connection_name uniquely identifies the Adaptive Server connection. It can be a double-quoted or an unquoted 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 128 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/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 reference only a connection_name specified in a connect statement. At least one connect statement is required for each server that the application program uses.
