DB2 Universal Database and the PHP Developer
Zend Core also lets you sample the data of a table (assuming you have the correct SELECT privilege on the selected table):
You can sort the data in this result grid as well. (Note the circled toggle on the DIV column heading; the up arrow here indicates that this column was sorted in ascending order)
If the table whose data you want to view has a lot of rows, you can customize the IDE to retrieve rows in piecemeal fashion:
Another important feature for developers in Zend Core for IBM is the integrated debugger. Like any debugger, it allows application developers to step through their code and change variables on the fly. An example is shown below:
The following figure shows the SQL Query Control component in Zend Core for IBM that can be used to enter DB2 UDB commands. It is similar to entering commands in the DB2 UDB Command Line Processor or the DB2 UDB Command Center:
The SQL Query Control window in the IDE also keeps a history of past SQL commands so that these can be easily recalled for future processing, which allows you to quickly change the server, database, and default schema where you want to execute your SQL statement, as shown below:
You can access the SQL Query Control feature such that it defaults to the correct server, database, and schema: simply right-click the object that you want to run the query against and select Query, as shown below:
Wrapping it all up
In this article, I gave you a brief overview of some of the tooling support in the Zend Core for IBM product that makes developing PHP applications for DB2 UDB (or Apache Derby/IBM Cloudscape) databases easier than ever.
About the Author
Paul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technology team. He has more than ten years of experience with DB2 UDB and has written over sixty magazine articles and several books about it. Paul has co-authored the books: DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA's Guide to Databases on Linux. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). In his spare time, he enjoys all sorts of sporting activities, running with his dog Chachi, and trying to figure out the world according to Chloë his new daughter. You can reach him at: firstname.lastname@example.org.
IBM, AIX, DB2, DB2 Universal Database, Cloudscape, i5/OS, and z/OS, are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both.
Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.
Linux is a trademark of Linus Torvalds in the United States, other countries, or both.
Other company, product, and service names may be trademarks or service marks of others.
© Copyright International Business Machines Corporation, 2005. All rights reserved.
The opinions, solutions, and advice in this article are from the author's experiences and are not intended to represent official communication from IBM or an endorsement of any products listed within. Neither the author nor IBM is liable for any of the contents in this article. The accuracy of the information in this article is based on the author's knowledge at the time of writing.
Page 3 of 3