I want to generate a sequence number starts from 000000 and increment by 1 for each load.
for eg:- if source contains 1000 records for first load,
sequence number should start from 000001 and ends at 001000.
for second load, if source contains 2000 records,
then sequence number should start from 001001 and ends at 003000.
is there any readymade function that we can use or do i need to write a code in server routine?
Thanks in advance
counter needs to be incremented by 1 with exactly 6 digit
Moderators: chulett, rschirm, roy
Pongal,
you could write a function that returns the number of rows processed in the last run of a job, use the DSGetLinkInfo() routine and give it the stage and link name and it can return the number of rows processed. This number can then be used to update either a Hashed file or a table with the new sequence starting number.
you could write a function that returns the number of rows processed in the last run of a job, use the DSGetLinkInfo() routine and give it the stage and link name and it can return the number of rows processed. This number can then be used to update either a Hashed file or a table with the new sequence starting number.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA