Skip to Content

BIND_AS_VALUE function in SAP HANA

Hi, I am trying to understand the functionality and usage of this function, going through the example in HANA SQL reference guide, not able to get it fully. What difference it makes using Input parameter directly Vs BIND_AS_VALUE function in WHERE condition. When should I use BIND_AS_VALUE function? I can't find a difference in using this function, can you provide me an example on this function to understand better?

Thanks

Sreekanth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 25 at 04:53 AM

    In the exercises of the openSAP course Software Development on SAP HANA which you can find here, the behavior is described in detail with examples in chapter 2.11.15 (New Parameterization Behavior).

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25 at 05:49 PM

    Perfect, thank you so much Florian. I have gone through the Exercise, it is clear now. Your answers are very helpful as always.

    this function is used to override the HANA 2.0 optimizer behavior, so with that, it always prepares the Constant value, though I call the procedure with parameter value.

    Add comment
    10|10000 characters needed characters exceeded