Do you want to Search Something?

Those who opened the gates

Friday, September 2, 2011

CLOB Physical Type in Siebel

Character Large Object (CLOB) Physical Type
The Character Large Object (CLOB) physical type stores a large, variable amount of text. Siebel CRM version 8.0 and higher supports this text. CLOB is similar to Long, but it can contain much more data. In an Oracle database, the maximum size is (4 GB minus 1 byte) multiplied by the value in DB_BLOCK_SIZE.
Note the following requirements:
  • Because a column in a Siebel table is limited to 128 KB of data, you cannot define a column of type CLOB that is greater than 128 KB.
  • Siebel CRM allows no more than three CLOB columns for each table.
  • In Siebel Tools, you can only set the physical type to CLOB when you define a column. You cannot change a predefined column, such as a Long column, to a CLOB column.
  • Siebel Tools displays the CLOB Physical Type as L (Long) in the Properties window.
  • Because MS SQL Server does not define a CLOB type, MS SQL Server treats a CLOB as a varchar(max) or nvarchar(max) object.
  • To query on a DTYPE_CLOB field, you must use at least one wildcard in the search expression. You use an asterisk (*) to express a wildcard. For example, use TEST*. Do not use an equal sign (=) in the query. For example, do not use =TEST. If you use an equal sign, then Siebel CRM generates an error.
Maximum Number of Digits for a Numeric Physical Type
If the Physical Type property of a table column is Numeric, then the table column can contain up to 16 digits. Note the following for the numeric physical type:
  • As Siebel CRM increases the number of digits it uses to the left of the decimal point, the number of usable digits to the right of the decimal point decreases by an equal amount.
  • Data is limited to 16 digits without a decimal point.
  • If you use a decimal point, then data is limited to 15 digits to the left of the decimal point.
  • You cannot use more than 7 digits to the right of the decimal point.
  • You cannot change precision or scale properties to change this support.
  • Some rounding errors can occur with a 16 or 15 digit number.