© 2002 International Business Machines Corporation. All rights reserved.
Although you might be the best programmer from here to the farthest cubicle your eyes can see, the reality is you refer to programming manuals because you can't commit all of those programming APIs to memory. Don't worry; you are not alone. If you are the average programmer, you probably lead a pretty busy life, scrambling to finish up a project that management has committed to, even though they were totally oblivious to what they were committing you to! You begin to question what the difference is between your job and indentured servitude.
Every so often, there is something designed to make your life a little bit easier. These "somethings" are particularly helpful when they take away some of the menial tasks that we must perform. If you are paid hourly, we apologize beforehand; the presented code in this article will probably allow you to get your job done a bit quicker.
Wouldn't it be nice if you had a simple, platform-independent application to let you add, delete, and update rows in your DB2 database tables without having to know the table names and column names off the top of your head? The application would basically give you a visual display of what is in the tables you are trying to manipulate. Guess what? We have you covered.
The SQL utility we describe here is an application that gives you the ability to interact with your IBM DB2 database in an intuitive and easy-to-use manner. The utility is platform-independent, because it was developed using JavaTM-based technologies. The GUIs you will see in this application were built using Java Swing components, and the database access layer was built using the JDBC 2.0 driver provided by IBM. The application was developed and tested using JDK 1.3.1_02.
Bear in mind that this simple tool in no way replaces the full-function DB2 Table Editor that is shipped and supported by IBM. Our tool is much more limited in...