Generating Procedure, Table UDF, or TPF DDL Commands

Generate the data description language for creating a procedure, remote procedure, Table UDF, or TPF on an SAP Sybase IQ server. The DDL code can be a useful reference and training tool.

Prerequisites
Database Version Procedure 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 > Compiled Objects, and then select Procedures.
  3. Select one or more procedures, remote procedures, Table UDFs, or TPFs 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 procedures.
    The DDL view shows the SQL code used to add the selected procedures.
Related tasks
Creating a Procedure
Creating a Remote Procedure
Creating a Table UDF or TPF
Executing a Procedure, Table UDF, or TPF using View Data in SQL
Deleting a Procedure, Table UDF, or TPF
Viewing or Modifying a Procedure, Table UDF, or TPF
Granting Procedure EXECUTE Permission
Revoking Procedure EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Procedure Privilege Summary