Adding parameters to a stored procedure

Use the Add Parameter window to add parameters to a stored procedure.

To add a parameter:

1. Specify a name for the parameter in the Parameter name field. The name can be a 1-8 character string.
2. Select a type from the Parameter type list:

   INT	DOUBLE PRECISION	CHARACTER
   INTEGER	DEC	VARCHAR
   SMALLINT	DECIMAL	GRAPHIC
   REAL	CHAR	VARGRAPHIC
   FLOAT

3. To specify parameter characteristics:
   1. Type values in the required fields:

      Length

      If you select CHAR, CHARACTER, VARCHAR, GRAPHIC, or VARGRAPHIC, then this field is available.

      Precision

      If you select DEC or DECIMAL, then this field is available.

      Scale

      If you select DEC or DECIMAL, then this field is available.

   2. If you select DEC or DECIMAL, specify a data type:

      SBCS

      MIXED

      BIT

4. To specify how applications use the parameter, select one of the radio buttons under IN/OUT:

   IN

   OUT

   IN/OUT

5. Click OK.