Fetch into fields

Content Freeze

As of July 25th, 2023, there is a content freeze on this page.

The following example fetches records from a table one at a time into specific fields:

// 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("SELECT prid, prname, prdesc FROM demolib/productsp ORDER BY prid");

if (sqlstate == '00000') {
 
  pjs.fetch(c1, prid, prname, prdesc);
  while (c1.hasMoreRows()) {
    // Process fetched data here
    pjs.fetch(c1, prid, prname, prdesc);
  }
 
}
 
c1.close();