6.3 OMITNULL | INCLUDENULL

Use OMITNULL and INCLUDENULL to omit or include the word NULL for columns that can contain null values. Assuming the column can be set to null, DDLGEN outputs the following definitions:

  • If INCLUDENULL (or nothing) is specified, the output is:

    COL CHAR (10) NULL
    
  • If OMITNULL is specified, the output is:

    COL CHAR (10) 
    

The default templates for each supported database already include the correct setting for this argument.

Default

INCLUDENULL

Syntax

OMITNULL | INCLUDENULL