Problems with Null representation
Posted: Thu May 04, 2006 1:35 pm
Hi
I am having a strange problem with Datastage
In the job I am getting Input File as fixed width and in place of null we have blank.
I generally TRIM then value and then check ISNULL - then handle it accordingly{ ISNULL(TRIM(LinkName.ColumnName)}
But Datastage cannot understand that TRIM(" ") is equal to Null.
Even I tried in a routine:
But I am always getting 'NULL NOT WORKING'
But generally as far sa I know I always handle Null with the ISNULL. I have no clue-please help me in this regard.
Is there a internal representation of NULLs in Datastage- if so what is the representaion.
Thanks
I am having a strange problem with Datastage
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
In the job I am getting Input File as fixed width and in place of null we have blank.
I generally TRIM then value and then check ISNULL - then handle it accordingly{ ISNULL(TRIM(LinkName.ColumnName)}
But Datastage cannot understand that TRIM(" ") is equal to Null.
Even I tried in a routine:
Code: Select all
If TRIM(' ') = @NULL Then Ans='NULL WORKING' Else Ans='NULL NOT WORKING'
But generally as far sa I know I always handle Null with the ISNULL. I have no clue-please help me in this regard.
Is there a internal representation of NULLs in Datastage- if so what is the representaion.
Thanks