Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejavascript
  pjs.connect("*LOCAL");
 
  var c1 = pjs.allocStmt();
  pjs.executeDirect(c1, "select prid, prname, prdesc from demolib/productsp order by prid", "c1");

  var obj;

  if (SQLSTATE == '00000') {

   obj =while (!pjs.fetchisLastRow(c1, 50);)) {
     while (SQLSTATEobj == '00000') { pjs.fetch(c1, 50);
        for (var i = 0; i < SQLERRD[3]pjs.rowCount(c1); i++) {
        console.log(obj[i]);
      }
        
      obj = pjs.fetch(c1, 50);
    }}

  }

  pjs.close(c1);


  pjs.disconnect()