Deletion of Project does not remove all entries

bala_135 · Post by **bala_135** » Mon Dec 15, 2008 5:10 am

Hi All,

I am trying to extract the metadata of all the projects by using the following command.
1.dssh "SELECT SCHEMA_NAME,@ID,PATH,OWNER FROM UV_SCHEMA WHERE SCHEMA_NAME <>'CATALOG';" > ./file1

I am doing the following test case:What happens on deletion of a project.While testing,I found that the project entries are not completely deleted.

I deleted the project through the datastage Administrator client.
I tried the following

DELETE FROM UV.ACCOUNT WHERE @ID = 'project'
but still I am getting the project entries.
Any ways I can delete the entire project entires.

Thanks in advance.
Awaiting your results.

Regards,
Bala.

chulett · Post by **chulett** » Mon Dec 15, 2008 8:12 am

You didn't "delete the project", all you've managed to do is corrupt it.Always always always delete from the GUI not from "under the covers". Here, that would mean the Delete button when logged in as the admin to the Adminstrator client.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 15, 2008 3:05 pm

What Craig said is correct. Reinstate the UV.ACCOUNT record and delete using the GUI. There are too many interconnected components to try to re-invent that particular wheel.