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
-- Hany Bardissi
From: Hany Bardissi <bardissi@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
On 4/16/2012 10:20 AM, Robert Manning wrote:
> from SYSCAT.PROCEDURES
> where PROCSCHEMA = ?
> and PROCNAME = ?
-- Hany Bardissi
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.
On Mon, Apr 16, 2012 at 11:16 AM, Hany Bardissi <bardissi@...> 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
> On 4/16/2012 10:20 AM, Robert Manning wrote:
>> from SYSCAT.PROCEDURES
>> where PROCSCHEMA = ?
>> and PROCNAME = ?
> -- Hany Bardissi