Content Comparison

  pjs.define("productsp_out", { type: 'data structure', qualified: true, dim: 50, elements: {
    "prid": { type: "packed decimal", length: 5, decimals: 0, initValue: 105 },
    "prname": { type: "char", length: 30 },
    "prdesc": { type: "char", length: 60 }
  }})

  pjs.connect("*LOCAL");
 
  pjs.clear(productsp_out);

  var c1 = pjs.allocStmt();
  pjs.executeDirect(c1, "select prid, prname, prdesc from demolib/productsp order by prid", "c1");

  if (SQLSTATE == '00000') {

    while (!pjs.fetchisLastRow(c1, productsp_out, 50);

    if (SQLSTATE == '00000') {
      //SQLERRD[3] = count of rows returnedpjs.fetch(c1, productsp_out, 50);
         for (var i = 1; i <= SQLERRD[3]pjs.rowCount(c1); i++) {
        console.log({ 
          id: productsp_out[i].prid, 
          name: productsp_out[i].prname, 
          desc: productsp_out[i].prdesc 
        });
      }
    }

  }

  pjs.close(c1);