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

[robin_rehrmann]

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

[former_member368981]

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