This section explains how to use stored procedures in VisualAge applications. It explains the following tasks:
This section does not explain how to create stored procedures to be used with the VisualAge Stored Procedure part. Refer to your database documentation for instructions for compiling, linking, and binding applications to your database.
To see examples of using stored procedures in a VisualAge application, load the IBM database samples into your image as follows:
After this feature is loaded, from the VisualAge Organizer, select Applications>View>Show All Applications. TheAbtDbmCliSamples application appears in the VisualAge Organizer.
These parts use the sample stored procedures that are shipped with DB2. AbtStoredProc1View uses outsrv and AbtStoredProc2DBView uses inpsrv Refer to your DB2 documentation for instructions on constructing the DLLs for these stored procedures.
Though the Stored Procedure part is supported by the ODBC and native ORACLE features, the sample stored procedure parts work with the DB2 SAMPLE database only.