The following example selects records from a file row-by-row, into a primitive object.
pjs.connect("*LOCAL"); var c1 = pjs.allocStmt(); pjs.executeDirect(c1, "select prid, prname, prdesc from demolib/productsp order by prid", "c1"); if (SQLSTATE == '00000') { var obj = pjs.fetch(c1); while (SQLSTATE == '00000') { console.log(obj); obj = pjs.fetch(c1); } } pjs.close(c1);