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: April 21, 2017