Utilities

Adaptive Server 15.0.2 supports enhancements to the ddlgen utility.

Change Description
ddlgen prompts for password. In version prior to 15.0.2, failing to include the -P password parameter returned an error. ddlgen now prompts for the password.
ddlgen supports both pre-15.0.2 and 15.0.2 encryption. Sample syntax:
ddlgen -Usa -P -Sserver 
-TEK -NSampleKeysDB.dbo.ssn_key
ddlgen without the -XOD flag Two things can happen:
  • If users do not specify a password when the encryption key is created, ddlgen generates DDL with no password.
  • If users specify a password when the encryption key is created, ddlgen generates a default password.
ddlgen with the -XOD flag Generates a system encryption password.
Key copy support ddlgen can generate DDL for key copies and for the base key.

See the Utility Guide.