Define an assembly registration.


Syntax

<assembly definition> ::=

CREATE [ SCRIPT | NET ] ASSEMBLY assembly-name

[ AUTHORIZATION owner-name ]

FROM <assembly specifier>

<assembly specifier> ::=

|

<quote> [ \\computer-name\ ] share-name\ [ path\ ] manifest-file-name <quote>

<quote> [ local_path\ ] manifest-file-name <quote>


Usage

The CREATE ASSEMBLY statement registers a .NET assembly on the NexusDB Server. After registration, the methods contained in the assembly can be referenced by user-defined CLR procedures and functions.


Notes

The assembly name shall conform to the format rules for identifiers in NexusDB SQL. The name must be different from other registered assembly names, and is the name used by the server to identify the assembly when invoking user-defined CLR routines.
The AUTHORIZATION clause specifies the name of a valid user or role. If the clause is not specified, then ownership is given to the current user.
The FROM clause specifies the local path or network location where the assembly is located, and the manifest file name that corresponds to the assembly.
The SCRIPT or NET clause specifies whether a script is a NXScript or .NET dll.

Note: The CREATE ASSEMBLY and DROP ASSEMBLY statements are supported in the Developer Versions only.


Examples

1) The following example registers an assembly located in a local folder on the NexusDB Server computer:

       CREATE NET ASSEMBLY dotNET_routines

       FROM 'C:\Program Files\NexusDB\Assemblies\DBFuncs.dll'


Conformance

NexusDB extensions

-

CREATE ASSEMBLY statement

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements