Avatar

Community Advisor

Hi,

 

Use queryDef where possible, otherwise use a js activity with sqlGet* or the DBEngine class.

 

E.g.:

var cnx = application.getConnection();
try {
  var res = cnx.query('select sysdate from dual');
  for each (var row in res) logInfo(row[0]);
}
finally {
  cnx.dispose();
}

 

Thanks,

-Jon