Page 1 of 1
Deleting corrupted Empty category/folder
Posted: Thu Nov 17, 2005 9:43 pm
by jetlim
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
Posted: Thu Nov 17, 2005 10:57 pm
by chulett
Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.
Posted: Fri Nov 18, 2005 12:50 am
by jetlim
Yes tried with Datastage manager but still fail to delete the folder. Any other how to resolve ?
Posted: Fri Nov 18, 2005 3:08 am
by loveojha2
Hey try this also (on your own risk)
If the category is at the parent level
Code: Select all
Delete from DS_JOBS WHERE NAME ='\\\catname'
Where catname is the name of the category.
else
Code: Select all
Delete from DS_JOBS WHERE NAME ='\\\catname1\catname2\catnamen'
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.
Posted: Fri Nov 18, 2005 8:15 am
by chulett
jetlim wrote:Yes tried with Datastage manager but still fail to delete the folder. Any other how to resolve ?
Do you get an
error of any kind? What actually happens when you attempt the deletion?
Posted: Fri Nov 18, 2005 8:50 am
by ray.wurlod
chulett wrote:Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.
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!
Posted: Mon Nov 21, 2005 11:31 pm
by chinek
ray.wurlod wrote:chulett wrote:Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.
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!
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"..
Posted: Thu Mar 09, 2006 9:32 pm
by myotoo
Jet,
In datastage administrator, command line delete statement can delete this category.
Regards,
Myo
Posted: Fri Mar 10, 2006 6:31 am
by ray.wurlod
It may also be that the index on CATEGORY is not up to date. You may try re-indexing the Repository.