|
From: Ben E. <bei...@th...> - 2019-01-10 00:13:27
|
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. |
