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.

Prerequisites
Database Version External Environment – PHP Privileges
SAP Sybase IQ 15.3 and 15.4

View external environment properties – none.

Modify external environment properties – you must have DBA authority.

SAP Sybase IQ 16.0

View external environment properties – none.

Modify external environment properties – you must have the MANAGE ANY EXTERNAL OBJECT system privilege.

Task

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

  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Compiled Objects > External Environments > PHP.
  3. Click the arrow beside PHP and select New.
    The Install PHP Object wizard appears.
  4. On the Welcome page, specify:
    Option Description
    Select an SAP Sybase IQ resource on which the PHP object will be installed: Select an SAP Sybase IQ resource from the list.
    (Multiplex only) Select a multiplex server on which the PHP 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.
    PHP script path Enter the path to the PHP object. It must be on a file system accessible to the SAP Sybase IQ resource.
    PHP object name in the database Enter the PHP object name.
    Comment (Optional) Enter a comment describing the PHP object.
  5. Click Finish to install the PHP object.
Related tasks
Creating a PHP Object
Updating a PHP Object
Deleting a PHP Object
Viewing or Modifying PHP Object Properties
Testing the Configuration of a PHP External Environment
Viewing or Modifying PHP External Environment Properties
Authenticating a Login Account for a Managed Resource
Registering and Authenticating an SAP Control Center Agent
Related reference
PHP External Environment Privilege Summary