topic Null Values when join database to shapefile in Data Management Questions https://community.esri.com/t5/data-management-questions/null-values-when-join-database-to-shapefile/m-p/428870#M24528 <HTML><HEAD></HEAD><BODY><P>I am having trouble sucessfully joining a DB2/400 SQL table to my shapefile in ArcMap 10.2.&nbsp; I created an OLE ODBC database connection in ArcCatalog and it opens up the connection to the database tables that I need.&nbsp; I then bring one of the database tables into my project.&nbsp; I try to join it to the shapefile, which it appears to do, but I end up with only null values.&nbsp; The join used to work in ArcView 3.3 so I know the database fields match (both string fields,etc.).&nbsp; Plus, if I export the database to a DBF and bring that into the project, it joins to the shapefile with no problem.&nbsp; How can I get the join to work with out converting the table to a DBF first??? Any help would be much appreciated!</P></BODY></HTML> Thu, 06 Nov 2014 19:58:11 GMT MonteWestphal 2014-11-06T19:58:11Z Null Values when join database to shapefile https://community.esri.com/t5/data-management-questions/null-values-when-join-database-to-shapefile/m-p/428870#M24528 <HTML><HEAD></HEAD><BODY><P>I am having trouble sucessfully joining a DB2/400 SQL table to my shapefile in ArcMap 10.2.&nbsp; I created an OLE ODBC database connection in ArcCatalog and it opens up the connection to the database tables that I need.&nbsp; I then bring one of the database tables into my project.&nbsp; I try to join it to the shapefile, which it appears to do, but I end up with only null values.&nbsp; The join used to work in ArcView 3.3 so I know the database fields match (both string fields,etc.).&nbsp; Plus, if I export the database to a DBF and bring that into the project, it joins to the shapefile with no problem.&nbsp; How can I get the join to work with out converting the table to a DBF first??? Any help would be much appreciated!</P></BODY></HTML> Thu, 06 Nov 2014 19:58:11 GMT https://community.esri.com/t5/data-management-questions/null-values-when-join-database-to-shapefile/m-p/428870#M24528 MonteWestphal 2014-11-06T19:58:11Z