Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > About Creating Custom Extensions to the Siebel SchemaThere are several different possible scenarios for creating Siebel Schema custom extensions:
CAUTION: If a LONG VARCHAR column is defined for a table, attempting to add an extension column to the table causes an error. This is because a LONG VARCHAR column uses all the space in a table space that is not used by the non-LONG VARCHAR columns, leaving no space available for an extension column. In this case, use an extension table instead. For further information, see How Siebel Implements LONG Columns on DB2 for z/OS. The process of creating a small extension column is the same on z/OS as on other platforms and is documented in Using Siebel Tools. To create a large extension column or an extension table, you must specify a 16 KB or 32 KB table space:
NOTE: Creating tables with Identity type columns or extension columns of Identity type is not supported. For information on estimating storage needs, see Preparing for Implementation on the DB2 Host. |
![]() |
![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |