Help resetting SDKSequences
Posted: Tue Mar 13, 2018 7:59 am
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
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