|
From: Matt F <de...@ya...> - 2019-01-11 23:20:19
|
It’s working for me on version 3.8.0. I went to the objects tab - expanded the scheme- then opened the procedure tree and saw the 13 or so stored price I have there. I checked all of them clicking on one then switching the source tab. I the clicked through all of them. For the driver I’m using db2jcc.jar from IBM and the class name is com.ibm.db2.jcc.DB2Driver I see another class listed in there com.ibm.db2.jcc.uw.DB2StoredProcDriver that might also be utilised. I’m running DB2 v10.5.0.8 FP 8 Hope that helps Sent from Yahoo Mail for iPhone On Friday, January 11, 2019, 6:08 PM, Gerd Wagner <ger...@t-...> wrote: Sorry, I can't reproduce your problem. I don't have access to a DB2 instance at the moment. I just managed to get a DB2 docker container to run. But I can't connect to it via JDBC. It was my second try within year and it again cost me several hours again. Perhaps there is someone else who could look after DB2 specific problems. Gerd Am 09.01.19 um 23:48 schrieb Ben Eisenstein: > Is this a bug or something wrong in my setup? > > When attempting to display source code on the source tab for a procedure > in DB2 (both LUW and z/OS) we receive an SQLCODE 313. Nothing is > displayed in the tab. > > Squirrel version 3.7.1 > > This is the message from LUW (the z/OS error is the same, slightly > different message). > > The number of variables in the EXECUTE statement, the number of > variables in the OPEN statement, or the number of arguments in an OPEN > statement for a parameterized cursor is not equal to the number of > values required.. SQLCODE=-313, SQLSTATE=07001, DRIVER=3.64.114 SQL > Code: -313, SQL State: 07001 > > From a db2 trace I find the following SQL statement attempted: > > select case when language = 'C' > > then 'This is a C-language routine. The source code is unavailable.' > > else text end as text > > from SYSCAT.PROCEDURES > > where PROCSCHEMA = ? and > > PROCNAME = ? > > I see in the trace that the PROCNAME variable is supplied but I do not > see a schema name in the trace dump. > > *cid:image001.png@01D40CA3.54B704B0* > > > > *Ben Eisenstein* > > Data Architect / Data Platform > > *P*312 322 6309 > > www.theocc.com <http://www.theocc.com/> > > This message may contain information that is privileged or confidential. > If you are not the intended recipient, please advise the sender > immediately by reply email and delete this message and any attachments > without retaining a copy. > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
