Filter a records

arnie_nits · Post by **arnie_nits** » Sat Jan 12, 2008 4:47 am

Hi,

Can we filter a record where the length of a particular field id >5.

I have used Len(EMP_ID)>5 in the where condition but I am getting error.

Regards
Arnie

ray.wurlod · Post by **ray.wurlod** » Sat Jan 12, 2008 5:24 am

Not permissible in a Filter stage. SQL functions are not supported. You need to use a Transformer stage either to do the filtering or to generate an actual length number that you can use in a downstream Filter stage. Or use string_length() or ustring_length() - as appropriate - in an upstream Modify stage.

Minhajuddin · Post by **Minhajuddin** » Sat Jan 12, 2008 5:33 am

arnie_nits wrote:Hi,
Can we filter a record where the length of a particular field id >5.

Yes. You can do this in a transformer by putting the appropriate constraint.

arnie_nits wrote: I have used Len(EMP_ID)>5 in the where condition but I am getting error.

Len(EMP_ID) in the where condition?

Len() is a datastage function and not an SQL function, so, if you are trying to run a query with this it won't work. The function to find length in SQL is Length().

If you are not using it in SQL then where are you using this function and what error are you getting?

ray.wurlod · Post by **ray.wurlod** » Sat Jan 12, 2008 2:55 pm

"WHERE condition" is a property of a Filter stage.

Minhajuddin · Post by **Minhajuddin** » Sun Jan 13, 2008 8:31 am

Oh, so lousy of me

DSXchange

Filter a records

Filter a records

Re: Filter a records