DB 2 Executive

For the busy executive that has no time to experiment with PHP.

1) PHP ibm_db2 CLI full features

  • IBM supported procedural interface
  • best on IBM i (free on IBM i)
  • best on Windows/Linux ($$$ requires DB2 Connect license $$$)
  • Note: Windows/Linux does not support all IBM i features

2) PHP odbc ODBC subset features

  • Community supported procedural interface (not IBM)
  • second best interface on IBM i (free on IBM i)
  • second best interface running from Windows/Linux (works with iAccess ODBC or DB2 Connect license)
  • Note: Public maintained ODBC does not support all IBM i features

3) PHP pdo_ibm CLI subset features

  • IBM supported Object Oriented interface
  • third best interface on IBM i (free on IBM i)
  • third best interface on Windows/Linux ($$$ requires DB2 Connect license $$$)
  • Note: Platforms do not support all IBM i features

CCSID issues

Have CCSID issues? Junk characters? Nothing works?

  • IBM i actions, see CCSID

LUW DB2 Connect not support all features

  • I5_xxx options are only available on IBM i
  • LUW ibm_db2 mode *NONE not supported, read ok, but update/insert non-journal CRTLIB not work
  • LUW ibm_db2 system naming not supported, therefore *LIBL not work

New test version: - YiPs test versions ibm_db2 - LUW enables i5_naming, i5_libl, i5_curlib, also, ‘i5_commit’=>DB2_I5_TXN_NO_COMMIT for CRTLIB non-journal (see source 1.9.7+ download and ibm_db2 changelog)