Re: using SQL and Zendserver

The other option is of coursed to use system naming per the link Alan provided. Then you can have slashes and library lists.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Nicholas Kruzan <NKruzan@xxxxxxxxxxxxxxxxxxxxxxx> wrote: -----
To: "Web Enabling the IBM i \(AS/400 and iSeries\)" <web400@xxxxxxxxxxxx>
From: Nicholas Kruzan <NKruzan@xxxxxxxxxxxxxxxxxxxxxxx>
Date: 03/31/2015 10:00AM
Cc: "Web Enabling the IBM i \(AS/400 and iSeries\)" <web400@xxxxxxxxxxxx>, "WEB400" <web400-bounces@xxxxxxxxxxxx>
Subject: Re: [WEB400] using SQL and Zendserver

i believe you need to use . not /

$result = db2_exec($conn,"Select * from TWFT.TWF10");


Thanks,

Nicholas Kruzan
Systems Analyst
Schilli Distribution Services



Larry Kleinman <larry@xxxxxxxxxxxxxxxxx>
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxx>
03/31/2015 09:52 AM
Please respond to
"Web Enabling the IBM i \(AS/400 and iSeries\)" <web400@xxxxxxxxxxxx>


To
"Web Enabling the IBM i \(AS/400 and iSeries\)" <web400@xxxxxxxxxxxx>,
cc

Subject
Re: [WEB400] using SQL and Zendserver






Yes, $conn is good

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




From: Michael Ryan <michaelrtr@xxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxx>,
Date: 03/31/2015 09:46 AM
Subject: Re: [WEB400] using SQL and Zendserver
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxx>



Was the $conn successful?

On Tue, Mar 31, 2015 at 9:42 AM, Larry Kleinman <larry@xxxxxxxxxxxxxxxxx>
wrote:

So here is my code now

$db = 'IASP1';
$user = 'xxxx';
$pass = 'xxxxxx';
$conn = db2_connect($db, $user, $pass);
$result = db2_exec($conn,"Select * from TWFT/TWF10");
if ($result) {echo 'this is good';} else echo 'this is bad';

and I see "this is bad" in the browser and get the folling in the

php.log

file

PHP Warning: db2_exec(): Statement Execute Failed

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




From: Alan Seiden <alan@xxxxxxxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxx>,
Date: 03/31/2015 08:40 AM
Subject: Re: [WEB400] using SQL and Zendserver
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxx>



Generally yes, but here's a tip on how to share the db2 connection:
http://forums.zend.com/viewtopic.php?f=113&t=46688&hilit=share

By the way, after you call getInstance(), remember to add this line:
$conn->setOptions(array('stateless'=>true));
so that the toolkit won't have to spawn additional jobs. 'stateless'
mode works best for most people.

Alan

Larry Kleinman wrote:

Thanks Alan. Does that mean that if I call an RPG program from the

same

script at I use SQL, that I need to do a db2_connect as well as a
ToolkitService:getInstance

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




From: Alan Seiden<alan@xxxxxxxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxx>,
Date: 03/31/2015 08:29 AM
Subject: Re: [WEB400] using SQL and Zendserver
Sent by: "WEB400"<web400-bounces@xxxxxxxxxxxx>



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.


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