Creating .NET CLR routines
Creating .NET CLR routines consists of executing a CREATE statement that defines the routine in a database server, and developing the routine implementation that corresponds to the routine definition.
Before you begin
Attention: With the release of Db2
11.5.9, support for Microsoft
.Net common language runtime (CLR) routines is deprecated and might be removed
in the future. If you are currently running routines that have a dependency on .NET CLR, rewrite the
routine logic in a supported language and then recreate the routines.
- Review the .NET common language runtime (CLR) routines.
- Ensure that you have access to a database server, including instances and databases.
- Ensure that the operating system is at a version level that is supported by the database products.
- Ensure that the Microsoft .NET development software is at a version level that is supported for .NET CLR routine development. Refer to Support for external routine development in .NET CLR languages.
- Authority to execute the CREATE PROCEDURE or CREATE FUNCTION statement.
About this task
The ways in which you can create .NET CLR routines follow:
- Using the graphical tool that is provided with the IBM Database Add-Ins for Microsoft Visual Studio
- Using the Db2® command window
It is easier to create .NET CLR routines using the IBM Database Add-Ins for Microsoft Visual Studio. However, you can use the Db2 command window to create .NET CLR routines.
Create .NET CLR routines from one of the following interfaces:Procedure
- Visual Studio .NET when the IBM Database Add-Ins for Microsoft Visual Studio is also installed. When the Add-In is installed, graphical tool that is integrated into Visual Studio .NET is available for creating .NET CLR routines.
- Db2 command window