To Rename Job Category

[debasisp]

Hi,
I have to rename my job category. And all the categories are having subcategories. My requirement is ...

To change Job1\sub1 to Job2\sub1
Job1\sub2 to Job2\sub2
Job1\sub3 to Job2\sub3 .... like this.

I used UPDATE DS_JOBS SET CATEGORY='Job2\sub1' WHERE CATEGORY='Job1\sub1'; ...etc etc

But I have to run this UPDATE command for all the jobs ...

Can anyone help me out that how can I do that in a single UPDATE statement ... I mean like we have REPLACE function in the SQL ... is there any such function available or not.

Thanks
Debasis

[ray.wurlod]

You can not rename categories. They are more deeply embedded than you suspect.

You must create a new category, move all the objects to the new category, then delete the old category.

[chulett]

I would just bite the bullet and do this through the GUI, it's not really that bad and it will be over before you know it.

You could also export the jobs in question and use an editor on the .dsx file to make the changes noted.