An online DQL query with 40 conditions being tested for yields the following error:
DQ814E - CANNOT DETERMINE THE CONTEXT OF THE WORD INDICATED BY THE CURSOR
COUNT ALL PERSONNEL ROWS
WHERE (NUMBER = 1
OR 2
OR 3
OR 4
OR 5
OR 6
OR 7
OR 8
OR 9
OR 10
...
OR 22
OR 23
OR 24
OR 25
DQ814E - CANNOT DETERMINE THE CONTEXT OF THE WORD INDICATED BY THE CURSOR
OR 17
**
Release : 15.1
Component :
There is a limit of 15 OR entries in a WHERE or WITH statement and a limit of 15 values per OR.
The WHERE/WITH can be recoded as follows to have up to 15 values per OR with multiple ORs:
WHERE (NUMBER = 1 2 3 4 5 6 7 8 9 10
OR NUMBER = 11 12 13 14 15 16 17 18 19 20
OR NUMBER = 21 22 23 24 25 26 27 28 29 30
OR NUMBER = 31 32 33 34 35 36 37 38 39 40 )
Limitations are documented under the WITH clause here:
https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/reference/ca-dataquery-reference/dql-statements/with-clauses-dql.html
The maximum number of literal values per WITH statement is 15.
The maximum number of OR entries in a WITH statement is 15