From YiPs Wiki (i powered)

XMLService: XMLSERVICEQTEMP

(click to open)

Quick Page Table of Contents

Scanning…

XMLSERVICE/Toolkit Sharing QTEMP

Goto Main Page
Goto Documents

You may want to refer to the DB2 connection link before reading this page PHP DB2 Connection topics.

Sharing QTEMP - what do?

Sharing QTEMP ibm_db2/odbc/pdo_ibm/RPG/xmlservice has a few quirks, but can be “mostly” done if you understand the jobs in play.

The big picture …

xmlservice |--LUW/PASE------|-----------------------IBM i----------------------
run type   |job 1 (1-2 tier)|  job 2 (stateless)        job 3 (IPC/private)
-----------|----------------|------------------------|-------------------------
stateless  | php-client-----|-->QSQSRVR              |
           |                | ->ibm_db2,pdo_ibm,odbc |
           |                |   *iPLUGxxxx->         |
           |                | ->XMLSERVICE<>RPG      |
           |                | ->XMLSERVICE<>DB2 (xml)|
           |                | ->QTEMP (yes share)    |

IPC/private| php-client-----|--->QSQSRVR             |
           |                |  ->ibm_db2,pdo_ibm,odbc|
           |                |    *iPLUGxxxx----------|-->XMLSERVICE<>RPG
           |                |  ->QTEMP (no share)    | ->XMLSERVICE<>DB2 (xml)
           |                |                        | ->QTEMP (yes share)

*Note: iPLUGxxx stored procedures are included with xmlservice download

1) Specific examples for New PHP Toolkit

     -----------------------------------------
     |              Browser                  |
     |---------------------------------------|
     | Download RPG (1) | Download PHP (2)   |
     | 1) XMLSERVICE    | a) PHP CW Toolkit  |
     |    HTML/XML/REST | b) New PHP Toolkit |<- cw-tk-php-x.x.x.zip (*)
     |    no PHP        |--------------------|
     |    (xmlcgi.pgm)  | c) PHP Raw XML   |
     |    (optional)    |   (ibm_db2, odbc)  |
     |    -----------------------------------|
     | 2) XMLSERVICE DB2 stored procedures   |
     |    (iPLUG4K, iPLUG32K, ..., iPLUG15M) |
     | 3) XMLSERVICE (xmlservice.pgm)        |
     |    call most anything on IBM i ...    |
     |    (PGM, SRVPGM, PASE, DB2, etc.)     |
     ------------------------------------------

2) Specific examples for XMLSERVICE

     -----------------------------------------
     |              Browser                  |
     |---------------------------------------|
     | Download RPG (1) | Download PHP (2)   |
     | 1) XMLSERVICE    | a) PHP CW Toolkit  |
     |    HTML/XML/REST | b) New PHP Toolkit |
     |    no PHP        |--------------------|
     |    (xmlcgi.pgm)  | c) PHP Raw XML   |<- Zend Server for IBM i or Linux or Windows (*)
     |    (optional)    |   (ibm_db2, odbc)  |
     |    -----------------------------------|
     | 2) XMLSERVICE DB2 stored procedures   |
     |    (iPLUG4K, iPLUG32K, ..., iPLUG15M) |
     | 3) XMLSERVICE (xmlservice.pgm)        |
     |    call most anything on IBM i ...    |
     |    (PGM, SRVPGM, PASE, DB2, etc.)     |
     ------------------------------------------

Author(s)

Tony “Ranger” Cairns - IBM i PHP / PASE

Retrieved from http://youngiprofessionals.com/wiki/index.php/XMLService/XMLSERVICEQTEMP
Page last modified on October 21, 2013, at 04:37 PM EST