Skip to Content
0

Problem with HANA Update -10210 Invalid command state (No prepared SQL command)

Dec 20, 2016 at 05:54 PM

107

avatar image
Former Member

Hi,

I am using ODBC to query HANA. I am also able to do a select and have data come from HANA. However, when I am trying to do an Update, I get the following error.

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10210 Invalid command state (No prepared SQL command)

Following is the SQL Query I am using

hxehost.."XXX."US_PEOPLE" set "FIRST_NAME" = 'Mr. X' where "PHONE1"= '123-111-1111'

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sergio Guerrero Dec 20, 2016 at 07:18 PM
0

are you missing the actually UPDATE keyword ?

update <Table> -- first word on this line

set <col> = <value>

where <col>=<condition>

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks for your input however i added the update keyword in query. The same query is running in HANA Studio but not through external system

0