Delete CATEGORY in TableDefintions

poorna_76 · Post by **poorna_76** » Fri Aug 04, 2006 1:19 pm

Hi All,

From the DataStage Manager, I am trying to delete whole CATEGORY from TableDefintions (TableDefinitions\Sequential\txt), but i could not.

There were no TableDefinitions in that CATEGORY.

When i say DELETE, it does nothing.

what might be thereason?

If i want to do it from DataStage Administrator, how would i do that?

Thanks in Advance.

kcbland · Post by **kcbland** » Fri Aug 04, 2006 1:46 pm

All tables definitions are stored in a single internal file called DS_METADATA. Folders are logical, meaning it's just a column value and your Client session resolves all definitions into a categorized representation.

Either there's a definition with a category that somehow isn't showing, or you need to refresh your screen. If it doesn't go away, consider exporting your table definitions and inspecting that file looking for the errant row. Worse case, consider removing all definitions, then importing your export file and taking out the bad definition. I'm sure you're savvy enough to be able to understand the .dsx file contents.