ml_add_connection_script ( 
'version', 
'event', 
'script'  
)

To delete a connection script, set the script contents parameter to null.

When you add a script, the script is inserted into the ml_script table and the appropriate references are defined to associate the script with the event and script version that you specify. If the version name is new, it is automatically inserted into the ml_version table.

• System procedures to add or delete scripts
• Script additions and deletions
• ml_add_table_script system procedure
• ml_add_dnet_connection_script system procedure
• ml_add_dnet_table_script system procedure
• ml_add_java_connection_script system procedure
• ml_add_java_table_script system procedure

The following statement adds a connection script associated with the begin_synchronization event to the script version custdb in a SQL Anywhere consolidated database. The script itself is the single statement that sets the @EmployeeID variable.

call ml_add_connection_script( 'custdb',
 'begin_synchronization',
 'set @EmployeeID = {ml s.username}' )