ddlgen

A Java-based tool that generates definitions for server- and database-level objects in an SAP ASE server.

The command-line version of ddlgen is located in:
  • (UNIX) $SYBASE/$SYBASE_ASE/bin.

  • (Windows) %SYBASE%\%SYBASE_ASE%\bin.

Syntax

ddlgen 
	-Ulogin
	-Ppassword
	-S[[ssl:]server | host_name : port_number]
	[-I interfaces_file]
	[-Tobject_type]
	[-Nobject_name]
	[-Ddbname]
	[-Cproperty_name=property_value]
	[-Xextended_object_type]
	[-Ooutput_file]
	[-Eerror_file]
	[-Lprogress_log_file]
	[-Jclient_charset]
	[-LC -N logical_cluster_name
	-F[ % | SGM | GRP | USR | R | D | UDD | U | V | 
		P | XP | I | RI | KC | TR | PC ]
Or
ddlgen -v

Parameters

Examples

Permissions

Users must have either sa_role or sso_role to generate DDL for:

  • Encryption keys

  • Logins

  • Roles

For all other objects, users do not need any specific permissions or roles to generate DDL.

Related concepts
Utility Commands Reference
Database Creation and Manipulation Utilities
Related tasks
Hiding Passwords in ddlgen