Connecting Tech Pros Worldwide Forums | Help | Site Map

PHP, DB2, iSeries, PASE, binary field question

Jim Gerland
Guest
 
Posts: n/a
#1: Nov 12 '05
When I access my DB2 table from a W2K machine running PHP using ODBC with
the SQL statement:

SELECT DOUBLE(BGROUP.PYHGPT.GPPRAM)

I get: 2376.92

but when I do the same from my iSeries (Vr5.2) I get: 2377

When I do this using Net.Data from my iSeries I get: 2376.92

Any idea how to get the decimal value from PHP on iSeries?

The field definition is:

Data Field Buffer Buffer Field
Column
Field Type Length Length Position Usage Heading
GPPRAM BINARY 9 2 4 23 Both GPPRAM
Field text . . . . . . . . . . . . . . . : Dollar amount


Thanks!
Jim...




Closed Thread


Similar DB2 Database bytes