Re: PDO and PHP questions

Other can probably province more comprehensive answers Vicki but I’ll comment on a couple.

PDO is an abstraction layer - that is to say that it allows the same set of API calls to retrieve data from multiple types of database. As such it is almost inevitable that it will be less efficient (and probably less capable) than directly using the db2 interface.

The only time I use anything other than the direct db2 interfaces is when I am using a package that uses PDO or a similar layer for database access and in most of those cases I have used MySQL with the DB2 Storage engine to materialize those tables that I needed direct RPG/SQL access to in other apps.

I believe that the PDO DB2 connection is probably ODBC - again the db2 APIs are almost certainly faster. The reason I think that is that the current PDO docs state that IBM i (they call it i5) is only supported if you have purchased DB2 Connect. Hmmm - come to think of it though maybe that’s what we get on the box - I don’t know. Where are Alan Seiden and Mike Pavlak when I need them!

All of the i5_ interfaces are indeed the old toolkit. For program and system calls you should be using the new toolkit. For database access the direct db2 APIs as noted earlier.

I don’t believe PDO uses either the new or old toolkit as it is platform agnostic and I’m pretty sure uses ODBC when a native definition is not directly supported.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Sep 8, 2016, at 7:14 PM, Vicki Wilson <victwyh@xxxxxxxxx> wrote:

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.