Generating Remote Server DDL Commands

Generate data description language for one or more remote servers. The DDL can be a useful resource and training tool.

Prerequisites
Database Version Remote Server Privileges
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 None.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Networks, and then select Remote Servers.
  3. Select the remote server from the right pane and either:
    • Click the arrow to the right of the name and select Generate DDL, or
    • From the Administration Console menu bar, select Resource > Generate DDL
    The DDL view opens, showing the SQL code used to create the selected remote server.
Related tasks
Creating a Remote Server
Testing a Remote Server Connection
Deleting a Remote Server
Viewing or Modifying Remote Server Properties
Authenticating a Login Account for a Managed Resource
Related reference
Remote Server Privilege Summary