// These definitions should match the table column definitions
pjs.define("prid", { type: "packed decimal", length: 5, decimals: 0 });
pjs.define("prname", { type: "char", length: 30 });
pjs.define("prdesc", { type: "char", length: 60 });
var c1 = pjs.allocStmt();
c1.executeDirect("SELECT prid, prname, prdesc FROM demolib/productsp ORDER BY 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();
|