DBNULL=

DBNULL=

Indicates whether NULL is a valid value for the specified column(s).

Default value: YES

Syntax
Details

Syntax

DBNULL=(_ALL_=YES | NO) | (<column-name-1=YES | NO> <... <column-name-n=YES | NO>>)

column-name: is a column in the Teradata table that is being created.
YES: indicates that a NULL value is valid for the specified column(s) in the Teradata table.
NO: indicates that a NULL value is not valid for the specified column(s) in the Teradata table.
_ALL_: indicates that the YES or NO value applies to all columns in the Teradata table.

Details

When you use SAS/ACCESS to create tables, specifying YES tells Teradata to allow a null value for the column specified. In contrast, specifying NO causes SAS/ACCESS to append 'NOT NULL' to the column definition of the CREATE TABLE statement that it submits to Teradata. Consequently, Teradata will not accept a null value as valid for the given column.

For more information on the DBNULL= option, see DBNULL=.

Chapter Contents
Previous
Next
Top of Page