Handle NUMBER (no p,s) as FLOAT or INTEGER - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The omnient.ini file [Director] section controls whether the Connect CDC Director assumes a NUMBER, no p,s, is defined internally as a FLOAT or an INTEGER:

OracleNUMBERWithoutPrecisionOrScaleIsINTEGER=<1 or 0>
  • If this is set to 1, NUMBER is NUMBER(22).

  • if this is set to 0, NUMBER is FLOAT.

The table must be refreshed in order for this NUMBER interpretation to be in effect.