DQ814E - CANNOT DETERMINE THE CONTEXT OF THE WORD INDICATED BY THE CURSOR

Products

• Datacom

Issue/Introduction

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
                 **

 

 

 

Environment

Release : 15.1

Component :

Resolution

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 )

 

Additional Information

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