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.



 

Note: The CREATE ASSEMBLY and DROP ASSEMBLY statements are supported in the Enterprise Edition only.

 

 

Examples

 

1)

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



 


CREATE ASSEMBLY dotNET_routines


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



 

 


 

Conformance

 

NexusDB extensions

-

CREATE ASSEMBLY statement