By default, a data type is applied to every attribute in a logical model and to every column in a physical model. In the logical model, the data type is determined by the domain from which the attribute inherits its properties or from the data type that you assign. In the physical model, the data type is determined by the default value specified by the target server or the data type that you assign.
When you create a table, each column that you add to the table must have an associated data type such as CHAR, DATE, NUMBER, or SMALLINT. The data type specifies the field length, acceptable characters, and optional and required parameters. For example, CHAR(18) specifies that the column can store up to 18 alpha and numeric characters. Using the Defaults tab of the Model Editor, you can specify a default data type that is automatically attached to each column. You change the data type for a column using the Column Editor.
Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |