|
From: Gerd W. <ger...@t-...> - 2019-01-17 20:43:40
|
Maybe I found a helpful hint:
Please have a look at the source code below. It is the SQuirreL uses to
read the source code of procedures. The "?" variables are just given the
schema and procedure names you see in SQuirreL's Object tree.
Perhaps you can try out the statements manually and find out what's wrong.
Gerd
---------------- source code -------------
public String getProcedureSourceSql() {
String result = null;
switch(db2Type) {
case OS400:
result =
"select routine_definition from qsys2.sysroutines " +
"where routine_schema = ? " +
"and routine_name = ? ";
break;
case LUW:
result =
"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 = ? ";
break;
case ZOS:
result =
"select text " +
"from sysibm.SYSROUTINES " +
"where schema = ? " +
"and name = ? " +
"and routinetype = 'P' ";
break;
}
return result;
}
Am 12.01.19 um 00:17 schrieb Matt F:
> 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 <https://overview.mail.yahoo.com/?.src=iOS>
>
> 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
> <mailto:image001.png@01D40CA3.54B704B0>*
> >
> >
> >
> > *Ben Eisenstein*
> >
> > Data Architect / Data Platform
> >
> > *P*312 322 6309 <tel:312%20322%206309>
> >
> > 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...
> <mailto:Squ...@li...>
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
> >
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> <mailto:Squ...@li...>
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|
