A Java-based tool that generates definitions for server- and database-level objects in Adaptive Server. ddlgen supports ASE version 12.0 and later.

ddlgen -U login -P password -S [server | host_name:port_number] [-I interfaces_file] [-T object_type] [-N object_name] [-D dbname] [-X extended_object_type] [-O output_file] [-E error_file] [-L progress_log_file] [-J client_charset] [-v] [-F [filter]]

Parameter information :

»	-U : specifies a login name, and is case-sensitive.
»	-P : specifies your password.
»	-S : Specify either a servername or hostname + portnummer where ASE is listening on.
»	-I : specifies the interfaces file name, and corresponds to $SYBASE/interfaces for UNIX, and %SYBASE%\ini\sql.ini for Windows.
»	-T : specifies the type of object you are creating. If you do not use -T, ddlgen generates DDL for the default database of login.
»	object_type : Type of object Possible values: C : Cache, D : Default, DB : Database, DBD : Database device, DPD : Dump device, EC : Execution class, EG : Engine group, EK : encrypted keys, GRP : Group, I : Index, KC : Key constraint, L : Login, LK : Logical key, P : Stored procedure, R : Rule, RI : Referential integrity, RO : Role, RS : Remote server, SGM : Segment, TR : Trigger, U : Table, UDD : User defined datatype, USR : User, V : View, WS : user defined web service, WSC : web service consumer, XP : Extended stored procedure
»	-N : specifies the fully qualified name of the object you are creating, such as -Ndb_name.owner_name.table_name.object_name.
»	-D : specifies the name of the database for the object you specify in the -N option. The default is the user's default database.
»	-X : Differentiation of object types tables, databases and stored procedures.
»	-O : specifies an output file for the generated DDL. If you do not specify -O, the DDL you create appears in a window.
»	-E : specifies a log file for recording errors. If you do not specify -E, the generated errors appear in a window.
»	-L : specifies a log file for recording the progress of ddlgen. If you do not specify -L, the progress is not recorded.
»	-J : specifies the character set to use on the client.
»	-v : Display version number
»	-F : filters out indexes, triggers, and constraints out of table and database definitions in the DDL of table- and database-level objects.
»	filter : Filter option Possible values: % : filters out everything, and retrieves the schema-only definition of a table., D : Defaults, GRP : Groups, I : Indexes, KC : Primary and unique key constraints, P : Stored procedures, PC : Partition condition, R : Rules, RI : Referential Integrity Constraints, SGM : segments, TR : Triggers, U : User tables, UDD : User defined datatypes, USR : Users, V : Views, XP : Extended stored procedures