SqlDbx
You are not logged in.
Pages: 1
Using 3.58 Pro on DB2 Express-C 10.1.2 with Win 7 Pro SP1, why am I getting a result in the message tab 'SQL0347W The recursive common table expression "DB2ADMIN.STREAMS" may contain an infinite loop. SQLSTATE=01605' when the query is a simple SELECT * FROM TABLE WHERE COL1 = 1 and there is an appropriate index on COL1.
I actually get the correct result query plan, but it provides the above sql error in the message tab of the result. Seems to be happening for EVERY query no matter what I use. Same thing was happening on DB2 10.1 as well prior to installing the latest fixpak version.
Another question, if I select the Query Plan toggle for an UPDATE/DELETE/INSERT .. statement, will it execute the update etc or just return the query plan ?
Offline
Any ideas yet ?
Offline
This is not an error but a warning.
The statement to be explained is not executed.
Offline
I think query plan function can not be used in SQLBOX
Offline
I do not now anything about SQLBOX, but in SqlDbx Professional it works
Offline
Pages: 1