topic Need help with IBM DB2 data type - Lat/Long (REAL) comes in as (Long) need (Double) in Data Management Questions https://community.esri.com/t5/data-management-questions/need-help-with-ibm-db2-data-type-lat-long-real/m-p/185607#M10473 <HTML><HEAD></HEAD><BODY><SPAN>I just connected to our IBM DB2 database for the first time and realized that the coordinates for my point features have been truncated.&nbsp; </SPAN><BR /><BR /><SPAN>The original data appears to be in REAL data type in DB2.</SPAN><BR /><BR /><SPAN>ArcGIS brings the data in as a LONG data type.&nbsp; However I need it to come in as a DOUBLE so I can display my X/Y Data...</SPAN><BR /><BR /><SPAN>Any suggestions would be great...</SPAN><BR /><BR /><SPAN>Trying to figure out how to either change it on the mapping end or on the DB2 side.&nbsp; Preferably on the DB2 side of things.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>George Haskett</SPAN></BODY></HTML> Mon, 05 Aug 2013 19:16:24 GMT GeorgeHaskett 2013-08-05T19:16:24Z Need help with IBM DB2 data type - Lat/Long (REAL) comes in as (Long) need (Double) https://community.esri.com/t5/data-management-questions/need-help-with-ibm-db2-data-type-lat-long-real/m-p/185607#M10473 <HTML><HEAD></HEAD><BODY><SPAN>I just connected to our IBM DB2 database for the first time and realized that the coordinates for my point features have been truncated.&nbsp; </SPAN><BR /><BR /><SPAN>The original data appears to be in REAL data type in DB2.</SPAN><BR /><BR /><SPAN>ArcGIS brings the data in as a LONG data type.&nbsp; However I need it to come in as a DOUBLE so I can display my X/Y Data...</SPAN><BR /><BR /><SPAN>Any suggestions would be great...</SPAN><BR /><BR /><SPAN>Trying to figure out how to either change it on the mapping end or on the DB2 side.&nbsp; Preferably on the DB2 side of things.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>George Haskett</SPAN></BODY></HTML> Mon, 05 Aug 2013 19:16:24 GMT https://community.esri.com/t5/data-management-questions/need-help-with-ibm-db2-data-type-lat-long-real/m-p/185607#M10473 GeorgeHaskett 2013-08-05T19:16:24Z Re: Need help with IBM DB2 data type - Lat/Long (REAL) comes in as (Long) need (Doubl https://community.esri.com/t5/data-management-questions/need-help-with-ibm-db2-data-type-lat-long-real/m-p/185608#M10474 <HTML><HEAD></HEAD><BODY><SPAN>UPDATE</SPAN><BR /><BR /><SPAN>Our DB2 guys were able to resolve this one.</SPAN><BR /><SPAN>No need to reply back to this thread.</SPAN></BODY></HTML> Thu, 03 Oct 2013 16:02:51 GMT https://community.esri.com/t5/data-management-questions/need-help-with-ibm-db2-data-type-lat-long-real/m-p/185608#M10474 GeorgeHaskett 2013-10-03T16:02:51Z