how to load null into decimal datatype without warning

Jagan617 · Post by **Jagan617** » Fri Mar 04, 2011 8:25 pm

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.

chulett · Post by **chulett** » Fri Mar 04, 2011 9:31 pm

Post your actual, unedited warning(s).

Jagan617 · Post by **Jagan617** » Sat Mar 05, 2011 6:23 pm

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

chulett · Post by **chulett** » Sat Mar 05, 2011 9:33 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 06, 2011 1:35 am

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.