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
To Rename Job Category
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
You must create a new category, move all the objects to the new category, then delete the old category.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.