How to rename a category

Mark_E · Post by **Mark_E** » Mon May 16, 2005 9:15 am

Hi,
just a quick and hopefully easy question.

Does anyone know whether it is possible to rename a job category? I have tried looking in both Manager and Designer and have not been able to do so.

I do not really want to create a new category and then start saving the jobs from the incorrectly named category into the new (there are just too many of them), that seems to be the only real alternative right now.

Any advice would be much appreciated

ArndW · Post by **ArndW** » Mon May 16, 2005 9:19 am

Mark_E - well, the question is quick & easy. But the answer isn't what you wanted to hear

If your category name is quite unique then you could do an export, do a global replace in the .dsx file and re-import with the new name. That's what I did when I had a lot of jobs in a category.

Hopefully someone knows a way to do it easily from the Manager...

Luk · Post by **Luk** » Mon May 16, 2005 9:20 am

you can (in manager) create new category, select (ctrl+A) all jobs in old one and simple move them (using mouse) to a new category folder

Mark_E · Post by **Mark_E** » Mon May 16, 2005 9:30 am

Thanks guys, I have tried both and they have done exactly what was needed

ArndW · Post by **ArndW** » Mon May 16, 2005 9:43 am

Luk - thanks! I will now rename some of my categories... just because I can...

Luk · Post by **Luk** » Mon May 16, 2005 10:16 am

welcome ARND:)

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2005 6:19 pm

No-one suggested updating the CATEGORY column in the underlying Repository tables. This is good, people are learning to avoid hacking the Repository, whose structure is about to change radically.

kduke · Post by **kduke** » Mon May 16, 2005 8:14 pm

Hacking is fun. You hack too.

DEVESHASTHANA · Post by **DEVESHASTHANA** » Thu May 19, 2005 10:36 pm

Hi Ray ,

can u please tell what u are talking abt replacing Category name in Repository,

If there is any short cut to do category name change directly in repository,please share it,

Regards,

DevesH

kduke · Post by **kduke** » Fri May 20, 2005 7:22 am

You can do a SQL update to DS_JOBS and do the same thing. Ray does not want you to go around the product like that. It is a wise thing to not do these things or at least do them when you are the only one logged in.

chulett · Post by **chulett** » Fri May 20, 2005 7:24 am

Besides, why would you want to go around 'hacking' DataStage internals when all it takes is a moment or two to create a new Category and then move jobs into it via the Manager?

Use the GUI, Luke!

ray.wurlod · Post by **ray.wurlod** » Fri May 20, 2005 5:51 pm

The DataStage Repository is ALL GOING TO CHANGE in the very near future!

That's the main reason I'm backing off from advising people how to hack.

There is a secondary reason related to the fundamental interconnectedness of all things (in the DataStage Repository) - for example, to change a category correctly ought also to involved at least checking, if not rebuilding, the index on CATEGORY in the relevant table(s).

vinaymanchinila · Post by **vinaymanchinila** » Thu Jun 22, 2006 11:49 am

Hi,
I have selected all tehjobs in one category and when I try to drag them over to another category in the left panel , it doesnt look like they are transfarable, are there any options that need to be changed?

Thanks,

vinaymanchinila · Post by **vinaymanchinila** » Thu Jun 22, 2006 11:56 am

When switched between View-"Extended Job View" , it lets you move the jobs !

chulett · Post by **chulett** » Thu Jun 22, 2006 12:02 pm

In other words, if you have the 'Extended Job View' option enabled - turn it off.