/

Multi-row fetch into primitive object

Multi-row fetch into primitive object

Owned by Former user (Deleted)

Last updated: Aug 16, 2023 by Jessica Tomkins

1 min read

The following example reads records from a table 50 rows at a time into a primitive JavaScript object:

var c1 = pjs.allocStmt();
c1.executeDirect("SELECT prid, prname, prdesc FROM demolib/productsp ORDER BY prid");

if (sqlstate == '00000') {

  while (c1.hasMoreRows()) {
    var records = c1.fetch(50);
    for (var i = 0; i < c1.rowCount(); i++) {
      var record = records[i];
      console.log(record);
    }
  }

}

c1.close();