The notion of a default connection, as described in the Open Client Embedded SQL documentation, does not exist in the Sybase XA environment. Consequently, applications must always explicitly specify a current connection.
There are two ways to specify the current connection in Embedded SQL. They are:
The set connection command
The at connection name clause
A current connection does not span transactions. For example, an application must reset the current connection after each CICS SYNCPOINTcommand or Encina onCommit command. To avoid confusion about the scope of the current connection, Sybase recommends that you use the at connection_name clause with all Embedded SQL statements.
