Previous Topic: Notes on Sequential Retrieval

Next Topic: &NDBSEQ RESET

KEEP=YES on &NDBSEQ

By default, a sequence is automatically deleted when an end-of-file response is returned (&NDBRC = 2). This is normally what is wanted, and saves you coding an &NDBSEQ DELETE. If, however, you want the sequence to stay defined, you can code KEEP=YES on the &NDBSEQ DEFINE, and the sequence stays defined until explicitly deleted, or the NDB is closed.