Database Guide


Stored Procedure

Select the Stored Procedure part to add a part to the free-form surface that enables you to invoke a procedure stored at the location of a database. Stored procedures can be invoked using the following calling conventions:

Stored procedures reduce network traffic and increase data integrity. A stored procedure file can accept inputs from your application, can return outputs, and usually contains embedded SQL statements that are run as a unit. The stored procedure file must already exist; the VisualAge Stored Procedure part is used only to run the stored procedure file.

Part:
Stored Procedure  
storproc

Category:
Database Functions  
dbcat

Class Name:
AbtStoredProc

To display the pop-up menu for the part, click with mouse button 2 on the part.

To further define the function of a nonvisual part, double-click on it to open the settings view window for the part. The Stored Procedure - Settings window displays.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]