Deleting corrupted Empty category/folder

jetlim · Post by **jetlim** » Thu Nov 17, 2005 9:43 pm

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

chulett · Post by **chulett** » Thu Nov 17, 2005 10:57 pm

Have you tried performing the deletion from the Manager? There are client tools other than the Designer, ya know.

jetlim · Post by **jetlim** » Fri Nov 18, 2005 12:50 am

Yes tried with Datastage manager but still fail to delete the folder. Any other how to resolve ?

loveojha2 · Post by **loveojha2** » Fri Nov 18, 2005 3:08 am

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.

chulett · Post by **chulett** » Fri Nov 18, 2005 8:15 am

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?

ray.wurlod · Post by **ray.wurlod** » Fri Nov 18, 2005 8:50 am

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!

chinek · Post by **chinek** » Mon Nov 21, 2005 11:31 pm

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"..

myotoo · Post by **myotoo** » Thu Mar 09, 2006 9:32 pm

Jet,

In datastage administrator, command line delete statement can delete this category.

Regards,

Myo

ray.wurlod · Post by **ray.wurlod** » Fri Mar 10, 2006 6:31 am

It may also be that the index on CATEGORY is not up to date. You may try re-indexing the Repository.