I tried to delete all jobs including its container category. Somehow any delete or export can be easly interrupted and it gives an error message of lose the connection.
After it I can not delete category from DataStage designer. If I try to rename one of the subfolder in the main category what I tried to drop originaly it gets the name of the other subfolder.
I tried the above command from command line:
One category=Old_Jobs
Code: Select all
SELECT * FROM DS_JOBS WHERE CATEGORY LIKE ...Old_Jobs...
How can I delete them?
Any suggestion is welcome.
Best regards,
Janos