Sql Like Clause in DataStage EE

pimmit22043 · Post by **pimmit22043** » Sat Sep 29, 2007 9:06 pm

Hi

I have job which i need to find values for a column like '%range%'
how do i get all the values like '%range%'

Thanks alot for your time.

Minhajuddin · Post by **Minhajuddin** » Sun Sep 30, 2007 12:15 am

A simple search would have given you many posts which discuss about this......

you can use Index, Count or Dcount to implement this..

ray.wurlod · Post by **ray.wurlod** » Sun Sep 30, 2007 2:28 am

What's the source of data? If the source is accessed via SQL, all you need to do is to incorporate an appropriate restriction in a WHERE clause.

pimmit22043 · Post by **pimmit22043** » Sun Sep 30, 2007 7:16 am

Hi

this is the values i need like '%range%'

how do i use the count or dcount or index to look for the above values.

Thanks for your reply.

bgs_vb · Post by **bgs_vb** » Mon Oct 01, 2007 9:09 am

Hi RK,

If you are using DRS Stage then you have a where tab in which you can write your conditions.

Thanks,
bgs_vb

DSguru2B · Post by **DSguru2B** » Mon Oct 01, 2007 10:37 am

Use a constraint, a simple < or > will bring the range effect.

DSXchange