Use this system procedure to register or unregister a .NET method as the script for a table event.
ml_add_dnet_table_script ( 'version', 'table', 'event', 'script' )
Syntax |
Description |
---|---|
version |
VARCHAR(128). The version name. |
table |
VARCHAR(128). The table 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 unregister a method, set the script contents parameter to null.
The script value is a public method in a class in a .NET assembly (for example, MyClass.MyMethod).
When you call ml_add_dnet_table_script, the method is associated with the table, 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_dts. See IBM DB2 mainframe system procedure name conversions.
The following example assigns the empDownloadCursor method of the EgClass class to the download_cursor event for the table emp.
call ml_add_dnet_table_script( 'ver1', 'emp', 'download_cursor',EgPackage.EgClass.empDownloadCursor' ) |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |