Page Comparison

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("select prid, prname, prdesc from demolib/productsp order by prid");

if (SQLSTATE == '00000') {
 
  pjs.fetch(c1, prid, prname, prdesc);
  while (c1.hasMoreRows()) {
    // Process fetched data here
    pjs.fetch(c1, prid, prname, prdesc);
  }
 
}
 
c1.close();