beautypg.com

Attributes tab – HP Neoview Release 2.4 Software User Manual

Page 68

background image

In the right pane, these tabs appear:

Attributes tab

Parameters tab

Privileges tab

Attributes Tab

To display the procedure names and attributes:

1.

Select a Schema in the navigation tree.

2.

Click the Procedures tab in the right pane and select a synonym name, or open the Procedures
folder and select a procedure name in the tree.

3.

Click the Attributes tab in the right pane.

In the right pane, these attributes are displayed:

Name: The name of the procedure.

Dynamic Result Sets: The maximum number of result sets returned (integer).

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 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).

68

Manage Database Objects