Creating a Procedure

Set up a new procedure on an SAP Sybase IQ server.

Prerequisites

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	Watcom SQL or Transact-SQL procedure to be owned by self – Requires one of: DBA authority. RESOURCE ADMIN authority. Watcom SQL or Transact-SQL, to be owned by any user – Requires DBA authority. External C/C++ or External Environment procedure to be owned by self or any user – Requires one of: DBA authority.
SAP Sybase IQ 16.0	Watcom SQL or Transact-SQL procedure to be owned by self – Requires CREATE PROCEDURE system privilege. Watcom SQL or Transact-SQL procedure to be owned by any user – Requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege External C/C++ or External Environment procedure to be owned by self – Requires all of: CREATE EXTERNAL REFERENCE system privilege. CREATE PROCEDURE system privilege. External C/C++ or External Environment procedure to be owned by any user – Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege

Database Version

Procedure Privileges

SAP Sybase IQ 15.3 and 15.4

Watcom SQL or Transact-SQL procedure to be owned by self – Requires one of:

Watcom SQL or Transact-SQL, to be owned by any user –

External C/C++ or External Environment procedure to be owned by self or any user – Requires one of:

SAP Sybase IQ 16.0

Watcom SQL or Transact-SQL procedure to be owned by self –

Watcom SQL or Transact-SQL procedure to be owned by any user – Requires one of:

External C/C++ or External Environment procedure to be owned by self – Requires all of:

External C/C++ or External Environment procedure to be owned by any user –

Requires CREATE EXTERNAL REFERENCE system privilege.
Also requires one of:
- CREATE ANY PROCEDURE system privilege.
- CREATE ANY OBJECT system privilege

The SAP Sybase IQ resource is authenticated and running.
(Optional) If you are creating a Java procedure, install the required Java classes and JAR files in the database. (You can create the procedure if the classes and JAR files are not installed, but SAP Sybase IQ cannot execute the procedure.)
(Optional) If you are creating a procedure that relies on a non-Java external environment, copy the library that contains the external procedure to a location accessible to the SAP Sybase IQ server. (You can create the procedure if the library is not accessible to SAP Sybase IQ, but SAP Sybase IQ cannot execute the procedure.)

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Compiled Objects > Procedures.
Click the arrow next to Procedures and select New.
The Create Procedures Wizard appears.

On the Welcome page, specify:

Option	Description
Select a resource for which the procedure will be created	From the list, select the resource for which the procedure will be created.
Which user or group/role do you want to own the procedure?	From the list, select the user or role/group to own the procedure.
What do you want to name the procedure?	Enter a unique name for the new procedure; maximum of 128 characters.
Which SQL dialect or language do you want to use?	Select the language or SQL dialect for the procedure. If you choose External environment, click the drop-down menu to select an environment.
Use SQL template	(Optional) Select to insert a hardcoded SQL template. Leave the box unchecked to retrieve generated SQL from the back end.