Thread: [Squirrel-sql-users] unable to view Stored procedure Source in Squirrel
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Hany B. <bar...@gm...> - 2012-04-13 16:08:16
|
hi this is my first post to this group , so pardon my ignorance using Squirrel ver 3.3.0 on Windows, connecting to db2 i navigate to my schema, Procedures. then Source tab, hoping to be able to see the actual source of the proc, but instead what i endup with is a one very long line of alphanumeric string that means nothing colleagues in my team, are able to view the sources without problems we compared setup and nothing stuck out as being different , hoping for the knowledgeable among this group to shed some light and thanks -- -- Hany Bardissi |
From: Hany B. <bar...@gm...> - 2012-04-16 15:16:41
|
Thank you Rob for your time good suggestion, i tried it as follows: select text from SYSCAT.PROCEDURES where PROCSCHEMA = 'ipla0' and PROCNAME = 'DP_ADD_PART' still, however the body (text) of the proc did not display in the result thanks again h On 4/16/2012 10:20 AM, Robert Manning wrote: > from SYSCAT.PROCEDURES > where PROCSCHEMA = ? > and PROCNAME = ? -- -- Hany Bardissi |
From: Robert M. <rob...@gm...> - 2012-04-16 15:39:24
|
Did you see the same string of characters? If so, its possible that the version of the DB2 driver that you are using has a bug. I am seeing procedure source code correctly with version 3.50.152 of the DB2 jdbc driver. You can find this by selecting the root node in the object tree, clicking on the metadata tab and looking for the value of the property "name" called getDriverVersion. Rob On Mon, Apr 16, 2012 at 11:16 AM, Hany Bardissi <bar...@gm...> wrote: > Thank you Rob for your time > > good suggestion, i tried it as follows: > select text from SYSCAT.PROCEDURES > where PROCSCHEMA = 'ipla0' > and PROCNAME = 'DP_ADD_PART' > > still, however the body (text) of the proc did not display in the result > > thanks again > h > > > On 4/16/2012 10:20 AM, Robert Manning wrote: > >> from SYSCAT.PROCEDURES >> where PROCSCHEMA = ? >> and PROCNAME = ? >> > > -- > -- Hany Bardissi > > |