Changing Column Length of Extention Table Columns (Doc ID 525206.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.2.216 [16084] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084]
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Microsoft Windows 2000 Server SP 3
Checked for Relevance on 20-03-2015
This document was previously published as Siebel SR 38-1313877641.


Goal

Need to add a new field to the Internal Product BC. Need a field where it can store formatted text. By formatted, need to be able to have carriage returns and tabs saved.

The questions:

1. The KB and bookshelf mention that developers can change the length of "Extension" type columns, but not any standard "Base" table columns. The KB also mentions that the _X tables (S_PROD_INT_X) are considered base tables. So, can I or can I not change the length of say, ATTRIB_01 on the table S_PROD_INT_X which has a type of "Extensions" and a Physical Type of "VARCHAR" from a length of 100 to a length of 2000?

2. If cannot change the length of the _X extension table Extension columns, it it better off adding an addition column to S_PROD_INT or add it to S_PROD_INT_X or need to create an additional extension's table, CS_PROD_INT_X, to create the column?

3. Will Carriage Returns and tabs be kept intact in the VARCHAR columns when the user's enter them through the interface?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms