Db2 – How to modify a stored procedure in IBM DB2

db2db2-9.7

I have a DB2 database and I'm using Control Center. I've found a procedure in the 'Stored Procedures' folder, which I need to modify. In MS SQL Server and Oracle you can accomplish this right from the DBMS.

Is there a way I can modify this procedure with an editor in DB2 (9.7.0), similar to SQL Server and Oracle?

Best Answer

I believe you can do so through IBM Data Studio. I would use that tool anyway as that is now the approved IBM tool for interacting with DB2 and Control Center is deprecated.