When defining a view, any expression in the SELECT expression list can include a data definition. The data type attributes determine the form of the view display. The data type attributes for a view column can differ from those defined for the associated column of the underlying base tables or views. However, not all data definitions are relevant to view expressions.
If you define data type attributes for a view column, these attributes override any data type attributes defined for the associated column of the underlying base tables or views. For example, a TITLE phrase in the CREATE VIEW statement overrides a TITLE phrase in the CREATE TABLE statement of the underlying table.
Any data type attributes defined for a column in the underlying base tables or views are carried over to the view only if the associated view column is not modified in any way.