Hello.

v8.2.7

This procedure is not working (SQL20046N):
---
create procedure tst(nm1 varchar(20), nm2 varchar(20))
language sql
dynamic result sets 1
begin
 declare stmt varchar(4096);
 declare c1 cursor with return for s1;
 set stmt=
   'select tabname, colname '
 ||'from syscat.columns '
 ||'where tabschema=''SYSCAT'' '
 ||'and tabname between ? and ? '
 ||'selectivity 0.01 '
 ;
 prepare s1 from stmt;
 open c1 using nm1, nm2;
end
@
---
But if I do
---
...
 ||'and tabname=? '
 ||'selectivity 0.01 '
 ;
 prepare s1 from stmt;
 open c1 using nm1;
...
---
it works.

Q:
SELECTIVITY clause with BETWEEN predicate is not allowed?
Why?
It would be very useful...

Sincerely,
Mark B.