Previous Topic: Retrieve Keyed Field Statistics (Histogram)

Next Topic: KEEP=YES on &NDBSEQ

Notes on Sequential Retrieval

The &NDBSEQ verb and the &NDBSCAN verb let you specify a name for a sequence. Unlike the &FILE verbs, an NCL process can have any number of concurrent sequences defined on any number of databases. Positioning is handled internally, with no need to use accompanying number of VSAM strings.

The only overhead is an internal NDB control block that maintains positioning.

Performing a direct get does not destroy any positioning maintained by active sequences.