QMF allows you to specify a default indicator for columns that can support a default or a null indicator for columns that support null. For example, when you type the column default indicator in a table editor field that supports it, QMF uses the default value for the field. If you specify the column default indicator for a column that has the system date defined as its default, QMF uses the system date in that column. Table 12 describes the column default and null indicators.
Indicator | Character initially provided with QMF | Global variables that define the indicator character |
---|---|---|
Column Default | + | DSQCP_TEDFLT, DSQCP_TEDFLT_DBCS |
Null | - | DSQCP_TENULL, DSQCP_TENULL_DBCS |
If you specify the column default for a column that does not have a default, QMF returns an error message, and prompts you to correct your entry. Possible reasons QMF might not be able to detect a default value are: