Specifications

Using Stored Procedure
182 InfoMaker
Alternatively, you can select the name from the file list. Use the Drives
drop-down list and the Directories box as needed to display the list of files
that includes the one you want.
Using Stored Procedure
A stored procedure is a set of precompiled and preoptimized SQL statements
that performs some database operation. Stored procedures reside where the
database resides, and you can access them as needed.
Defining data using a
stored procedure
You can specify a stored procedure as the data source for a report if your
DBMS supports stored procedures.
For information on support for stored procedures, see your database
documentation.
If the Stored Procedure icon is not displayed
The icon for the Stored Procedure data source displays in the Choose Data
Source dialog box in the report wizards only if the database to which you are
connected supports stored procedures.
❖ To define the data using Stored Procedure:
1 Select Stored Procedure in the Choose Data Source dialog box in the
wizard and click Next.
The Select Stored Procedure dialog box displays a list of the stored
procedures in the current database.
2 Select a stored procedure from the list.
To list system procedures, select the System Procedure check box.
The syntax of the selected stored procedure displays below the list of
stored procedures.
3 Specify how you want the result set description built:
• To build the result set description automatically, clear the Manual
Result Set check box and click Next.
InfoMaker executes the stored procedure and builds the result set
description for you.