Designing external stored procedures
The stored procedures can be defined either in SQL or in a high-level programming language. If their definition is written in high-level language, then they are known as external procedures. Their definition is very similar to a normal program written in a language. There could be various reasons to prefer external procedures. For instance, if we want to perform actions external to the database, then external procedures can be very useful. It could be very useful in encapsulating complex business logic in an external procedure, where we can exploit all the features of a high-level programming language.
DB2 supports the following languages for external stored procedures:
- C/C++
- Java
- .NET common language runtime ...
Get IBM DB2 9.7 Advanced Application Developer Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
