cast function in db2

SagarMelam · Post by **SagarMelam** » Wed May 27, 2015 2:06 pm

Hi,
can i use cast function to fetch a non nullable column to make it as nullable while extracting from a db2 connector to a dataset.

ray.wurlod · Post by **ray.wurlod** » Wed May 27, 2015 4:18 pm

Not CAST. CAST changes data type. Use one of the functions that convert NULL to a non-null value.

priyadarshikunal · Post by **priyadarshikunal** » Thu May 28, 2015 1:58 pm

not null to null? no function or transformation required. just map it to nullable column.

or if its null to not null, read Ray's reply.

kduke · Post by **kduke** » Thu May 28, 2015 8:39 pm

I see this all the time. They use NVL or something to scrub nulls. One guy did it on 1000 columns. His SQL was over 32K. Found a bug in that Oracle stage where it truncated it. So afraid to deal with nulls within DataStage itself. Really sloppy. Poor practice.