I would like to generate a sequential number during an mload. I don't want an identity column, but would like each row inserted during the mload to have a sequential number. Is this possible? Haven't been able to find anything on this.
I can't think of a solution. I have never encountered this problem. Did you have a look at mload SYSTEM variables(&SYS) if any luck. Else I think of a logic post mload, based on fields but that is expensive.
Can you please exaplian a little what do you want to achieve? I have done such work in one of my projects using TPT.
Give me some more explaination and I hope we can find a way.