IBM DB2 manual Php, Embedded SQL and Administrative API

Example 4-15 Verify the connection after deployment

prodapp@lepus:~> cd /home/prodapp/cliapp/bin

prodapp@lepus:~/cliapp/bin> ./itso_cliapp mensa 50000 itso db2inst1 password

Connecting to database itso ...

Connected to database itso.

Disconnecting from database itso...

4.3.5 Embedded SQL and Administrative API

For embedded SQL applications that must have the target database registered in catalog directory, IBM Data Server Client, or IBM Data Server Runtime Client is required.

Those applications, either ODBC and CLI or embedded SQL which make use of Administrative APIs, require at least IBM Data Server Client or the IBM Data Server Runtime Client as well. This is because IBM Data Server Driver for ODBC and CLI does not include Administrative APIs support.

The general steps to deploy an application who uses either embedded SQL or Administrative APIs are as follows:

￿Deploy the IBM Data Server Client or IBM Data Server Runtime Client to the target system.

￿Deploy the application to the target system.

￿Finish the configuration steps for the application.

For more information on restrictions on IBM Data Server Driver for ODBC and CLI, visit:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.apdv

.cli.doc/doc/r0024160.html

4.4 PHP

PHP is a powerful server-side scripting language, originally invented for producing dynamic Web pages. It can also be used in standalone applications or from the command line interface. The syntax is similar to C and Perl. PHP is an open source language and can be deployed on most operating systems free of charge. It is a very popular Apache module, and because it generates plain HTML, it is compatible with all Web browsers.

Chapter 4. Deploying applications with DB2 169