Execute SQL Command simply.

This supports only one return value

 

let result=sql.select("select \"ItemName\" from \"OITM\" where \"ItemCode\"='RM' ");
alert(result);

 

SQL is a global function and allows different solutions

sql("SqlString");
sql(SqlString);

sql.select ....

 

The second variant is special in HANA simple to use

You can use place holder defined with ":". System convert automatically to correct format

let a='RM'
let result=sql(select "ItemName" from "OITM" where "ItemCode"=:a);

 

or by string with template string and placeholder

Note: you must convert strings, date and numbers in correct format

let ls_itemcode="RM";
let ls_Sql=`select "ItemName" fro "OITM" where "ItemCode"=${ls_itemcode.dbString()}`;
let result=sql.select(ls_sql);

 

 

For more information see SQL Intro.