Skip to Content
avatar image
Former Member

How do I run a prepared statement in SAP HANA hdbsql cons?

Hi,

I am looking for a way to execute this query string in hdbsql on SAP HANA 2.0:

SELECT * FROM T WHERE A IN (?, ?)

in the next step, I would like to bind these parameters. But hdbsql always returns:

* -10304: Parameter/Column (1) not bound. SQLSTATEs. 07002
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2017 at 03:38 AM

    Hi,

    AFAIK, you can't perform this workflow in hqbsql, prepared statements already used by default in hdbsql - you have to use -r to disable them.

    But you cant pass your own bound parameters - you have to use literals instead. It doesn't provided an interface to supply bound parameters to prepared statements presented by '?'. The prepared statements are only used to enable routing features in the client.

    Regards,

    Duy Ngo

    Add comment
    10|10000 characters needed characters exceeded