DataStage Case Conditions
Posted: Wed May 11, 2005 4:16 pm
Hello All,
I am using teradata as my source stage which is not case specific meaning which will get you ABC and abc when you do a query like where col1 = 'ABC' unless you use the caseSpecific funtion for the specific case.
The question I have here is when I try to use the terdata stage and write user define sql like
When I do the query on database like
SELECT COL1,COL2 FROM TABLE1 WHERE COL1 LIKE '%abc%' OR '%cdb%'.
it gives me all the existing results available in that column
abc,Abc,ABC.......
But as the datastage is case sensitive it is not retreiving all the possible values. Is there anyway that I can get all the possible values instead of saying in the where col2 like '%ABC%' or '%abc%'.
thanks
I am using teradata as my source stage which is not case specific meaning which will get you ABC and abc when you do a query like where col1 = 'ABC' unless you use the caseSpecific funtion for the specific case.
The question I have here is when I try to use the terdata stage and write user define sql like
When I do the query on database like
SELECT COL1,COL2 FROM TABLE1 WHERE COL1 LIKE '%abc%' OR '%cdb%'.
it gives me all the existing results available in that column
abc,Abc,ABC.......
But as the datastage is case sensitive it is not retreiving all the possible values. Is there anyway that I can get all the possible values instead of saying in the where col2 like '%ABC%' or '%abc%'.
thanks