Populate the Mini iSQL window with the result set of a selected procedure, remote
procedure, Table UDF, or TPF.
Prerequisites
| Database Version |
Procedure Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
You must have one of:- DBA authority
- You have EXECUTE permission on the
procedure
- You own the procedure
|
| SAP Sybase IQ
16.0 |
You must have one of:- EXECUTE ANY PROCEDURE system privilege
- You have EXECUTE permission on the
procedure
- You own the procedure
|
- The SAP Sybase IQ resource is authenticated and
running.
Task- In the Perspective Resources view, select the resource, and
select .
- In the left pane, expand , and then select Procedures.
- Select a procedure or remote procedure from the right pane and either:
- Click the arrow to the right of the name and select View Data in
SQL, or
- From the Administration Console menu bar, select .
- If the procedure or remote procedure has defined parameters, select a parameter to
be used when executing the procedure, and select Next.
- The results of the executed procedure display in SQL. Select
Execute to execute the procedure again.