Skip to Content
0

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

Oct 19, 2017 at 08:31 AM

129

avatar image
Former Member

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Duy Ngo
Oct 26, 2017 at 03:38 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded