Attributes tab – HP Neoview Release 2.4 Software User Manual

Page 68

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

68

Manage Database Objects

Advertising