Re: [Squirrel-sql-users] unable to view Stored procedure Source in Squirrel

[Robert M. <rob...@gm...>]

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
>
>