Many ANDs in Sybase request

[Palmero]

Hi all,
I am searching information about the following error message on Sybase 11.5:
Number : 404
Severity : 19
Text : Too many ANDs or ORs in expression (limit %d per expression level). Try splitting query or limiting ANDs and ORs.
Note that I have many ANDs in my request.

Thanks in advance for your help.
Palmero.

 

[qyllr]

hello...

here is what sybase recommends...

Explanation
This error occurs when you use more than 251 and or or expressions in a query.

This error also occurs if you exceed the limit of 251 values in a where in clause. For example:

1> select * from old_table
2> where old_column in (1,2,3...,253,254,...)
3> go

Write the query so that the limit is not exceeded. Often, this requires that you split the query.


q.

 

[somnath74]

That is correct it has got to do with the limitation of the sybase client buffer.