Re: PHP DB2 Access (wa Recommendations of web...)

["Jon Paris" <Jon.Paris@xxxxxxxxxxxxxx>]

> > It appears like the two URLs you send don't speak to DB2/400 SQL access
using static SQL.  The first is about regular UDB DB2 which DB2/400 isn't.
The latter, I assume, is native i5 I/O as used by RPG or the like, not SQL.

DB2/400 is UDB DB2 - has been for a while.

You are running PHP in PASE so it would be very surprising if it could
access pre-prepared packages - which is what happens with embedded SQL in
RPG programs.  I assume that is what you mean by "static SQL".  If you want
static SQL then you do it within RPG programs and either call them or use
them as stored procedures. I suspect that the DB2 uses DRDA.  But it is
"special" - not ODBC.  Zend built this stuff directly on top of IBM's APIs.


Jon Paris
Partner400

www.Partner400.com