Add/Modify Stored Procedure
Window
The Add/Modify Stored Procedure window
allows you to define the database's stored procedures to Data
Access Builder. You must define the stored procedure before you
map a stored procedure call method to it. You can import
definitions from the database by clicking Get Stored
Procedures in the Stored Procedures List window and
importing the desired stored procedure. Then you should modify
the imported stored procedure to ensure the definition is
accurate.
If you do not connect to the database to
retrieve stored procedure information, use this window to
manually define the stored procedure to the Data Access Builder.
In this situation, you are responsible for ensuring that this
definition matches the one stored in the database.
The stored procedures that you define to Data
Access Builder are stored with the Data Access Builder session
and can be used with any mapping for that database in the
session.
Warning: If you modify a
stored procedure in a database, it may invalidate a stored
procedure definitions and methods that you have defined with Data
Access Builder.
The Add/Modify Stored Procedure window contains
the following elements:
- Procedure Name - The name
of the stored procedure from the database.
- Parameters - Each
parameter defined for the stored procedure is displayed
in the Parameters container, and is modified by changing
the fields below. Work with one parameter at a time by
selecting one, making the desired changes, and clicking
the Add or Modify
button when you are done; then, select the next
parameter.
- Delete - Deletes the
selected parameter.
- Copy - Makes a copy of
the selected parameter. A unique name is generated for
the new parameter; the generated name can be changed in
the SQL Name field.
- Move Up - Moves the selected parameter up in the list.
Parameters for the stored procedure must be defined in
the correct sequence. Move Up and Move
Down can be used to get them into correct order.
- Move Down - Moves the selected parameter down in the list.
Parameters for the stored procedure must be defined in
the correct sequence. Move Up and Move
Down can be used to get them into correct order.
- Parameter Modification Fields
- Select a parameter from the list above, make the
appropriate settings from the following fields, and then
click Add to add a new parameter or Modify
to modify the selected parameter.
- Parameter Type -
Select one of the following items from the
drop-down box:
- In -
An input parameter for the
stored procedure.
- In/Out -
An input/output parameter for
the stored procedure.
- Out - An
output parameter for the stored
procedure.
- Return Value
- The return value for
the stored procedure (there may be at
most one return value for a stored
procedure definition).
- Result Column
- a result column returned by the stored
procedure (result columns must be mapped
this way in order to access the results.
- SQL Name -
The name of the parameter.
- SQL Type -
The SQL Type of the parameter.
- Length - The
length for a BINARY, CHAR, GRAPHIC, VARBINARY,
VARCHAR or VARGRAPHIC type.
- Precision -
The precision for a DECIMAL or NUMERIC
type.
- Scale - The scale
for a DECIMAL or NUMERIC type.
- Add - Click this to add a
new parameter with the specified properties to the
Parameters list. Use the Move Up and
Move Down to position it correctly within the
list of parameters.
- Modify - Click this to
change the properties of the selected parameter to the
settings indicated.
- OK - Adds or modifies the
stored procedure definition and exits the window.
- Cancel - Cancels the changes made to the stored procedure
definition and exits the window.
- Help - Displays
online help information about the window.

User-Defined
Methods

Display
List of Stored Procedures for a Database
Define
Stored Procedure
Add
User-Defined Methods