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
Still have questions? We can help. Submit a case to Technical Support.