Creating a sequence number in a view is easy. Simply add this derived field - ACCUM(1) - to your view like so:

SELECT ACCUM(1) NAME(seq) LEN(3,0), cusno, cname 
FROM sequelex/custmast


See Also:

Remove Non-alpha Characters From a String

The MOD Function


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: August 12, 2020