Delete Categories
Moderators: chulett, rschirm, roy
Delete Categories
Hi,
We are not able to delete few empty Categories, tried it from manager, designer but it gives the message "Record Category_Name in the file DS_JOBS does not exist.
Thanks,
We are not able to delete few empty Categories, tried it from manager, designer but it gives the message "Record Category_Name in the file DS_JOBS does not exist.
Thanks,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Delete Categories
Hello Ray i tried deleting category with jobs inside it as well as empty category from client machine, it deletes immediately and refreshes.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
They are empty directories and gives message "Record Category_Name in the file DS_JOBS does not exist" even when we open up designer window pops up for each such directories and we have to click several times before opening up the job in other category. Is there a way to clean up DS_JOBS or DS_OBJECTS.
Thanks
They are empty directories and gives message "Record Category_Name in the file DS_JOBS does not exist" even when we open up designer window pops up for each such directories and we have to click several times before opening up the job in other category. Is there a way to clean up DS_JOBS or DS_OBJECTS.
Thanks
The message would seem to indicate you had a job called 'Category_Name' or did you replace that text?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Job Categories are separate records in DS_JOBS beginning with \\\.
For example, to delete the category MyJobs\LoadHash you could execute
It might be worth while to check first that the category is empty.
For example, to delete the category MyJobs\LoadHash you could execute
Code: Select all
DELETE FROM DS_JOBS WHERE NAME = '\\\MyJobs\LoadHash\';
Code: Select all
SELECT CATEGORY, COUNT(*) AS ITEMS FROM DS_JOBS GROUP BY CATEGORY HAVING COUNT(*) = 1;
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.