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.

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

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Multiplex Management, and then select 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.