PHP, DB2, iSeries, PASE, binary field question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jim Gerland

    PHP, DB2, iSeries, PASE, binary field question

    When I access my DB2 table from a W2K machine running PHP using ODBC with
    the SQL statement:

    SELECT DOUBLE(BGROUP.P YHGPT.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...



Working...