Examine the SQL statement and properties of a procedure on a Sybase IQ server. You can edit the SQL statement and change some property values.
Prerequisites
- Create a procedure.
- Authenticate with Sybase IQ using an account that has DBA authority, Resource authority, or owns the function. (If you do not have authority to modify properties, Sybase Control Center displays the properties dialog in read-only mode.)
Task- In the Perspective Resources view, select the resource and select .
- In the left pane of the Administration Console, expand and select Procedures.
- In the right pane, select a procedure.
- Click the drop-down arrow that appears next to the procedure name and select Properties.
The properties dialog opens.
- View the contents of the properties dialog. You can modify some values:
| Page in Procedure Properties |
Modifiable Values |
|---|
| General |
Comment |
| Parameters |
None |
| SQL |
SQL code |
| Permission |
Permissions |
- Click OK to save changes or click Cancel to dismiss the dialog without saving.