Content Freeze
As of July 25th, 2023, there is a content freeze on this page.
The following example reads records from a table one at a time into a primitive JavaScript object:
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();
}
}
c1.close();