Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

HANA Geospatial data types

Go to solution
Former Member

‎2014 Feb 27 10:37 AM

0 Likes
571

Hi pundits,

I am working on case where I need to show an example to store information in HANA Geospatial data types, can fetch it and put it into an local file. I awas going through the internet though I've got some information but not which can help me out.

Vaibhav

1 ACCEPTED SOLUTION
2 REPLIES 2
Read only

Go to solution
Former Member
In response to former_member184871

‎2014 Mar 13 11:23 AM

0 Likes
533

Hi Kumar.

Thanks for the sharing the links. Now I have more knowledge of Geospatial data types. Now when I went ahead created the table with field having thesed spatial data type it is giving me error. Not so sure if I am doign anything wrong. Below the two sql queries.

  1. 1>  create column table "IBMUSER"."LOCATION1"( "SNO" INTEGER null, "DESCRIPTION1" CHAR(100),

"LOCATION" ST_POINT)

Error:

"LOCATION" ...' in 290 ms 200 µs .

SAP DBTech JDBC: [257] (at 102): sql syntax error: incorrect syntax near "ST_POINT": line 2 col 12 (at pos 102)”

  1. 2>  create column table "IBMUSER"."V_GEOSPATIAL" ("F_GEOMETRY" ST_GEOMETRY)

Error:

“SAP DBTech JDBC: [257] (at 60): sql syntax error: incorrect syntax near "ST_GEOMETRY": line 1 col 60 (at pos 60)”


Regards

Vaibhav