Using the Adapter for Adabas Stored Procedures

The Adapter for Adabas Stored Procedures enables you to invoke an Adabas stored procedure, which is a Natural subprogram created and tested using Natural facilities.

Note: This adapter is only available on the z/OS operating systems.

You invoke a stored procedure by:

• Issuing a data retrieval command in an SQL request.
• Issuing a Data Manipulation Language (DML) request. (DML is Information Builders internal retrieval language, TABLE.)
• Executing a remote procedure call.

This enables you to invoke an Adabas stored procedure from environments like WebFOCUS and DataMigrator. You can pass input parameters to a stored procedure by specifying filtering criteria in the request or to an RPC by passing a parameter list. You retrieve output as an answer set.

You use the Web Console or the Data Management Console to generate a synonym for a stored procedure using information from Natural data areas. The synonym maps the input and output parameters of a procedure.