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...
Varchar to bigint conversion
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
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...
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...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: