[Squirrel-sql-users] Not showing ALL Informix Stored Procedures

[Jens R. <rei...@gm...>]

Hello!

I am having the problem that I cannot see ALL stored procedures in my
connected Informix database in the object tree. Unfortunately it is the
ones that I created.
I can see all others. I see them if I check the content of the
"sysprocedures" table.
I can select them with this SQL Statement for example:

SELECT
    *
FROM
    sysprocedures
WHERE
    isproc = 'f' and  procname like "sp_%";

I just cant see them in the object tree.

Unfortunately that is the only way I know where I can access the source
code of the procedure in a usable form. (formatting is correct, no
additional characters like " or ; that would break the code and so on.)

The only difference I notice is that they are created by a different user
(s. Screenshot).

Interestingly enough that is the user I use to connect to informix.

I hope someone is able to help with this. I don't have to have them in the
object tree. I only need to access the source code in a decent way. So if
someone knows how to do that, that would be enough.

Thank you all!

Kind regards,

Jens