Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > Siebel Tools Considerations on DB2 for z/OS >

Changing LONGVARCHAR Data Type to VARCHAR Data Type

To avoid ambiguity in the actual length of the underlying field, you can change LONGVARCHAR data types to VARCHAR data types on the physical schema.

To change a LONGVARCHAR data type to a VARCHAR data type

• Set the data type of Data Public type tables and their columns of type LONGVARCHAR to VARCHAR(n) at the physical schema level.

CAUTION:  Do not change the data type or width in the logical repository and apply the changes from Siebel Tools as errors can occur.

When performing schema synchronization, schema migration or upgrade tasks, ensure that rebuild statements are removed from the schema.sql file.

You do not need to modify the data type of Repository or System type tables.