Viewing or Modifying C ODBC Executable Properties

Display and change the properties of a C ODBC32 or C ODBC64 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 required.

Modify any external environment property – Requires DBA authority.
SAP Sybase IQ 16.0

View any external environment property page – None required.

Modify any external environment property – Requires 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 ODBC32 or C ODBC64 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 ODBC32 or C ODBC64 executable.
    User The 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. Click Apply to save your changes and keep editing, or click OK to save and close the properties dialog.
Parent topic: Working in a C ODBC External Environment
Related tasks
Authenticating a Login Account for a Managed Resource
Related reference
Other External Environment Privilege Summary