471,306 Members | 863 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

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.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...

Jul 17 '05 #1
0 1941

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thad Rizzi | last post: by
reply views Thread by Jim Gerland | last post: by
4 posts views Thread by erkki | last post: by
3 posts views Thread by ah077 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.