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 |
Requires one of:- DBA authority.
- You have EXECUTE permission on the procedure.
- You own the procedure.
|
| SAP Sybase IQ
16.0 |
Requires 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, select .
- Select a procedure or remote procedure from the right pane, click the arrow to the
right of the name and select View Data in SQL.
- 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.