To modify information in the schema holder at the field level:
1. Access the Data Dictionary, if you are not already there, and click Fields. The Fields list appears.
2. Select a table from the Tables list.
3. Select a field from the Fields list.
4. Click Field Properties. The following dialog box appears:
You can enter OpenEdge information at the field level, such as a validation expression or a validation message.
The Data Dictionary displays the standard ODBC SQL names for data types and not the native ODBC data-source names. Using the Data Dictionary, you can make the following changes:
Change the data type or the format in which OpenEdge displays data. For example, the Sybase smallint data type maps to the ODBC SQL SQL_SMALLINT data type, which in turn maps to the INTEGER data type. However, you can change the SQL_SMALLINT mapping to the DECIMAL or LOGICAL data type instead.
For CHARACTER fields that are not indexed, you can change the case sensitivity.
Note: You cannot create fields or add mandatory or extent properties to them.
5. Choose DataServer to view the field name and position as stored in the ODBC data source. A dialog box similar to the following appears:
Note: You cannot change ODBC data-source information using the Data Dictionary. For example, the custnum field is named custnum in the demonstration database.
6. Click OK.
7. When you are done making changes, click OK to return to the Data Dictionary main window.
Note: You can override field-level validation expressions in your application by including the appropriate ABL statement.
Change the data type or the format in which OpenEdge displays data. For example, the Sybase smallint data type maps to the ODBC SQL SQL_SMALLINT data type, which in turn maps to the INTEGER data type. However, you can change the SQL_SMALLINT mapping to the DECIMAL or LOGICAL data type instead.
