Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment > Siebel Tools Considerations on DB2 UDB for z/OS and OS/390 >
Changing LONGVARCHAR Datatype to VARCHAR Datatype
To avoid ambiguity in the actual length of the underlying field, a LONGVARCHAR datatype can be changed to a VARCHAR datatype on the physical schema.
To change a LONGVARCHAR Datatype to a VARCHAR Datatype
When performing ddlsync, dev2prod or upgrade, please make sure that rebuild statements are removed from the schema.sql file.
You do not need to modify the datatype of Repository or System type tables.