Was this helpful?
Default and explicitly declared range variables cannot be used as though they were identical, because they refer to different copies of the same table. Using a default and a declared range variable in the same query results in a disjoint query, whose results are seldom what you want and often disastrous.
If you are using EQUEL, range_var and tablename can be specified using host variables.
A maximum of 126 range variables can be in effect at any time. After the 126th range statement, the least recently used range variable is replaced by the next range statement. This limit includes both default and explicitly declared range variables.
Last modified date: 06/08/2023