Need help with IBM DB2 data type - Lat/Long (REAL) comes in as (Long) need (Double)

[GeorgeHaskett]

I just connected to our IBM DB2 database for the first time and realized that the coordinates for my point features have been truncated. 

The original data appears to be in REAL data type in DB2.

ArcGIS brings the data in as a LONG data type.  However I need it to come in as a DOUBLE so I can display my X/Y Data...

Any suggestions would be great...

Trying to figure out how to either change it on the mapping end or on the DB2 side.  Preferably on the DB2 side of things.

Thanks,

George Haskett

[GeorgeHaskett · Accepted solution]

UPDATE

Our DB2 guys were able to resolve this one.
No need to reply back to this thread.