Missing Values (Nils) in CA-Datacom/DB Tables

When the interface view engine stores a missing value in a CA-Datacom/DB table, the missing value is represented by all blanks for both numeric and character type fields. When the engine retrieves a missing value, it appears as all blanks for SAS character columns and as a period (.) for SAS numeric columns.
Note: A system option is available if you want to set missing values to zeros.