Trim Char Datatype
Posted: Tue Dec 16, 2008 3:53 am
Hi
I am trying to TRIM the Char datatype in Transformer stage.
Process
---------
Output column from teradata isCHAR datatype. At times when lookup fails the column will not be populated(It must be NULL). BUT when I try to check it for NULL or '' , its not working. When i check the length of the column its always 4, though in unix its is NULL.
I tried
TRIM(inputcolumn,'','D') -Not working
Convert() not working.
Any way to Trim the CHAR datatype , so that I can check IsNull function.
Thanks
I am trying to TRIM the Char datatype in Transformer stage.
Process
---------
Output column from teradata isCHAR datatype. At times when lookup fails the column will not be populated(It must be NULL). BUT when I try to check it for NULL or '' , its not working. When i check the length of the column its always 4, though in unix its is NULL.
I tried
TRIM(inputcolumn,'','D') -Not working
Convert() not working.
Any way to Trim the CHAR datatype , so that I can check IsNull function.
Thanks