All Forums Tools
rparman 3 posts Joined 07/13
15 Nov 2013
generating sequention number during mload

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.

Raja_KT 1246 posts Joined 07/09
15 Nov 2013

Hi,
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.
Good luck,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SuSeSi 61 posts Joined 10/08
06 Dec 2013

You can have Stored procedures but I guess mload does not support, may be tpump?

-Sudhansu

M.Saeed Khurram 544 posts Joined 09/12
06 Dec 2013

hi,
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.
 

Khurram

ulrich 816 posts Joined 09/09
06 Dec 2013

inmods can do that but would require additional programing - check the manuals

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.