generating sequention number during mload

Tools
Enthusiast

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.

4 REPLIES
Enthusiast

Re: generating sequention number during mload

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

Teradata Employee

Re: generating sequention number during mload

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

Enthusiast

Re: generating sequention number during mload

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
Senior Supporter

Re: generating sequention number during mload

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