Can we set the default to null!!

nynali · Post by **nynali** » Mon Jul 02, 2007 3:01 am

Hi,
I am having some decimal columns in my Source sequential file.
Whenever I get junk data for these(which is not decimal) I want to default them to NULLS.Please let us know if this can be done??

ArndW · Post by **ArndW** » Mon Jul 02, 2007 4:19 am

nynali - it would be better to post in the appropriate forum, but I'm sure a moderator will find this thread and relocate it.

You can set the the default value by right-mouse clicking on the colum and then "edit row" to get to the details.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 24, 2007 6:47 pm

Well, we still have no idea whether this is a server job question or a parallel job question. Therefore we still have no way to answer it, apart from "yes", or "maybe (it depends where)".

bkumar103 · Post by **bkumar103** » Thu Oct 04, 2007 2:39 am

Yes this is possible but process may differ from server job to Parallel job.
To set the value to null you have @NULL in server jobs and setnull() function in parallel job. Before assigning the null value you have to check the incoming field value is junk. There are different function available to check the format of the incoming data.