Versions Compared

Old Version 4

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Jessica Tomkins

Saved on

Key

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


The following example selects fetches records from a file row-by-row, a table one at a time into specific fields.:

Code Block
languagejavascript
// These definitions should match the table column definitions
pjs.define("prid", { type: "packed decimal", length: 5, decimals: 0, initValue: 105 });
  pjs.define("prname", { type: "char", length: 30 });

 pjs.define("prdesc", { type: "char", length: 60 });

  pjs.connect("*LOCAL");
 
  var c1 = pjs.allocStmt();
  pjsc1.executeDirect(c1, "selectSELECT prid, prname, prdesc fromFROM demolib/productsp orderORDER byBY prid");


 if (SQLSTATEsqlstate == '00000') {
 
  pjs.fetch(c1, prid, prname, prdesc);
 
  while (SQLSTATE == '00000'(c1.hasMoreRows()) {
 
    //Do workProcess withfetched variablesdata here..
 
    pjs.fetch(c1, prid, prname, prdesc);
 
  }
 
}
 
pjsc1.close(c1);


  pjs.disconnect();