Varchar to bigint conversion

lindatgeorge · Post by **lindatgeorge** » Wed Sep 29, 2010 3:28 am

HI,

I have a datastage job which reads a file, and then some trnsformations are applied, and then loads into another csv file. Oneof the transformations is as below.

Col2=If IsNull(Col1) then SetNull() Else (Col1)

Here both Col1 and Col2 are nullable. Col1 is of 'Varchar' datatype and Col2 is 'BigInt'. After the transformations the NULL values from input file are loaded as '0' in the ouptput file ( it should be loaded as NULL values itself)

Is there any conversion function that can be applied to convert Varchar to BigInt.

Please help me on this

Thanks in advance...

ray.wurlod · Post by **ray.wurlod** » Wed Sep 29, 2010 4:57 pm

This is not an Information Analyzer question then?

lindatgeorge · Post by **lindatgeorge** » Wed Sep 29, 2010 10:18 pm

HI,

My question was how to convert a column from vbarchar to Bigint in datastage. Actually the issue is resolved now.It is getting implicitly convereted. The issue was that the incoming data was not being recognised as NULL. So we handled to recognise it as BLANK and the output is populated fine.

Thanks...

ray.wurlod · Post by **ray.wurlod** » Wed Sep 29, 2010 11:36 pm

So why did you post the question in the Information Analyzer forum?