Built-in Open Query with the *RNGSVR Keyword (Magic xpa 3.x)
Alternately, you can use the *RNGSVR keyword to issue the RANGE operation built inside the program by using the OPNQRYF command instead of the ISAM Range operation. You should use the *RNGSVR keyword and valid query statement to run the OPNQRYF command with the Magic xpa RANGE operation, combined with a query statement (combined via AND).
If a Range is defined in a task and the keyword *RNGSVR exists in either the DBMS properties, Database properties, or the Open Query statement, the following Range clauses will be included:
|
|
|
A
|
B
|
Field >=A *AND Field <=B *OR Field %RANGE(A B))
|
A
|
-
|
Field >=A
|
-
|
B
|
Field <=B
|
NULL
|
NULL
|
Field=%NULL
|
NULL
|
-
|
Field=%NULL
|
|
NULL
|
Field=%NULL
|
NULL
|
B
|
Field=%NULL
|
A
|
NULL
|
Field=%NULL
|