Hello everyone, I am trying to call an xsjs service from Fiori. The xsjs service calls an calculation view and fetches the data. In the SQL console the query is taking around 200s to fetch data. Below is my xsjs code. try{ var connection = $.hd...

Hi, I want to write the xsjs response in a .dat file. I am able to write the response in .dat file and its being downloaded. This is the below code. $.response.setBody(strF); $.response.contentType = 'application/vnd.ms-excel; charset=utf-16...

I have written UPSERT query in xsjs and I am trying to do batch operation . var connection = $.hdb.getConnection(); var query = "UPSERT \"TABLE_NAME\"( "COL_1","COL_2","COL_3") VALUES ( ?,?,?) where \"COL_3\"='1234'"; var data = [['A',100,'1234'],...

I am getting this below error "500 transaction rolled back by an intexernal error: Assertion failed: col" after calling the hana stored procedure from the XSJS This is how I am calling the procedure from the XSJS. var pstmt=conn.prepareStat...