Reset set of Sequence Variables

[paddu]

I searched the forum and got this command to initialize a Sequence_name .
UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name';

I have set of Sequence_Names to initialize at a time before starting data load process.

How can i update set of Sequence_Names at once ?
We have about like 40 Sequence_Names ,among then i need to initialize 20 Sequence_Names only

Thanks
Paddu

[DSguru2B]

Build a routine that executes a TCL command with sequence_name as a variable. Have all the sequence names in a sequential file and feed them to the routine in a transformer.

[ray.wurlod]

Is there some regularity to the names? Do you want to reset them all to the same value? If yes, then it's standard SQL.

Code: Select all

UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID IN ('Sequence_Name1', 'SequenceName2', 'SequenceName3');