IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
The .Net DB2 provider (Net.IBM.Data.Db2) seems to have inconsistent support for Geometries. On one hand, any code that returns a Geometry returns it as Well Known Text (WKT), this is nice but the SRID (Spatial Reference ID) information related to the geometry is lost somewhere in the provider. This makes handling returned Geometries difficult, if you get a Geometry back from a calculation or even as a literal you don't know what SRID to set, and subsequent calls to the provider which expect geometries will then fail. It would be better if a geometry object was just returned as a binary representation and you could then at least parse it out. The provider is doing some conversion somewhere to get the string and forget the SRID. Is there a flag or way to handle this?
Hi Colin, we will look into this and update you on our findings.ThanksVishwa