Adding a parameter for a stored procedure in Java

Procedure

  1. Open the Create Java Procedure wizard.

    For more information, see Creating a stored procedure in Java.

  2. In the Parameters tab, click Add.

    The Specify Parameter window is displayed.

    Specify parameter
  3. Optional. Enter the parameter name in the Name field.
  4. Select a SQL data type in the SQL/MX Type drop-down menu.
  5. To specify the Java wrapper class for Java data type, select the Use Java wrapper class check box.

    This check box is enabled if you select Float, Double Precision, Integer, Largeint, or Real in SQL/MX Type.

  6. In the Parameter Mode field, select one of the following options:

    • IN

      Specifies a parameter that passes data to an SPJ.

    • OUT

      Specifies a parameter that accepts data from an SPJ.

    • INOUT

      Specifies a parameter that passes and accepts data from an SPJ.

  7. Click OK.