DB2 and SQL in depth for PHP on IBM i

Alan was a very good speaker. Informed, entertaining, and has great pacing for a teacher.

Great session. Good to know that I'm on the right track.

Well done, good tips, very informative.

Good overview. Great pace. thanks.

Alan is a great presenter! 3hrs not enough to walk through everything !

Excellent presentation

Being a non-IBM i user, I still found this talk to be informative in regards to DB2. I did find that there are more IBM/DB2 information in the talk than there was PHP-related material; which I would have liked to have seen more of. Great presentation and ability to ask questions was appreciated.

great!

Wonderful. This presentation debunked a lot of misinformation gathered from old-school RPG programmers in my company. I now understand the underlying system better, and can circumvent them to create a better web experience.

Thanks again!

Excellent information! This session was full of very practical tips!

Great job! Encouraging the audience to participate is great! I got a lot of that!

Great session. Very informative. Made sure to try to answer everybody's questions. Thanks Alan!

Always learn something at Alan's talk. He always has the most up to date information and makes the talk interactive and fun.

Great presentation and interactive discussion on IBM DB2/SQL, PHP, ZF2. Really provided some great insights and tips into usage and optimizations.
Audience included experts from IBM that also offered unsolicited advice. Highly recommend attending this in the future.

Excellent detail, lots of great information that save a lot of time and help get DB2 PHP ZF development get off to a good start for any size development project

Very useful information as always Alan. Thanks!

Very good presentation. Would have liked to have seen more code and fewer bulleted lists--but I do like Alan's approach and delivery and appreciate his knowledge.

Hi Alan,

Great Slide show, Just a quick question regarding DB2 Connect V10.5 running on Linux and system naming.

We are currently switching our applications to run on a Linux box and connect to the IBMi: so far we have been successful in setting up the 'dummy' database, creating the connection and running SQLs from Linux into the IBMi (both via the command line and from our Zend Application) but only when defining the libraries. We are currently running Zend Server 7, Ibm db2 V1.9.7, and DB2 Connect 10.5

We have not been successful however in getting the DB2_I5_NAMING_ON to work on our Linux box so that we can avoid specifying the libraries.

Here is an example of an what we are attempting to run from Zend.

$driverOptions = array('i5_libl' => 'library1 library2','i5_naming' => DB2_I5_NAMING_ON, 'i5_lib'=>'library1');

$config = array(
'adapter' => 'Db2',
'params' => array(
'username' => $user,
'password' => $password,
'dbname' => $database,
'driver_options'=> $driverOptions
)
);

$config = new Zend_Config($config);
$db = Zend_Db::factory($config);

$select = $db->select()->from("FILENAMEHERE");
$result = $select->query();

However we continue to receive this message
Message: [IBM][CLI Driver][AS] SQL0204N "USERSNAMEHERE.FILENAMEHERE" is an undefined name. SQLSTATE=42704 SQLCODE=-204

It has added the users name in for the library and will not use the specified library list with the '.' in between suggesting it is still using sql naming instead of system.

We have also included ibm_db2.i5_sys_naming=1 in our ibm_db2.ini file.

Do you know of any other configuration changes that would need to take place in order for system naming to work or know of any reason why we could be having such problems?

>> We are currently switching our applications to run on a Linux box and connect to the IBMi

Ah yes, first mistake, moving PHP off IBM i.

>> We have not been successful however in getting the DB2_I5_NAMING_ON to work on our Linux box so that we can avoid specifying the libraries.

Linux DB2 Connect to IBM i using system naming / DB2_I5_NAMING_ON ONLY works V7R1+ (not V6R1-).