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