Hi Colleagues,
In hcp development workbench editor, I have a package which contains a .sql file and a .xsjs file. I want to call/trigger the .sql(say xyz.sql) file from the .xsjs file.
When i do a query execute in xsjs like
var query = "CALL \"SYSTEM\".\"{packageName}::xyz\"";
..it wouldn't work. (500 internal server error)
I can also store this sql script as a hana procedure and call the procedure but can we just simply execute the .sql file?
Any suggestions would be really helpful!
Regards,
Devam.
Add comment