generate 4 digit sequence number
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
generate 4 digit sequence number
i have to generate a 4 digit sequence number after the whole job is created. And the when i run the job second time the generates sequence number should be equal to old number +1. i,e for each run sequence number should be increased. for this i cannot use oracle sequencer because of permissions. is there any stage i can use. can i get this number using unix script.
I would recommend having your DBA create a sequence for you. This is what they are designed for and doing it another way is going to be more work to write and much more work to maintain - particularly when things go wrong.
You could use the server key management routines as Craig suggested, or you could create your own control file and update that. Try searching the forum as this topic has come up many times already.
Again - use your database's builtin facilities. Question why there are "permission" issues.
You could use the server key management routines as Craig suggested, or you could create your own control file and update that. Try searching the forum as this topic has come up many times already.
Again - use your database's builtin facilities. Question why there are "permission" issues.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How do you propose to guarantee the "+1" requirement across an arbitrary number of parallel processing nodes? Are you going to introduce a bottleneck by forcing a Column Generator stage to execute in sequential mode? Is this, indeed, a sensible requirement in a parallel job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
You can use the Surrogate key generator stage available in the parallel jobs..
It generates unique numbers on any number of processing nodes....
Hope this helps..
It generates unique numbers on any number of processing nodes....
Hope this helps..
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>