Deleting corrupted Empty category/folder
Moderators: chulett, rschirm, roy
Deleting corrupted Empty category/folder
Hi,
I tried to delete empty category/folder in my datastage project but to no avail. The category remains there even after perform delete action using Datastage designer.
I suspect the folder is corrupted. Is there any way to clean up these empty folder/category ?
Thanks,
Jet
I tried to delete empty category/folder in my datastage project but to no avail. The category remains there even after perform delete action using Datastage designer.
I suspect the folder is corrupted. Is there any way to clean up these empty folder/category ?
Thanks,
Jet
Hey try this also (on your own risk)
If the category is at the parent level
Where catname is the name of the category.
else
Where catname1, catname2,...,catnamen-1 is the hierarchy of the parent category and catnamen is the category to be deleted.
Caution: But please don't delete any category in this way if the category has subcategories or jobs within it, it would be dangerous.
If the category is at the parent level
Code: Select all
Delete from DS_JOBS WHERE NAME ='\\\catname'
else
Code: Select all
Delete from DS_JOBS WHERE NAME ='\\\catname1\catname2\catnamen'
Caution: But please don't delete any category in this way if the category has subcategories or jobs within it, it would be dangerous.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As of version 8.x there is no more Manager client. Its functionality is all moved into the DataStage/QualityStage Designer. Fewer client tools, yay!chulett wrote:Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.
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.
I thot it would be more logical to move the functionality to the Director.Very interesting. But I agree it's much better to have less...bit like the cliche "less is more"..ray.wurlod wrote:As of version 8.x there is no more Manager client. Its functionality is all moved into the DataStage/QualityStage Designer. Fewer client tools, yay!chulett wrote:Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: