Installing a Perl Object into an SAP Sybase IQ Database

Install a Perl object into an SAP Sybase IQ database. After installing it, you can reference the object in SQL procedures and functions.

Prerequisites

Database Version	External Environment – Perl Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	You must have the MANAGE ANY EXTERNAL OBJECT system privilege.

The SAP Sybase IQ resource is authenticated and running.

A Perl external environment appears in the list of external environments in the SAP Control Center Administration Console even when no Perl objects have been installed.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, select IQ Servers > Compiled Objects > External Environments > Perl.
Click the arrow beside Perl and select New.
The Install Perl Object wizard appears.

On the Welcome page, specify:

Option	Description
Select an SAP Sybase IQ resource on which the Perl object will be installed:	Select an SAP Sybase IQ resource from the list.
(Multiplex only) Select a multiplex server on which the Perl object will be installed	Select a multiplex server from the list.
SCC agent status	Indicates the current status of the SCC agent. If the SCC agent is not registered, click Register Agent and enter the required registration information. If the SCC agent is not authenticated, click Authenticate Agent. Enter a user ID, password, and port for SCC to use when it logs in to the SCC agent.
Perl script path	Enter the path to the Perl object. It must be on a file system accessible to the SAP Sybase IQ resource.
Perl object name in the database	Enter the Perl object name.
Comment	(Optional) Enter a comment describing the Perl object.

Click Finish to install the Perl object.