Reset KeyGenarateNextValue

[deva]

Hi I am using Data stage 7.5 v, I am trying to create auto numbers in two files. It works fine in 7.1 v.

We are recently upgrade to 7.5v , it is giving error, How to rest the KeyMgtGetNextValueConcurrent.

Befour stage sub routine I given Exicute TCL , and I spacify the command as

UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = '1';

but I am getting the error like

Create_ExternalReference_Ass..Transformer_134 (ExecTCL): Error when executing command: UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = '1';
*** Output from UniVerse command was: ***
DataStage/SQL: Table "SDKSequences" does not exist.

Can any one suggest how to solve this problem.

Thanks in advance

deva

[ray.wurlod]

This simply means that SDKSequences does not exist, because none of the key management routines has been executed in the new project. You could test any of these routines, or execute the following command.

Code: Select all

CREATE.FILE SDKSequences 2 1 4

or, if you prefer

Code: Select all

CREATE TABLE "SDKSequences" (TYPE 2, MODULO 1, SEPARATION 4, SEQNAME VARCHAR(254) NOT NULL PRIMARY KEY, NEXTVAL INTEGER DEFAULT 0);