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

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 the
HP NonStop SQL/MX Release 3.2.1 Reference Manual.
•
Java Data Type: — This attribute specifies a Java data type that can be mapped. For
information on Java data types, see the HP NonStop SQL/MX Guide to Stored Procedures
in Java.
Viewing information on related objects
To view information on related objects:
1.
In the navigation tree, select the view.
2. In the right pane, click Related Objects.
The following details appear:
•
Relationship: — This attribute specifies the relationship of the procedure with the object
specified. The available value for this field is References, Used By, and Has.
•
Related Object Type: — This attribute specifies the type of the object that the procedure
references. The available values are Table and View.
•
Related Object Name: — This attribute specifies the three-part ANSI object name. The
object name is linked to the object.
•
Metadata UID: — A unique ID of the related object.
•
Creation Time: — The time and date when the related object 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 related object was last redefined. The
time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing DDL information of a procedure
To view DDL information related to the procedure:
1.
In the navigation tree, select the procedure.
2. In the right pane, click DDL.
The DDL tab displays the SHOW DDL output for the procedure. For more information on the
SHOW DDL
command, see the HP NonStop SQL/MX Release 3.2.1 Reference Manual.
Viewing information related to procedure privileges
To view information related to the procedure privileges:
1.
In the navigation tree, select the procedure.
Viewing procedures and their properties 71