Development tools such as PL / SQL Developer for IBM DB2 for i (iSeries)
I am expreeted in working with PL / SQL Developer on Oracle.
Now I have a client where I need to write some stored procedures in IBM DB2 for i (formerly known as DB2 UDB for iSeries, AS400).
Is there a tool for IBM DB2 like PL / SQL Developer where I can develop debug stored procedures (step by step, exit, view variables)
What tools do db2 development guys use?
Thank. Oliver
source to share
I believe you are looking for IBM Data Studio
IBM® Data Studio provides an integrated, modular environment for developing and administering an IBM DB2® database for Linux, UNIX, and Windows. It also offers collaborative database development tools for IBM DB2 for z / OS®, IBM DB2 for i, and IBM Informix®. This software is provided free of charge.
For those working with DB2 for i (AS / 400, iSeries and later), IBM Data Studio may be worth getting and learning. It has many useful development features. But for debugging, you'll have to learn a lot to get it to work at all (if ever). Data Studio can be used for debugging if IBM I 6.1 or 7.1 is on the server and the PTF level of the DB2 group is at least mid 2013. (V5R4 may also be possible, although there are conflicting statements on the IBM sites and I have not seen any indication of the required PTFs.)
When you try to use Data Studio for debugging, you will get much better results by downloading and installing iSeries Navigator from the server. Make sure the minimal installation includes the Database component. ("Data Transfer," which is essentially unrelated and requires licensing.) The Database component provides access to Run SQL Scripts for AS / 400 databases and includes connections to the system graphical debugger.
Many other direct database features are also included. The iNav feature downloads, installs and configures rather quickly than Data Studio. It's also easier to learn and better suited for smaller monitors. (Keep in mind that the recent iNav fix pack should also be applied.) But this is not really a high-level IDE database. It just provides the necessary functionality for most of the database work outside of the main project development.
If you have no control over the patch levels on the server, or the server version is not current, you may not have any other good choice, especially for debugging saved processes, etc.
source to share