...
Code Block | ||
---|---|---|
| ||
pjs.connect("*LOCAL"); var c1 = pjs.allocStmt(); pjs.executeDirect(c1, "select prid, prname, prdesc from demolib/productsp order by prid", "c1"); var obj; if (SQLSTATE == '00000') { obj =while (!pjs.fetchisLastRow(c1, 50);)) { while (SQLSTATEobj == '00000') { pjs.fetch(c1, 50); for (var i = 0; i < SQLERRD[3]pjs.rowCount(c1); i++) { console.log(obj[i]); } obj = pjs.fetch(c1, 50); }} } pjs.close(c1); pjs.disconnect() |