Viewing or Modifying C ESQL Executable Properties

Display and change the properties of a C ESQL32 or C ESQL64 external environment, including the location of the executable and the associated user.

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

View any external environment property page – none.

Modify any external environment property – you must have DBA authority.
SAP Sybase IQ 16.0

View any external environment property page – none.

Modify any external environment property – you must have the MANAGE ANY EXTERNAL OBJECT system privilege.
Task
  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.
  3. Select a C ESQL32 or C ESQL64 external environment from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
  4. In the properties dialog, modify any of these:
    Option Description
    Location The path to the C ESQL32 or C ESQL64 executable.
    User The SAP Sybase IQ user or role/group that the external environment uses to log in to the database. The user or role/group must have been granted DBA authority (15.x) or the MANAGE ANY EXTERNAL ENVIRONMENT system privilege (16.x).
    Comment Notes describing the external environment.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Parent topic: Working in a C ESQL External Environment
Related tasks
Authenticating a Login Account for a Managed Resource
Related reference
Other External Environment Privilege Summary