nulldefault

Replace NULL values with default values.

USYS$Mnemonic_PARAMS nulldefault = N | N0 | N1

Use

Applies to	Mnemonic	Connector Syntax
DB2 connector	DB2	`USYS$DB2_PARAMS`

By default, non-mandatory fields that are left blank are stored with database NULLs in columns that allow it.

If nulldefault is specified, non-mandatory fields that are left blank are stored with default values.

Caution: The nulldefault option is not supported for a DB2 database that holds the Uniface Repository.

Default Values with N Option
N	N0	N1	Type of Column	Default Value
X	X	X	Fixed-length character and graphic columns	Blanks
X	X	X	Variable-length character and graphic columns	String of length zero
X	X	X	Numeric data types	Zero (0)
X			Date, time, and timestamp	Current system time
	X		Date, time, and timestamp	Database NULLs
		X	Date	`0001-01-01`
		X	Time	`00:00:00`
		X	Timestamp	`0001-01-01-00.00.00.00`