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