Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Adding Custom Extensions to the Data Model > Updating the Logical Schema Definition in the Local Environment >

Creating Extension Columns of Type LONG

---

You can create an extension column of type LONG, but you are limited to one column of this type per table. When configuring LONG columns, consider the following:

• You can only add LONG columns to 1:1 Extension Tables that have a valid base table identified in the Base Table property of the table object definition.
• You cannot add LONG columns to tables of type Data (Public), such as S_EVT_ACT. Siebel Systems reserves the right to implement LONG columns in these tables in the future.
• You can use LONG columns store a maximum of 16 KB or 16383 characters.

To create a LONG extension column

1. Find an appropriate 1:1 extension table that corresponds to the base table that needs the LONG column available.

   An example of a 1:1 extension table for S_EVT_ACT, for instance, is S_EVT_ACT_X.

2. For the column that is created in the table, set the Physical Type to 'Long' and Length set to '0'.

   You apply the LONG extension column like any other custom extension column.

3. Create a new field that maps to the extension column.

Bookshelf Home | Contents | Index | Search | PDF