Page Comparison

// 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("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();