Re: PDO and PHP questions

[Matt Lavinder <mlavinder@xxxxxxxxxxxxxxxxxxx>]

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.