IBM Integration Bus, Version 10.0.0.3 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Context

A stored procedure is a procedure that is stored on the database server.

Usually written in SQL, the stored procedure benefits from the power and proximity of the database from which it is managed.

Stored procedures offer other benefits.

With a Mapping node, you might have multiple database SELECT transforms. Each SELECT transform is executed by sending a message over the network to the server. Often the server sends a response in return. But a stored procedure resides on the server. When the client application calls it, it runs on the server. It responds only when it returns the final result set to the client, saving network traffic.


sp_01_03_.htm | Last updated 2015-11-25 08:25:31