Page History

...

This activity supports the use of SQL parameter markers (usually designated by a question mark) in the SQL statement.  If your solution uses this capability, you must first execute one of the following activities to supply the parameter value(s):

Note that only input (IN) parameters for an SQL stored procedure are presently supported.  You cannot pass or receive OUT and INOUT stored procedure call parameters.

For more information about the SQL database activities, refer to the description of the SQL_CONNECT activity.  For a list of supplied working (*) examples using the SQL database activities, refer to:

Example Processing Sequences using the SQL database activities

INPUT Parameters:

SQLHANDLE: Required

This parameter must specify the connection handle value that identifies the SQL connection upon which this activity should operate.  The connection handle value is returned by the SQL_CONNECT activity.

SQLCALL: Required

This parameter must specify the name of the stored procedure (which may be qualified with a library or schema name) along with any parameters (or parameter markers) that it requires.  The CALL keyword should not be included. Depending on the syntax used by your database and JDBC driver, it should usually be in the form:

...

The following is an example that might be specified in this parameter to call the SQL stored procedure DXTUTSQL01, passing it two parameter values that have previously been supplied using either the SQL_PARAMS or the SQL_PARAMSCSV activity:

DXTUTSQL01(?, ?)

SQLRETURNING: Optional

This parameter specifies the expected data type of the return value, if any, from the stored procedure.  You can choose from the following values:

...

The default value is *INTEGER.  If your database is on an IBM i server, note that presently the IBM i database only supports a data type of integer for values returned from a stored procedure.  If your stored procedure does not return a value, then you can specify *NONE to signify this.

OUTPUT Parameters:

SQLRESULT:

If successful, this output parameter will contain the return value, if any, from the stored procedure.