Setting Input and Output Parameters

Restriction: This topic applies to Windows environments only.

You can optionally provide a value for each input and/or output parameter associated with the stored procedure. All parameters defined in a stored procedure selected in the tree view appear on the Parms tab. Input parameters are identified by either a P (for input) or a B (for input/output) in the I/O column. Output parameters are identified by an O in the I/O column.

You assign a value to an input parameter using one of the following methods:

Type the value directly into the Value field
Type the value into the Edit Entry Value editor
Specify a side file (.dat file) to contain the value
Specify a special register that defines the value

If you want to store the value of an output parameter as the stored procedure executes, set the Allow Output Side Files option to True. This enables you to specify a side file or a special register to hold the value.

Note: If you want to specify an EBCDIC side file to contain the value but do not already have one available, you can create one.