Generating sequence number in server job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
samythiru
Participant
Posts: 13
Joined: Tue Feb 28, 2006 3:55 pm

Generating sequence number in server job

Post by samythiru »

Hi All,

I am using KeyMgtGetNextValue transform inside transformer for generating sequence number .

I am passing 100 as the initial value for SequenceName KeyMgtGetNextValue(%SequenceName%).

My job aborted with following error .

DataStage Job 1063 Phantom 29104
"SDKSequences" is already in your VOC file as a file definition record.
File name = Attempting to Cleanup after ABORT raised in stage x..Transformer_1
DataStage Phantom Aborting with @ABORT.CODE = 3


If any one know about the error . Please let me know .
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Either you don't have permission to SDKSequences or someone has deleted one or both of SDKSequences and D_SDKSequences using operating system commands. The key management routine, because it can't open SDKSequences hashed file, attempts to create it.

It is up to you to determine which of the above scenarios obtains, in order that correct remedial action may be recommended. Please post your response.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply