Invoked at the time the MobiLink server connects to the consolidated database server.
The MobiLink synchronization opens connections on demand as synchronization requests come in. When an application forms or reforms a connection with the MobiLink server, the MobiLink server temporarily allocates one connection with the database server for the duration of that synchronization. This event may not be called if the MobiLink server is using a connection from the pool.
This script is not generally used in Java or .NET, because instead of database variables you would use member variables in this class instance, and prepare the members in the constructor.
The following SQL script works with a SQL Anywhere consolidated database. Two variables are created, one for the last_download timestamp, and one for employee ID.
CALL ml_add_connection_script( 'custdb', 'begin_connection', 'create variable @LastDownload timestamp; create variable @EmployeeID integer;')