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
Remove Non-alpha Characters From a String
The MOD Function
Still have questions? We can help. Submit a case to Technical Support.
Copyright © 2019 HelpSystems