Generating DDL Commands for a Logical Server

Display the SQL data description language for creating a new logical server. The SQL code can be a useful reference and training tool.

Prerequisites

Database Version	Logical Server Privileges
SAP Sybase IQ 15.3 and 15.4	None required.
SAP Sybase IQ 16.0	None required.

The SAP Sybase IQ resource is authenticated and running.
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Multiplex Management > Logical Servers.
Select the logical 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
Tip: Use Shift-click or Control-click to select multiple logical servers.

The DDL view opens, showing the SQL code used to create the selected logical servers.