Page 1 of 1
Sort stage Warnings
Posted: Mon Oct 04, 2004 6:49 am
by larryoceanview
Any way to turn warnings off from a sort stage into a transform?
Code: Select all
Sort_10: At row 1, link "DSLink24", while processing column "FUBAR"
Value treated as NULL
Attempt to convert String value "" to Long type unsuccessful
Thanks,
Posted: Mon Oct 04, 2004 7:24 am
by chulett
Only way to "turn them off" is to ensure they don't occur. Looks like you have an "empty" field that is being moved into a Long datatype and it doesn't like that. Can you check for and transform that to something else before the Sort stage, like to a NULL or a Zero perhaps?
Just peachy!
Posted: Mon Oct 04, 2004 7:39 am
by larryoceanview
chulett wrote:Only way to "turn them off" is to ensure they don't occur. Looks like you have an "empty" field that is being moved into a Long datatype and it doesn't like that. Can you check for and transform that to something else before the Sort stage, like to a NULL or a Zero perhaps?
If time permits, but I have about 50 different fields with similiar errors and some have valid data. I just wanted to supress the warning like in the file stages. Shouldn't the sort stage be consistent with the file stages?
Thanks,
Posted: Mon Oct 04, 2004 7:47 am
by chulett
What "file stages" are you referring to that allow you to suppress fundamental data type mismatch warnings like this?
Posted: Mon Oct 04, 2004 8:00 am
by larryoceanview
chulett wrote:What "file stages" are you referring to that allow you to suppress fundamental data type mismatch warnings like this?
Format sequential file stage- suppress row truncation warnings!
Posted: Thu Oct 07, 2004 3:37 am
by mandyli
Please handle null values.
Thanks
Man
Posted: Sun Oct 10, 2004 3:24 pm
by gh_amitava
Hi,
Set the "Nullability" of the field to "Yes"
Regards
Amitava