ml_add_dnet_table_script system procedure

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 IBM 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.

This procedure can only be used with non-data table scripts. All table row data must be handled using direct row handling, via the handle_UploadData and handle_DownloadData connection events. To register these data scripts, use the ml_add_dnet_connection_script procedure.

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' )