Generating DDL Commands for a Logical Server Policy

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

Prerequisites

Database Version	Logical Server Policy Privileges
SAP Sybase IQ15.3 and 15.4	Not supported.
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 Server Policies.
Select one or more logical server policy 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 server policies.

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