Hi,
I have a datastage parallel Job where I need to generate keys based on the valus stored in the SDK_Sequences file using the KeyMgtGetNextValue server routine. By accessing this value I will generate keys based on the value in the file and insert the value in the table. Now i m tring to convert my job to parallel, But I am not able to figure out the parallel equivalent of the routine KeyMgtGetNextValue.
Datastage parallel Routines
Moderators: chulett, rschirm, roy
There's no coversion for that. If you have to use the value from the SDK hashed file, you'll need to use the BASIC Transformer or a Server Shared Container.
Are you actively sharing this key source with Server jobs? If not, why not switch to a parallel source like the Surrogate Key Generator stage?
Are you actively sharing this key source with Server jobs? If not, why not switch to a parallel source like the Surrogate Key Generator stage?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
<rant>
Resist stupid requirements!
</rant>
What's the functional difference between a state file (used by SKG stage) and a hashed file (used by SDK routine)? None!
Resist stupid requirements!
</rant>
What's the functional difference between a state file (used by SKG stage) and a hashed file (used by SDK routine)? None!
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.
Sorry but I'm afraid I don't understand either sentence in this context. Does the first one refer to the question I asked? Are you saying that you have both Server and PX jobs populating this table and they need to use a common key source? For the second sentence, I have no idea what "we cannot lose the values during runtime" might be referring to.major wrote:we cannot go for surrogate key stage as we need to maitain the referntial integrity of the keys. moreover we will use these keys in other jobs so as we cannot lose the values during runtime
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I need to use KeyMgtGetNextValue server routine in parallel job. I'm unable to use it parallel job. Is there any other parallel routine similar to it or how i can achieve the same functionality?chulett wrote:Sorry but I'm afraid I don't understand either sentence in this context. Does the first one refer to the question I asked? Are you saying that you have both Server and PX jobs populating this table and they need to use a common key source? For the second sentence, I have no idea what "we cannot lose the values during runtime" might be referring to.major wrote:we cannot go for surrogate key stage as we need to maitain the referntial integrity of the keys. moreover we will use these keys in other jobs so as we cannot lose the values during runtime
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You would have to write your own routine that invoked the "UniVerse" C API functions for invoking hashed files.
To pre-empt your next question, there is no other way if you insist upon using SDKSequences from a parallel Transformer stage.
To pre-empt your next question, there is no other way if you insist upon using SDKSequences from a parallel Transformer stage.
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.