CLR Assemblies  (DB2 for Linux, UNIX, and Windows)

File name

Shows the name of the CLR assembly (DLL) that was referenced when you created the CLR procedure by using the DB2 CLR Procedure wizard. This name is derived from the CLR project name. To select a different source assembly or location, click to browse to a different assembly or location. To create a new assembly reference for your project, select New from the list. The base file name for an assembly must be unique in the set of assembly references in your IBM^® database project.

File timestamp

Shows the timestamp of the selected assembly.

Target database directory

Type a subdirectory, relative to the SQLLIB\FUNCTION directory, where you want the assembly to be installed on the DB2^® server.

EXTERNAL name

Shows the unique EXTERNAL name for the selected assembly. This name is generated when an assembly is installed on the server, and is used as a replacement parameter in the EXTERNAL name clause of the CREATE PROCEDURE statement at run time. You cannot change the EXTERNAL name that is shown in this field.

Last successful install time

Shows the timestamp of the last successful installation of the selected assembly on the DB2 server.

Installed assembly timestamp

Shows the file timestamp of the last assembly that was successfully installed on the DB2 server.

Do not install on build

Select to prevent installation of the selected assembly on the DB2 server during a project build.

Remove

Removes the assembly reference information from the IBM database project. The assembly is not removed from the file system.

Set As New

Clears information that is associated with the selected assembly from the project. A subsequent project build installs an assembly.

Install

Installs the selected assembly on the DB2 server.

Note:  You no longer can deploy DB2 CLR procedures to a DB2 for Linux^®, UNIX^®, or Windows^®, Version 8 data server.