1. Go to Tools | Options | Database | General | "Numbers of rows to initially fetch in data tab" is set to 1000, checkbox "Apply to editor" is marked.
2. Execute the query with parameters against DB2 LUW database, e. g. "select * from test where tst >= :i;".
3. F9
4. Specify "Bind Variables"
5. OK
6. First 1000 rows are displayed
7. Go to the last record
8. Window "Read all rows / Do you want to read all rows..."
9. YES
10. DB2 Database Error "ERROR [07001] [IBM] CLI0100E" with SQLSTATE=07001
Example Table:
create table test (tst integer not null default 0)
Fill with data:
begin atomicdeclare i integer default 0;
while (i <= 5000) do insert into test (tst) values (i);
set i = i + 1;
end while;
end
select * from test where tst >= :i;
As :i input 1