Is there a lower case function in DataStage?

techiexavier · Post by **techiexavier** » Mon Nov 18, 2013 12:11 am

Hi All,

My job design is as below,

Oracle connector --> Transformer --> DataSet

Id Varchar(10)

I have requirement where if get records with "id" field in lower case i need to drop those records. Please let me know how can i perform that in DS.

TIA.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 18, 2013 12:19 am

Code: Select all

Downcase()

chulett · Post by **chulett** » Mon Nov 18, 2013 8:00 am

To expand on that, compare the field value with a downcase'd version of the same field. If they are equal then you know it came in all lowercase.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Nov 18, 2013 10:11 am

Ray has obviously decided to limit his responses to one word replies so he can hit more topics and raise his post count...

ray.wurlod · Post by **ray.wurlod** » Mon Nov 18, 2013 12:33 pm

I answered the question in the subject line.

techiexavier · Post by **techiexavier** » Mon Nov 18, 2013 10:22 pm

Is there a Islower case function in DataStage? - Updating the subject line

- Sorry this should be the subject line. that is the typo error.

chulett · Post by **chulett** » Tue Nov 19, 2013 8:26 am

No... but I've already explained how to solve your problem. And all of the functions are documented, so there's really no need to ask what might be available.