Multi-row fetch into primitive object



The following example reads records from a table 50 rows at a time into a primitive JavaScript object:

var c1 = pjs.allocStmt(); c1.executeDirect("SELECT prid, prname, prdesc FROM demolib/productsp ORDER BY prid"); if (sqlstate == '00000') { while (c1.hasMoreRows()) { var records = c1.fetch(50); for (var i = 0; i < c1.rowCount(); i++) { var record = records[i]; console.log(record); } } } c1.close();