Working in a PHP External Environment

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

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

You must create a separate instance of the PHP executable for each connection that uses PHP stored procedures and functions. This behavior is quite 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 PHP and Java is that PHP stored procedures do not return result sets, whereas Java stored procedures can return result sets. PHP only returns an object of type LONG VARCHAR, which is the output of the PHP script.

• Creating a PHP Object
  Install PHP and create a PHP script before installing the new PHP object into the SAP Sybase IQ database.
• Installing a PHP Object
  Install a PHP object into an SAP Sybase IQ database. After installing it, you can reference the object in SQL procedures and functions.
• Updating a PHP Object
  Update a PHP object in an SAP Sybase IQ database.
• Deleting a PHP Object
  Remove a PHP object from an SAP Sybase IQ database.
• Viewing or Modifying PHP Object Properties
  Display the properties of a PHP object associated with an SAP Sybase IQ database. Only the comment can be modified.
• Testing the Configuration of a PHP External Environment
  Test the configuration of a PHP external environment to make sure the PHP object is accessible and responding.
• Viewing or Modifying PHP External Environment Properties
  Display and change the properties of a PHP external environment, including the location of the PHP object and the associated user.
• PHP External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various PHP external environment tasks.