Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > How Siebel Implements LONG Columns on DB2 for z/OS >

Changing LONG VARCHAR Data Types to VARCHAR Data Types

To avoid ambiguity in the actual length of the underlying field, you can change a column defined with a LONG VARCHAR data type to a VARCHAR data type by setting the data type of Data Public type tables and their columns of type LONG VARCHAR to VARCHAR(n) at the physical schema level.

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

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