ml_add_dnet_table_script system procedure

Use this system procedure to register or unregister a .NET method as the script for a table event.

Syntax 
ml_add_dnet_table_script ( 
'version', 
'table', 
'event', 
'script'  
)
Parameters

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 Adaptive Server Enterprise prior to 12.5, this parameter is VARCHAR(255). For DB2 LUW, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB.

Remarks

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.

See also
Example

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' )
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0