Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Sep 8, 2005

DB2 Universal Database and the PHP Developer - Page 2

By DatabaseJournal.com Staff

It's all in the tooling...

In May 2005, IBM jointly announced a partnership with Zend to provide Zend Core for IBM. This PHP environment is tailored for DB2 UDB databases (as well as Apache Derby and IBM Cloudscape databases) and removes the manual steps involved in building and setting up PHP environments. The following features help make Zend Core for IBM a real productivity booster for PHP programmers:

  • Delivers a seamless out-of-the-box experience with instant PHP setup, all required libraries needed for DB2 UDB development, and the related DB2 UDB documentation on PHP.
  • Tight integration into Zend Studio, Zend Core's IDE and the most popular choice for professional PHP developers. This tooling includes object browsing, debugging, and the other typical features, functions, and benefits you would expect from an IDE.
  • An official PHP support channel including updates and security fix postings and support offerings tailored to meet various Service Level Agreements (SLAs).
  • A graphic user interface (GUI) PHP configuration control.
  • The latest PHP5.x technology.
  • Simplified up-and-running experience.

A tour of the Zend Core for IBM add-in

Now I will show you some of the integration work that has gone into Zend Core for IBM.

You can see in the following figure that you can add (and test) a DB2 UDB database connection in the SQL perspective:

This eliminates the need to manually catalog and set up connections to DB2 UDB servers using the CATALOG DATABASE and CATALOG NODE commands, thereby getting developers connected to the target database more quickly, allowing them to focus on writing code instead of on setting up database connections.

Once a DB2 UDB database has been added to the Zend Development Environment, you have the standard capabilities that any Explorer-like window offers developers. For example, in the figure below, you can see all the objects that reside in the PAULZ schema in the SAMPLE database:

Developers can drill down into the database schema to get more detailed information about the underlying database objects that reside within them. For example, the following figure shows the ability to see the columns and indexes that are part of a multi-dimensional clustering (MDC) table, called MDCPAULZ, that is in the SAMPLE database.

You can also retrieve the metadata associated with a selected object from using the Metadata function:

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:

DB2 Archives