The following example selects fetches records from a file row-by-row, a table one at a time into specific fields.:
| Code Block |
|---|
|
// These definitions should match the table column definitions
pjs.define("prid", { type: "packed decimal", length: 5, decimals: 0, initValue: 105 });
pjs.define("prname", { type: "char", length: 30 });
pjs.define("prdesc", { type: "char", length: 60 });
var c1 = pjs.allocStmt();
c1.executeDirect("selectSELECT prid, prname, prdesc fromFROM demolib/productsp orderORDER byBY prid");
if (SQLSTATEsqlstate == '00000') {
pjs.fetch(c1, prid, prname, prdesc);
while (c1.hasMoreRows()) {
// Process fetched data here
pjs.fetch(c1, prid, prname, prdesc);
}
}
c1.close();
|