0

I'm running DB2 LUW v11.5.9 on SLES 12.5 (zLinux).

A new stored procedure BRL.LOONCIRCUIT_BTB_V2 has been created which is basically a copy of an existing SP BRL.LOONCIRCUIT_BTB, but with a change in one of the dynamic SQL statements.

When I execute the new SP in tool DbVisualizer ( version 24.1.5 - pro edition running on Windows 10 enterprise) , I get following return code :

[Code: -4470, SQL State: ] [jcc][t4][10120][10898][4.33.31] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

Executing the old , existing stored procedure works fine. Executing both stored procedures in another tool (Toad for DB2) works fine as well.

I can provide DDL of the new SP if needed

Improve this question
4
  • please edit your question (do not use comments, they are not searchable), and add (1) the exact version of the Dbvisualizer and (2) the operating-system you are using to run DbVisualizer, and (3) whether you tried a different jdbc based tool, e.g squirrelSQL, or Dbeaver. (toad for db2 may use odbc, not jdbc, i.e. different drivers no common code).
    – mao
    Commented Jun 25, 2024 at 14:09
  • The DbVisualizer version is 24.1.5 - pro edition running on Windows 10 enterprise. I also suspect it is driver related in combination with specific SQL syntax : still investigating
    – lazydba
    Commented Jun 25, 2024 at 16:01
  • Different drivers have different default settings and different configs. Check also the impact of adding an extra attribute to the jdbc connection-string resultSetHoldability=1;
    – mao
    Commented Jun 25, 2024 at 16:19
  • status update : problem SQL syntax found in new stored procedure. Opened a case with IBM
    – lazydba
    Commented Jun 27, 2024 at 7:44
Related questions
11
Lob is closed. ERRORCODE=-4470, SQLSTATE=null
500
Select columns from result set of stored procedure
4
Invalid operation result set is closed errorcode 4470 sqlstate null - DB2 data extract
Load 3 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.