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
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |