Return
-
Title
Getting Error SQLSTATE=07001 when executing query with parameters -
Description
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. F94. Specify "Bind Variables"5. OK6. First 1000 rows are displayed7. Go to the last record8. Window "Read all rows / Do you want to read all rows..."9. YES10. DB2 Database Error "ERROR [07001] [IBM] CLI0100E" with SQLSTATE=07001Example 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;
endExample query:
select * from test where tst >= :i;As :i input 1
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.