| Let Your Relational Database Do the Work — How to Invoke Stored Procedures from Domino 6 Applications
by Sarah Boucher; by Joseph Pescatello
Topic(s): Enterprise Integration
from THE VIEW, November/December 2003
Most relational database systems allow applications like Domino to invoke procedures that encapsulate functions such as sorting, grouping, and performing calculations on stored data. Domino 6 provides broad support for stored procedures, allowing developers to off-load large data-processing tasks to an enterprise database system and bring back the results. In this article, you’ll learn how to use stored procedures for more efficient use of network resources, faster performance, and enhanced application functionality. You’ll see how to connect a Domino 6 application to a DB2 stored procedure using three standard Domino integration tools —DECS, LEI, and LC LSX — and how to troubleshoot your stored procedures. The code for the sample applications is available in a download database from THE VIEW Web site. |