Use this system procedure to add or delete SQL connection scripts in the consolidated database.
ml_add_connection_script ( 'version', 'event', 'script' )
Syntax |
Description |
---|---|
version |
VARCHAR(128). The version name. |
event |
VARCHAR(128). The event name. |
script |
TEXT. The script contents. For Adaptive Server Enterprise, this parameter is VARCHAR(16384). For DB2 LUW, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB. |
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.
For DB2 mainframe consolidated database types, this procedure is called ml_add_cs. See IBM DB2 mainframe system procedure name conversions.
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}' ) |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |