Data Transformation Engine Database Interface Designer Reference Guide

Chapter 8 - Using Stored Procedures Examples Using Stored Procedures
Database Interface Designer Reference Guide
122
The Database-independent Syntax for Calls
The database-independent syntax for calling stored procedures is:
CALL [?=]
procedure_name [( argument_list )]
Refer to the following table for a description of the arguments.
Option Description
?=
Indicates that the return value from a stored function
should be returned
procedure_name
The name of the stored procedure or function
argument_list
A comma-separated list of arguments in which each
argument is one of the following:
value
This is the value to be passed to an input
parameter. If the value contains spaces, it
must be surrounded by single quotation
marks (for example,
'city of'). The
quotation mark characters are not passed
as part of the parameter.
?
Return the value from an output
parameter.
X
Do not return the value from an output
parameter.
?/ value
This is the value to be passed to an In /
Out parameter and the value to be
returned from the parameter.
Examples Using Stored Procedures
In the following example, there is a stored procedure named DoSalaryIncrease
with the following parameters:
Employee ID - parm1 - In
Merit Increase (%) - parm2 - Out
Salary - parm3 - In / Out
Effective Date - parm4 - Out