HP Integrity NonStop J-Series - Manual (Page 69)

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 the HP 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 the HP NonStop SQL/MX Release 3.2 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.
Viewing parameters of a procedure
To view the parameters of a procedure:
1.
In the navigation tree, select the procedure.
Viewing procedures and their properties 69