February 20, 2019
Hot Topics:

DB2 Universal Database and the PHP Developer

  • February 9, 2006
  • By Paul C. Zikopoulos
  • Send Email »
  • More Articles »

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 CloudscapeTM 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:

Drag-and-drop code is supported from the IBM objects to an SQL palette as well:

Page 2 of 3

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date