Page 1 of 1

DB2 Stored Procedure Source code not available

PostPosted: Thu Oct 15, 2015 1:48 pm
by Royden
Hello everyone

I tell my problem, I 'm trying to edit stored procedures in DB2.

Selecting " View Procedure" , the source code shows me the following message: - Source code not available.

When performing the same operation in SQL Server or MySQL server allows me to edit stored procedures.

How I can fix it?
I've tried other drivers .

Re: DB2 Stored Procedure Source code not available

PostPosted: Thu Oct 15, 2015 3:30 pm
by Serge
Stored procedures source code is only available in DB2 LUW driver.
DB2 for z/OS and older DB2 drivers doesn't support that.

Re: DB2 Stored Procedure Source code not available

PostPosted: Thu Oct 15, 2015 3:44 pm
by Royden

Re: DB2 Stored Procedure Source code not available

PostPosted: Thu Oct 15, 2015 3:47 pm
by Serge
Unfortunately no.
Currently DB2 iSeries driver supports only basic JDBC features.

Re: DB2 Stored Procedure Source code not available

PostPosted: Thu Oct 15, 2015 4:00 pm
by Royden

Re: DB2 Stored Procedure Source code not available

PostPosted: Fri Dec 04, 2015 7:34 pm
by Royden