...
Code Block | ||
---|---|---|
| ||
var c1 = pjs.allocStmt(); pjs.executeDirect(c1, "SELECT prid, prname, prdesc FROM demolib/productsp ORDER BY prid"); if (SQLSTATE == '00000') { var obj = c1.fetch(); while (c1.hasMoreRows()) { console.log(obj); obj = c1.fetch(); } } pjsc1.close(c1); |