Skip to Content
avatar image
Former Member

Calling a SQL file from XSJS file in hcp

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
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers