UPPER function in Datastage filter stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sharmabhavesh
Premium Member
Premium Member
Posts: 38
Joined: Tue Jun 19, 2012 11:03 pm
Location: India

UPPER function in Datastage filter stage

Post by sharmabhavesh »

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?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The function is "upcase" and if it still doesn't like it, do it before the Filter stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply