Working in a Perl External Environment

Install Perl objects, test a Perl external environment, and change its properties.

A Perl stored procedure or function behaves like a SQL stored procedure or function except that the code for the procedure or function is written in Perl and the execution of the procedure or function takes place outside the database server (that is, within a Perl executable instance).

You must create a separate instance of the Perl executable for each connection that uses Perl stored procedures and functions. This behavior is different from Java stored procedures and functions. For Java, there is one instance of the Java VM for each database rather than one instance per connection. The other major difference between Perl and Java is that Perl stored procedures do not return result sets, whereas Java stored procedures can return result sets.

• Creating a Perl Object
  Install Perl and create a Perl object before installing the new Perl object into the SAP Sybase IQ database.
• Perl Objects in SQL Procedures and Functions
  When defining SQL procedures and functions referencing Perl objects, the LANGUAGE is always PERL and the EXTERNAL NAME string contains the information needed to call the Perl subroutines and to return OUT parameters and return values.
• 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.
• Updating a Perl Object
  Update a Perl object in an SAP Sybase IQ database.
• Deleting a Perl Object
  Remove a JAR file from an SAP Sybase IQ database.
• Viewing or Modifying Perl Object Properties.
  Display the properties of a Perl object associated with an SAP SAP Sybase IQ database. Only the comment can be modified.
• Testing the Configuration of a Perl External Environment
  Test the configuration of a Perl external environment to make sure the Perl object is accessible and responding.
• Viewing or Modifying Perl External Environment Properties
  Display and change the properties of a Perl external environment, including the location of the Perl object and the associated user.
• Perl External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various Perl external environment tasks.