Previous Topic: KEEP=YES on &NDBSEQ

Next Topic: &NDBGET DIR= and SKIP=

&NDBSEQ RESET

A defined sequence can also be reset, allowing you to restart the sequence at any point. For example, after reading forward, and getting an EOF response, you are positioned after the last record in the sequence. Forward gets will continue to return the EOF response. To re-read from the beginning, issue an &NDBSEQ RESET as shown:

&NDBSEQ dbname RESET SEQ=seqname

Optionally, you can nominate a key value to reposition to. The next get will return the first record with the matching, or higher, or lower, if no match, and depending on the direction:

&NDBSEQ dbname RESET SEQ=seqname REPOS=value