DSXchange

Hi,

I am trying to load null into decimal column from file into a table and it is throwing warning. I have used Isnull function and tried to load space instead of null but it is throwing warning message. Can any one assist me in loading null into decimal without warnings.

Post your actual, unedited warning(s).

Below is the actual warning

Transformer_118: At row 13947, link "DSLink122", while processing column "COY_CONTR"
Value treated as NULL
Attempt to convert String value " " to Double type unsuccessful

Why convert the null to a space which is a value that cannot be loaded into a decimal field? Leave it alone, let it load as is.

You're not trying to load NULL, you're trying to load a space character, which (as noted) is not legal for Decimal data type. Therefore DataStage changes it to NULL and alerts you of that fact. To eliminate the warning, don't attempt to load " " into a Decimal field.