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.
Table 12. 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: