|
I went to the V5R3 SQL Reference and looked up "sequence" in the index. I got the following information: A sequence is referenced by using the NEXT VALUE and PREVIOUS VALUE expressions specifying the name of the sequence. A NEXT VALUE expression generates and returns the next value for a specified sequence. A PREVIOUS VALUE expression returns the most recently generated value for the specified sequence for a previous statement within the current application process. There's more to it, but that is the basic stuff. HTH Vern
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
