Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

This method positions the file at the next record with a key or relative record number equal to or greater than that specified in the search argument.

Parameters
  1. Search argument - A Number, String, or Array value specifying a relative record number, key value, or list of key values (array of Number/String). The special values pjs.HIGH_VALUE, pjs.LOW_VALUE, pjs.START, and pjs.END can also be used.
  2. Record format name (optional) - A String value specifying the record format name.

Exception Handling

An Error instance will be thrown with the following properties:

  • message - The message text.
  • error - The message id.
  • help - The message help text.
Examples
Position to end of file to read last record
pjs.defineTable("myfile", { keyed: true, read: true });
myfile.positionTo(pjs.END);
myfile.fetchPrevious();
Read all records with first and second keys equal to 100 and 200
pjs.defineTable("myfile", { keyed: true, read: true });
myfile.positionTo([100, 200]);
myfile.fetchNextEqual([100, 200]);
while (!file.endOfData()) { 
  // Do something with record data here.
  myfile.fetchNextEqual([100, 200]);
} 

RPG Equivalent

SETLL

Requirements

When using an IBM i database, this API requires the Profound.js Connector module.

  • No labels