cancel
Showing results for 
Search instead for 
Did you mean: 

Bind Variables to Literals on HANA

former_member217468
Participant
0 Kudos

Hi All,

Is there a way to check the literals behind the bind variables on HANA ( eg SELECT TOP 1 * FROM "USR02" WHERE "MANDT" = ? AND "BNAME" = ?)

Thank you

Jonu Joy

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

You mean after the statement has been executed?

Yes, there is. Check 's script collection in SAP note 1969700 and script HANA_SQL_StatementHash_BindValues_Rev80+.txt for that.

Other than that, using the documentation might be good as well...

former_member217468
Participant
0 Kudos

yes after the execution and is it also possible to capture while in execution .

Thank you Lars for the script .

Former Member
0 Kudos

Alternatively you can also use SQL: "HANA_SQL_ExpensiveStatements_BindValues" (if the statement is captured by the expensive statements trace.