UPPER function in Datastage filter stage
Posted: Sun Jun 29, 2014 12:11 pm
Hi,
I am trying to compare a record in Datastage filter stage with the following condition:
upper(record) like '%PLAN%'
when I run the job I get the following error
Parse error: Expected comparison, 'between', or 'like' operator, got: "upper"
When I remove the upper function, the code runs without error.
How can I convert the record into upper/lower case for comparison?
I am trying to compare a record in Datastage filter stage with the following condition:
upper(record) like '%PLAN%'
when I run the job I get the following error
Parse error: Expected comparison, 'between', or 'like' operator, got: "upper"
When I remove the upper function, the code runs without error.
How can I convert the record into upper/lower case for comparison?