Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Schema Statements >

CREATE ASSEMBLY statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

CREATE ASSEMBLY statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Schema Statements

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 optional SCRIPT or NET clause specifies whether a script is a NXScript or .NET dll. If no type is specified then it defaults to a .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 ASSEMBLY dotNET_routines

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

 

 


Conformance

 

NexusDB extensions

-

CREATE ASSEMBLY statement

 

© Nexus Database Systems Pty Ltd.

nexus_logo