Default Row Specification

Default row specification requires you to define a predefined record, ensuring there is always a default entry in the table and maintaining schema integrity.

Syntax:

default_row_specification ::= DEFAULTROW default_column_list ;
default_column_list ::= '[' (THIS[<column_list>] '=' (PARAMETER '[' <parameter_name> ']' | 
<constant_value>); )+ ']'

Example:

IMPORT SOURCE CUSTOMERS
/* not listed columns are assigned NULL */
DEFINE DATASET CUSTOMERS_DEFAULT 
 ROWSOURCE CUSTOMERS;
 THIS = CUSTOMERS;
 DEFAULTROW
 [ THIS[CUST_ID] = -99999;
 THIS[CUST_FIRST_NAME] = 'Unknown';
 ]
 PRIMARYKEY[CUST_ID];
END

If you omit a column's default value, it defaults to NULL.