Key Management

baranee_svsp · Post by **baranee_svsp** » Wed Nov 30, 2005 2:59 am

How to reset the initial values in Routines(Key Management)?

Himani · Post by **Himani** » Wed Nov 30, 2005 3:36 am

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

You can use this in the before/after subroutine
Regards,
Himani

srinagesh · Post by **srinagesh** » Wed Nov 30, 2005 3:37 am

I would recommend using of SEARCH functionality provided, before you post in the forum.

Hope this article helps viewtopic.php?t=92652&highlight=keymgtgetnextvalue

asoka_dwh · Post by **asoka_dwh** » Fri Apr 28, 2006 11:52 am

Himani wrote:UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name';

You can use this in the before/after subroutine
Regards,
Himani

Hi Himani,

i tried using above command in before Tcl in stage properties, it returns error where from command line in administrator we can do and get exact result

regards

DSguru2B · Post by **DSguru2B** » Fri Apr 28, 2006 12:21 pm

Use this command in the job properties.
Delete from SDKSequences;

and set Before-Job Routine to ExecTCL

ray.wurlod · Post by **ray.wurlod** » Fri Apr 28, 2006 4:05 pm

You want to delete ALL sequences from SDKSequences?!!!
Probably not.
Add a WHERE clause to the DELETE.