RDOHELP72.HLB  —  Value expr, missing_values, Usage Notes
    o  The default value for a field ("Rdb default" in displays by the
       SQL statement SHOW TABLE table-name) is not the same as the missing
       value that you can specify with RDO.  If you do not specify a value
       for a field (column) with a default value, the default value is
       actually stored in the database. This is true whether you are using
       RDO or SQL.

       An RDO missing value is not actually stored in the database. If you
       use RDO to specify a missing value for a field, that missing value
       is displayed by RDO when the field has no value stored and the
       internal null flag is set. SQL does not recognize any missing value
       specified by RDO; if the field has no value stored and the null flag
       is set, then SQL displays "NULL" for the column, regardless of
       whether you specified any missing value with RDO.

       One implication of the way in which Oracle Rdb handles default values
       is that if you change the default value for a column, it has no
       effect on any existing data in the database; that is, rows stored
       with columns containing the "old" default values are not changed.
       By contrast, changing the missing value does change what is displayed
       by RDO-based applications for columns that have no value stored and
       that have the null flag set.

    o  The value of RDB$MISSING is set at compile time.  If the missing
       value for a field is changed, then sources that contain references
       to RDB$MISSING for that field still use the old missing value.  To
       correct this problem, all sources that contain a reference to
       RDB$MISSING on the field must be recompiled.
Close Help