How to view stored procedure in zend studio using QuantumDB
How can i view the actual code written inside a procedure using zend studio.
Am using Quantum DB. I can see the variables used /structure.
I am not able to view the actual code/queries written in procedure
How can i view/ edit the procedure using zend studio.
Any 开发者_StackOverflow中文版better addon/plugin/extension avaialable ??
You could query for the text with something like
select PROCNAME,TEXT from SYSIBM.SYSPROCEDURES
or, you could switch to using IBM Data Studio. It is going to be the default DB2 administration toolkit, and should work better for you.
精彩评论