Hi All,
I got stuck when resetting the value in SDKSequences routine.
I used the below statement in UV environment.
UPDATE SDKSequences USING DICT VOC SET F1='87228' WHERE @ID='<sequence name>';
1. The execution takes too long.
2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".
Please help.
Also, I tried to ran the routine manually and the sequence number is incremental in the output of the routine. But the hash file is not updated.
Please help me to understand why hash file is not updated when routine was run manually?
Thanks
Arif
Help resetting SDKSequences
Moderators: chulett, rschirm, roy
... or just wait for someone to come along and split them for you.
Here is the original 11 yeard old topic for reference:
viewtopic.php?t=98814
And since this was your first post, had to guess about your version number. Please feel free to edit your post and correct it if needed.
![Wink :wink:](./images/smilies/icon_wink.gif)
Here is the original 11 yeard old topic for reference:
viewtopic.php?t=98814
And since this was your first post, had to guess about your version number. Please feel free to edit your post and correct it if needed.
-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:
Re: Help resetting SDKSequences
DataStage will not update the hashed file if it cannot lock the record for update.imsularif wrote: Please help me to understand why hash file is not updated when routine was run manually?
2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".
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.