Operating system: All
Default=NO, Values: YES or NO
This registry variable controls where the SELECTIVITY clause can be used in search conditions in SQL statements.
When this registry variable is set to YES, the SELECTIVITY clause can be specified for the following predicates:
A basic predicate in which at least one expression contains host variables
A LIKE predicate in which the MATCH expression, predicate expression, or escape expression contains host variables
As per this info, there is no ALL in the values list. where did you get your info?
Also, the default is NO. Use only as a last resort.
Visit the new-look IDUG Website , register to gain access to the excellent content.