DB2 Stored Procedure Source code not available

Note: please leave bug reports and feature requests on

DB2 Stored Procedure Source code not available

Postby Royden » Thu Oct 15, 2015 1:48 pm

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 .
Royden
 
Posts: 5
Joined: Thu Oct 15, 2015 1:32 pm

Re: DB2 Stored Procedure Source code not available

Postby Serge » Thu Oct 15, 2015 3:30 pm

Stored procedures source code is only available in DB2 LUW driver.
DB2 for z/OS and older DB2 drivers doesn't support that.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: DB2 Stored Procedure Source code not available

Postby Royden » Thu Oct 15, 2015 3:44 pm

Royden
 
Posts: 5
Joined: Thu Oct 15, 2015 1:32 pm

Re: DB2 Stored Procedure Source code not available

Postby Serge » Thu Oct 15, 2015 3:47 pm

Unfortunately no.
Currently DB2 iSeries driver supports only basic JDBC features.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: DB2 Stored Procedure Source code not available

Postby Royden » Thu Oct 15, 2015 4:00 pm

Royden
 
Posts: 5
Joined: Thu Oct 15, 2015 1:32 pm

Re: DB2 Stored Procedure Source code not available

Postby Royden » Fri Dec 04, 2015 7:34 pm

Royden
 
Posts: 5
Joined: Thu Oct 15, 2015 1:32 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 19 guests