Description
When defining a character field in a table, is there a way for certain fields to default to spaces if nothing is put into the field through application programs?
Solution
By using the DBEDITS field attribute functionality of the Datadictionary, you can enable special CA-Datacom/DB processing for both data editing and default processing. For example, a field can be defined to allow nulls or not. It can also be set to use various defaults, based on the type of data stored in the field.
To add this functionality to a field, use the Batch Datadictionary FIELD maintenance transaction 4012, or follow this process through Datadictionary Online (DDOL):
<Please see attached file for image>
<Please see attached file for image>
<Please see attached file for image>
<Please see attached file for image>
<Please see attached file for image>
<Please see attached file for image>
Be aware that if you change the attributes of a field for an existing table, you need to review programs that maintain this table to ensure that your changes are compatible with your current processing.
For further information about the values of the various FIELD attributes, please refer to the CA Datacom Datadictionary Attribute Reference Guide.
For further information about Default values and FIELD edit criteria, please refer to the CA Datacom/DB Database and System Administrator Guide.
For further information about using batch Datadictionary Maintenance transactions, please refer to the CA Datacom/DB Datadictionary Batch Guide.