Skip to Content
0

Calling a SQL file from XSJS file in hcp

Jan 31, 2017 at 05:36 AM

72

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers