Displaying parameters of a procedure

To display the parameters of a procedure:

Procedure

  1. In the navigation tree, select the procedure.
  2. In the right pane, click Parameters.

    The following details related to parameters appear:

    • Name — The name of the parameter.

    • Direction — The following values appear:

      • IN — Passes data to the procedure.

      • OUT — Accepts data from the procedure. This value is the default for array parameters.

      • INOUT — Passes data to and accepts data from the procedure.

    • SQL Data Type — This attribute specifies an SQL data type that corresponds to the Java parameter of the procedure's Java method. For information on SQL data types, see HPE NonStop SQL/MX Release 3.4 Reference Manual

    • Java Data Type — This attribute specifies a Java data type that can be mapped. For information on Java data types, see HPE NonStop SQL/MX Release 3.4 Reference Manual.