From YiPs Wiki (i powered)

XMLSERVICE: XMLSERVICE Just DRDA

Goto Main Page
Goto Documents

Who is this page for?

Instructions designed for IBM i developer learning PHP starting from ground zero …

• … installing PHP on a laptop
• … little control over IBM i machine (can’t install Zend Server on IBM i)
• … but have a DB2 Connect DRDA connection to IBM i (good enough)

Prerequisites

On IBM i …

• recent IBM i DB2 PTFs or XMLSERVICE clobs will fail (PHP ibm_db2 drivers)
• XMLSERVICE PTFs from IBM

  • XMLSERVICE 1.7.5 (see toolkit.ini setting for QXMLSERV below):
         - PTF '5770DG1 V7R1M0 SI48830'
         - PTF '5761DG1 V6R1M0 SI48831'
         - PTF '5722DG1 V5R4M0 SI48440'
         - change toolkit.ini: XMLServiceLib = "QXMLSERV"
    

On laptop …

• DRDA connection to IBM i (DB2 Connect product)
  • {PHP ibm_db2 … using DB2 Connect from Linux/Windows/Mac}

1) Install PHP on your PC/laptop

Download Zend Server …

• {Zend Download site} - Zend Server Community Edition
  • … click download for your laptop (Linux, Mac, Windows)
• Install Zend Server on your laptop
  • php-x.x-extra-extensions-zend-server — Linux install extra to run odbc

Download PHP toolkit and CW …
{Goto Main Page} and {Download Latest} version of cw-php-x.x.x.zip PHP framework. This zip file contains all the PHP code required to use the new toolkit from your laptop (your DB2 Connect).

Follow the instructions below to install the php code (Linux, but Windows similar) …

cd /usr/local/zend/share
sudo unzip cw-php-1.1.2.zip
sudo mkdir ToolkitApi
sudo mv ToolkitApi.zip ToolkitApi/.
sudo unzip ToolkitApi.zip
sudo gedit php.ini &
; UNIX: "/path1:/path2"
include_path = ".:/usr/local/zend/share/ToolkitApi:/usr/local/zend/share/ZendFramework/library:/usr/local/zend/share/pear"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

Note: If you are using the IBM i PTFS for XMLSERVICE change toolkit.ini: XMLServiceLib = “QXMLSERV”. Also check the lugconnect PHP script and change XMLSERVICE library to QXMLSERV as needed.

Run ibm_db2 to IBM i

Need some tests to try (a few include with XMLSERVICE) …

5250
> ADDLIBLE XMLSERVICE
> CRTCLPGM PGM(XMLSERVICE/CRTTEST) SRCFILE(XMLSERVICE/QCLSRC) 
> call crttest

Let’s try a test …

In this case we will NOT be using the PHP toolkit from Zend, but use just XML across the PHP ibm_db2 connection. After you have used XMLSERVICE for awhile you will realize that there are many ways to contact IBM i and get work done (including no script at all like the LUG/ZendCon demo).

On your laptop create these files for testing via Zend Studio (or Apache, or command line)..

• download (click to download)
  • {lugsample.zip}
• Common files (click to view)
  • lugconnect.php - connection to IBM i
  • lugencrypt.php - encrypt/decrypt password
  • lugjunkaway.php - fix/hack odbc drivers insist junk end of records (cough Linux)
• A test (click to view)
  • faster option 1: lugzzcallibmdb2-1.php - using XMLSERVICE in/out procedure iPLUGxxx(?,?,?,?)
  • slower option 2: lugzzcallibmdb2-2.php - using XMLSERVICE result set procedure iPLUGRxxx(?,?,?)
• Kill *immed my XMLSERVICE job (click to view)
  • lugkillibmdb2.php - Kill my IBM i XMLSERVICE job

Run new PHP Toolkit to IBM i

Step 1) Follow install PHP toolkit instructions above

Step 2) Let’s try a test using PHP Toolkit …

In this case we WILL be using the PHP toolkit from Zend from your laptop … nice thing to remember is all works the same when you move it up to your production IBM i and/or you switch drivers from ibm_db2 to odbc (f-l-e-x-i-b-l-e).

• Common files (click to view)
  • lugconnect.php - connection to IBM i
• A test (click to view)
  • lugtoolkitibmdb2.php - using new PHP Toolkit over ibm_db2 connection (yep, same connection as last example)