Designing .NET CLR routines

When designing .NET CLR routines, you should take into account both general external routine design considerations and .NET CLR specific design considerations.

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.

Knowledge and experience with .NET application development and general knowledge of external routines. The following topics can provide you with some of the required prerequisite information.

For more information on the features and uses of external routines see:

External routine implementation

For more information on the characteristics of .NET CLR routines, see:

.NET common language runtime (CLR) routines

With the prerequisite knowledge, designing embedded SQL routines consists mainly of learning about the unique features and characteristics of .NET CLR routines:

Include assemblies that provide support for SQL statement execution in .NET CLR routines (IBM.Data.DB2)
Supported SQL data types in .NET CLR routines
Parameters to .NET CLR routines
Returning result sets from .NET CLR routines
Security and execution control mode settings for .NET CLR routines
Restrictions on .NET CLR routines
Returning result sets from .NET CLR procedures

After having learned about the .NET CLR characteristics, see: Creating .NET CLR routines.