SDKSequence

appcon · Post by **appcon** » Thu Jul 08, 2004 7:03 am

HI,

I am trying to generate sequence number using the sdk/KeyMgt> KeyMgtGetNextValue. During the course, I accidentally deleted the SDKSequence file that's generated by this function. Now I am getting this error. And the job is not running as before.

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

Could anyone help me with this problem.

Thanks in advance.

roy · Post by **roy** » Thu Jul 08, 2004 7:08 am

Hi,
since the file exists in your voc file if any attempts to create a new entry with an existing name without the overriding clause will fail the simplest way would be to delete this entry in the voc file (don't play with it if you don't knoww how) you can find in this forum posts on how to do the above.
another way is to simply use another file name (by copying the routine in another name and changing the file name so it will have a new voc name entry)
this will also enable you to have multiple indipendant keys for different uses.

IHTH,

kduke · Post by **kduke** » Thu Jul 08, 2004 8:42 am

DELETE VOC SDKSequences

appcon · Post by **appcon** » Thu Jul 08, 2004 8:53 am

[quote="kduke"]DELETE VOC SDKSequences[/quote]

How to access VOC..I mean how to open that file on the front end. Or is it something I need to do on cmd prompt. Any specific syntax or cmd lines.

I appreciate if you can provide some more details.

Thanks,

chucksmith · Post by **chucksmith** » Thu Jul 08, 2004 10:20 am

Use DataStage Administrator. From the Projects tab, select your project, then press the Command button. Now you can enter the delete command in the Command box and press the Execute button.

denzilsyb · Post by **denzilsyb** » Thu Jul 08, 2004 10:22 am

Hallo appcon

Use Administrator, select your project and select COMMAND.

Then type the command you want and its all done.