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

• The datatype of Data Public type tables and their columns of type LONGVARCHAR can be set to VARCHAR(n) at the physical schema level.

  NOTE:  Do not change the datatype or width from Siebel Tools in the logical repository and apply the changes.

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.