Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version 4

changes.mady.by.user Alex Roytman

Saved on

Key

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

The following example selects reads records from a file row-by-row, into a primitive object.table on at a time into primitive JavaScript objects:

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



if (SQLSTATE == '00000') {
    var obj = pjs.fetch(c1);
   
  
  while (SQLSTATE == '00000') {
 
    console.log(obj);
      obj = pjs.fetch(c1);
 
  }
 
}



pjs.close(c1);




pjs.disconnect();