Unix Technical Forum

PHP, DB2, iSeries, PASE, binary field question

This is a discussion on PHP, DB2, iSeries, PASE, binary field question within the DB2 forums, part of the Database Server Software category; --> When I access my DB2 table from a W2K machine running PHP using ODBC with the SQL statement: SELECT ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:36 PM
Jim Gerland
 
Posts: n/a
Default 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...



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:57 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com