...
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, "selectSELECT prid, prname, prdesc fromFROM demolib/productsp orderORDER byBY prid"); if (SQLSTATEsqlstate == '00000') { var obj = c1.fetch(); while (c1.hasMoreRows()) { console.log(obj); obj = c1.fetch(); } } pjsc1.close(c1); |