Geek asks and answers

Informix: limiting the number of elements in an IN section?

Is there a limit on the number of elements that can be included in an IN clause in an Informix query (for example, a limit of 1000 units in Oracle)?

We have a "large" (possibly 2000) list of element numbers passed through the web service for selection, so there really is no context available outside the list of elements.

+3
source share
1 answer

The upper limit is imposed by the space that will be accepted to create an IN list and a limit of 64 KiB for operators. Usually you can get several thousand small (6-7 digits) integers without any problems at the syntax level.

, , , , .

+1

More articles:


All Articles