Hi Vicki,

The two options we tend to use are:
PDO::I5_ATTR_DBC_SYS_NAMING => true
PDO::I5_ATTR_DBC_LIBL => "LIB1 LIB2"

The SYS_NAMING attribute allows using slash ('/') as the library/file separator, and causes unqualified files to be searched for in the current job library list.
The LIBL attribute allows explicitly specifying the library list to use when looking for unqualified files. This attribute was added in a newer version of the pdo_ibm extension, so you'll want to make sure you're running the latest version of Zend Server.

In regards to the I5_ naming, I believe that is purely to indicate that the attributes are intended for use with the pdo_ibm extension. The extension itself is written to use the SQL CLI interface, which is a very similar interface to ODBC, and doesn't interact with the old or new toolkits.

- Steven Scott


On 9/8/2016 4:14 PM, Vicki Wilson 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




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.