Skip to Content
avatar image
Former Member

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

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'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 20, 2016 at 07:18 PM

    are you missing the actually UPDATE keyword ?

    update <Table> -- first word on this line

    set <col> = <value>

    where <col>=<condition>

    Add comment
    10|10000 characters needed 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