batch SID
Moderators: chulett, rschirm, roy
I guess you are talking in terms of peoplesoft related product EPM!!!!Can anyone tell me how can we generate batch SID for the datastage jobs. If there is any routine then plz send it across it to me.
It is nonthing but the sequence number genarated per run, i.e., for one run of a job one particular number, that's all.
The purpose could be tracing the runs when say a particular table (e.g. error table) was populated.
The routine is as simple as KeyMgtGetNextValue.
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My priority is always to those that pay me. Misspelling my name and using SMS-style abbreviations reduces my desire to help. If you were paying for my time you would be in a better position to demand help from me personally. I post on the forum as and when I can, and I am probably in a different time zone than yours (see Location in my profile - it changes from time to time).
As others have noted, you have not explained what you mean by your term. Clearly it is not one with which we are familiar, otherwise we would not be asking. Do you mean a "guid" from SQL Server? (If so, search for GUID - this has been answered in the past.) Otherwise there are lots of ways of generating unique values within DataStage, including the SDK Key Management routines.
As others have noted, you have not explained what you mean by your term. Clearly it is not one with which we are familiar, otherwise we would not be asking. Do you mean a "guid" from SQL Server? (If so, search for GUID - this has been answered in the past.) Otherwise there are lots of ways of generating unique values within DataStage, including the SDK Key Management routines.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you want batch SID for jobs. Job are uniquly named, so no need to serialize it. If you are using any multiple instance job, and if you are expecting the invocation id to be serialized, you have several option.
Or if you are expeting the jobs to have release no, it is done by version control.
Help us to help you...
What exactly you need?
What are you trying to do?
Or if you are expeting the jobs to have release no, it is done by version control.
Help us to help you...
What exactly you need?
What are you trying to do?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Good Lord... you complain you've had no reply after an HOUR?mohanraj wrote:hi
why no reply
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
What was wrong with the KeyMgtGetNextValue() suggestion? That's one of the easiest way to do that in a DataStage job. If that won't work - as noted, tell us why not, make your needs clearer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers