Just download and try this tool, it's really a good tool. But after expand a schema node, I didn't find anything related to stored procedures(I am using IBM DB2). Is there any road map to add a list of stored procedures in the future?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Cool! Did you add this feature to sqlexplorer_db2? If so could you provide a patch? If not, don't worry. I'll add this feature to the db2 plugin.
If you know any more, I'll be happy to add those too, or give you developer access ;-)...
At this point there's no real roadmap as such.
There's a todo list in the main project, but that's about all I'm using: http://eclipsesql.cvs.sourceforge.net/\*checkout*/eclipsesql/sqlexplorer/todo.txt
Getting 3.0.0 to work has been a lot of work and I haven't really thought about what's next..
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Send an email to your sourceforge email box, not sure whether you got it since this is the first time I tried sourceforge email. The email contains the patch for sqlexplorer_db2 to support procedure list and procedure source tab.
I also worked out view source tab, Function list and function source tab. What's the best approach for you to get these codes? You can drop me a msg through zhengxilong{at}hotmail.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just download and try this tool, it's really a good tool. But after expand a schema node, I didn't find anything related to stored procedures(I am using IBM DB2). Is there any road map to add a list of stored procedures in the future?
Those will mostlikely be in the next version. If you can't wait that long, have a look here:
http://eclipsesql.sourceforge.net/exNodes.html
Thanks for your reply.
I just added this function by myself. This project is really easy to extend. I just add some SQL then I have the feature I want.
btw: Where could I find the road map? So I could have a foresee of the features.
To list all procedures:
select rtrim(routinename) from syscat.routines a where routineschema = ?;
To get a DDL of a stored procedure:
select text from syscat.routines where routineschema = ? and routinename = ? and routinetype='P'
Cool! Did you add this feature to sqlexplorer_db2? If so could you provide a patch? If not, don't worry. I'll add this feature to the db2 plugin.
If you know any more, I'll be happy to add those too, or give you developer access ;-)...
At this point there's no real roadmap as such.
There's a todo list in the main project, but that's about all I'm using: http://eclipsesql.cvs.sourceforge.net/\*checkout*/eclipsesql/sqlexplorer/todo.txt
Getting 3.0.0 to work has been a lot of work and I haven't really thought about what's next..
Davy,
Send an email to your sourceforge email box, not sure whether you got it since this is the first time I tried sourceforge email. The email contains the patch for sqlexplorer_db2 to support procedure list and procedure source tab.
I also worked out view source tab, Function list and function source tab. What's the best approach for you to get these codes? You can drop me a msg through zhengxilong{at}hotmail.com
Please discard my previous response. Sorry for my bad eyesight. Just found your mail and committed the changes to CVS.