Re: 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.