Use this window to create or edit a parameter for a stored procedure.
- Mode
- Select IN, OUT, or INOUT.
- Name
- Type a name up to 8 characters long.
- Data type
- Select the data type of the parameter from these
choices:
- INTEGER
- SMALLINT
- DECIMAL
- FLOAT
- DOUBLE
- CHAR
- VARCHAR
- GRAPHIC
- VARGRAPHIC
- Length
- Specify the length of the parameter, if required,
for the selected data type.
- CHAR
- Between 1 and 254
- VARCHAR
- Between 1 and 32704
- GRAPHIC
- Between 1 and 127
- VARGRAPHIC
- Between 1 and 16531
- Precision
- Specify the precision for the parameter, if required
for the selected data type.
- Scale
- Specify the scale for the parameter, if required
for the selected data type.