Sign in to Community
Sign in to view all badges
Hi,How I can use the output of SQL Code activity in a following JS activity?
I'm typing below code in SQL activity:SELECT max(iId) FROM CusTestDataSchema
What should I type in JS to receive SQL's output? vars.output doesn't work here.
Hello @marcinkacz ,
Use queryDef where possible, otherwise use a js activity with sqlGet* or the DBEngine class.
var cnx = application.getConnection();
var res = cnx.query('select sysdate from dual');
for each (var row in res) logInfo(row);