Connecting Tech Pros Worldwide Help | Site Map

PHP, DB2, iSeries, PASE, binary field question

  #1  
Old July 17th, 2005, 03:28 AM
Jim Gerland
Guest
 
Posts: n/a
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 Threads
Thread Thread Starter Forum Replies Last Post
PHP, DB2, iSeries, PASE, binary field question Jim Gerland answers 0 November 12th, 2005 06:13 AM