...
The following example reads records from a table one at a time into a primitive JavaScript objectsobject:
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(); } } pjsc1.close(c1); |