Generating DDL for a Procedure

Generate the data description language for creating a procedure on a Sybase IQ server. The DDL code can be a useful reference and training tool.

Prerequisites

Create a procedure.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane of the Administration Console, expand IQ Servers > Other Objects and select Procedures.
In the right pane, select one or more procedures.
Select Resource > Generate DDL from the Administration Console’s menu bar.
A dialog displays the DDL statements.
Select and copy from the DDL dialog as needed; click Close when you are finished.