how to import/manually code Number datatype(Oracle) into DS

[ameet.penkar]

Hi

In our back end, one of the columns is defined as Number(NO Precision and NO scale given).When metadata is imported, DS takes it as Decimal(38,0).
In practice, we require the Scale very much, and the job gives warnings

Any suggestions on how to tckle this?

Ameet

[ogmios]

Change it manually to e.g. Decimal(40,0)

Ogmios

[roy]

Hi and welcome aboard.
what is you import method (ODBC or plugin)?, if you use ODBC try using native plugin.
what do you see when you extract the table's meta data via the DB tools in that column's definition?
In My Humble Opinion defining numeric/decimal columns as default percision and scale is not good practice but some people mihgt think otherwise.
if the actual DDL has only numeric and no scale/percision you can try getting the DBA's to change it or manualy change your table definitions to meet your needs (as already said).

IHTH,