HP Neoview Release 2.4 Software - Manual (Page 47)

• SQL Access: Specifies the way this procedure interacts with SQL Database. The values
displayed are: CONTAINS SQL | MODIFIES SQL DATA | READS SQL DATA | NO
SQL. For more information, see the HP Neoview Guide to Stored Procedures in Java.
• Signature: The parameter signature. For information on data types, see the Neoview
SQL Reference Manual.
• Creation Time: Time and date when the procedure was created. Timestamp is in the
format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the procedure was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Parameters Tab
To display the procedure parameter information:
1. Select a Schema in the navigation tree.
2. Click on the Procedures tab in the right pane and select a procedure name, or open the
Procedures folder and select a procedure name in the tree.
3. Click on the Parameters tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the parameter.
• Direction: The values displayed are: IN | OUT | INOUT.
IN passes data to the procedure. OUT accepts data from the procedure. This is the
default for array parameters. INOUT passes data to and accepts data from the procedure.
• SQL Data Type: Specifies an SQL data type that corresponds to the Java parameter of
the procedure Java method. For information on SQL data types, see the Neoview SQL
Reference Manual.
• Java Data Type: Specifies a mappable Java data type. For information on Java data
types, see the Neoview Stored Procedures in Java Manual.
DDL Tab
To display the DDL output for the procedure:
1. Select a Schema in the navigation tree.
2. Click on the Procedures tab in the right pane and select a procedure name, or open the
Procedures folder and select a procedure name in the tree.
3. Click on the DDL tab in the right pane.
In the right pane, DDL output is displayed in the text box. For HP services, the internal
format of the SHOWDDL output is displayed. For more information on the format of the
SHOWDDL command, see the SQL Reference Manual.
For more information about displaying DDL, see “Displaying Schema DDL and Their
Properties” (page 53) .
Privileges Tab
To display the privileges for the procedure:
Displaying Procedures and Their Properties 47