Re: using SQL and Zendserver

The PHP documentation for db2_connect is here http://php.net/manual/en/function.db2-connect.php

Connection options need to be set to use System Naming (i5 Naming) rather than SQL naming (the default) which does not use the library list. This behavior is not specific to PHP. An additional connection option can be used to set the library list to be used.

Here are the options:
i5_naming - set to DB2_I5_NAMING_ON for System Naming
i5_libl - set to space delimited list of library names


Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----"Helge Bichel" <hbi@xxxxxxx> wrote: -----
To: "'Web Enabling the IBM i \(AS/400 and iSeries\)'" <web400@xxxxxxxxxxxx>
From: "Helge Bichel" <hbi@xxxxxxx>
Date: 04/01/2015 04:37AM
Subject: Re: [WEB400] using SQL and Zendserver

Hi Alan.

What about having the SQL statements without specifying library?
Libl can be set by SetEnv QIBM_CGI_LIBRARY_LIST
"QTEMP;QGPL;NYCPRD;TWREL;TWPRD"
but it seems PHP doesn't use it.

Brgds
Helge


-----Oprindelig meddelelse-----
Fra: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] På vegne af Alan Seiden
Sendt: 31. marts 2015 14:31
Til: Web Enabling the IBM i (AS/400 and iSeries)
Emne: Re: [WEB400] using SQL and Zendserver

Hi, Larry,

For SQL, use the db2_* functions (db2_connect, db2_prepare, db2_execute,
etc.). New toolkit didn't re-implement these since they were provided in the
ibm_db2 extension.

Alan
--
*Alan Seiden Consulting LLC*

Project leader, Zend PHP Toolkit for IBM i Zend Framework certified
contributor

Office: 201-447-2437 Cell: 201-248-4704
http://www.alanseiden.com | alan@xxxxxxxxxxxxxx
http://twitter.com/alanseiden


Larry Kleinman wrote:

I have used i5_query and -5_program_call for years to do an SSL and
RPG calls from ZendServer for IBM i, but am now using the newer
Toolkit. I have RPG calls working, but can't find documentation for
SQL. Here's how I do the RPG stuff

require_once('ToolkitService.php');
$conn = ToolkitService::getInstance($db, $user, $pass); $params[] =
$conn->AddParameterPackDec('both', 9, 2, '', '', $OHSHDS); $result =
$conn->PgmCall('TWR001', '', $params, null, null);

I have been searching the Zend site for the last two hours and cant'
find anything

Help

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.