× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yep, we've heard from a lot of you that PDO is interesting. So some of us are looking into what it would take to make it better like alleviating the CC constraints, etc.

More soon or right after ZendCon announcement.

Mike Pavlak
Cell: (408)679-1011 Office: (708)233-5880

-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Matt Lavinder
Sent: Friday, September 09, 2016 1:01 PM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] PDO and PHP questions

One thing people should know about PDO_IBM before getting in too deep: it can and does have issues with tables that do not have commitment control enabled. I opened a support request over the issue and, after some back and forth, was told was that PDO requires commitment control. Period. The answer never sit well with me, but since the native ibm_db2 extension works without issue, I have stuck with it.


On Fri, Sep 9, 2016 at 7:28 AM, Mark Murphy/STAR BASE Consulting Inc. < mmurphy@xxxxxxxxxxxxxxx> wrote:

Here is an interesting link comparing PDO and MySQLi. You could
probably make the same comparison between PDO and IBM_DB2. Note that
both the IBM
DB2 extension and PDO IBM need a native client installed, and for
IBMi, that client is DB2 Connect. I don't know if you can use PDO_ODBC
with IBMi, there is an ibm-db2 flavor, but it only claims to support
DB2 LUW. The normal ODBC database extension works fine against DB2 for i though.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Vicki Wilson <victwyh@xxxxxxxxx> wrote: -----
To: "web400@xxxxxxxxxxxx" <web400@xxxxxxxxxxxx>
From: Vicki Wilson <victwyh@xxxxxxxxx>
Date: 09/08/2016 08:47PM
Subject: [WEB400] PDO and PHP questions


Hi all,
We have some new templates available to us that include PDO. We are
new to PHP. And even the folks with PHP experience do not have PDO experience.
We are running PHP on the ibmi and mostly connecting to DB2 on the ibmi.
I found the library list issue and addressed it via:
PDO::I5_ATTR_DBC_SYS_NAMING => true
If you use PDO do you have other options you typically set when
connection to DB2 on the ibmi?
Does anyone have any thoughts on pros/cons of using PDO?
Also the naming of this option i5_ makes me think it's using the old
toolkit? Does PDO use the old toolkit? Does it matter?
Thanks. Vicki Wilson


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





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.