Displaying attributes of a procedure

To display the attributes of a procedure:

Procedure

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

    The following details related to attributes appear:

    • Name — The name of the procedure.

    • Metadata UID — The unique ID number of the procedure.

    • Dynamic Result Sets — The maximum number of result sets returned.

    • SQL Access — This attribute specifies how the procedure accesses the SQL data. If the procedure does not perform SQL operations, the value displayed in this field is N. Otherwise, the value displayed in this field is one of the following:
      • CONTAINS SQL
      • MODIFIES SQL DATA
      • READS SQL DATA

    • Parameters — The parameter type. For information on data types, see HPE NonStop SQL/MX Guide to Stored Procedures in Java.

    • External Path — Either an OSS directory or a JAR file path that contains the SPJ class file.

    • External File — The name of Java class file that contains the procedure code.

    • External Name — This attribute specifies the case-sensitive name of the SPJ method. For more information, see HPE NonStop SQL/MX Release 3.4 Reference Manual.

    • Language — The programming language in which the procedure code is written.

    • Parameter Style — The programming language associated with the format of the procedure parameters.

    • Deterministic — If in the Create Procedure statement you specified the option DETERMINISTIC, this column contains Yes. If you specified NOT DETERMINISTIC , this column contains a No. This value specifies whether the SPJ always returns the same values for OUT and INOUT parameters for a given set of argument values (DETERMINISTIC) or does not return the same values (NOT DETERMINISTIC, which is the default option). SQL/MX allows both options but always treats the SPJ as nondeterministic.

    • Isolate — This attribute specifies that the SPJ executes either in the environment of the database server (NO ISOLATE) or in an isolated environment (ISOLATE, which is the default option). SQL/MX allows both options but always executes the SPJ in the SQL/MX user-defined routine (UDR) server process (ISOLATE).

    • Transaction Attributes — This attribute indicates whether a transaction is required.

    • Creation Time — The time and date when the procedure was created. The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Redefinition Time — The time and date when the procedure was last redefined. The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Owner— The owner of the object.