DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Tue Jul 16, 2013 3:19 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have made a copy of the USPREP rule set because we want to modify it for a project (i.e. we don't want to make these changes to the original USPREP rule set). The new rule set is named by the copy process to "CopyOfUSPREP" I want to rename it to something more indicative of the project - something like USPREP_ENROLL. I've successfully copied and renamed other types of rule sets before but when I attempt to rename this USPREP set I get a message indicating that I cannot rename it. In fact, long ago I was able to rename a USPREP rule set, now I can't. Can anyone help me to rename the rule set?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Tue Jul 16, 2013 6:40 pm Reply with quote    Back to top    

You should be able to right click on CopyOfUSPREP and rename it.

Make sure you are not trying to rename USPREP.

If you can't rename the folder, try renaming the SET file.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Tue Jul 16, 2013 6:42 pm Reply with quote    Back to top    

You should be able to right click on CopyOfUSPREP and rename it.

Make sure you are not trying to rename USPREP.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 518
Location: Melbourne
Points: 3853

Post Posted: Tue Jul 16, 2013 7:03 pm Reply with quote    Back to top    

I haven't tried this in a while and it might have been fixed in 9.1, but if you give your ruleset a name greater than 8 characters, you'll find you can test it just fine, but can't use it in a job.
Rate this response:  
Not yet rated
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Wed Jul 17, 2013 7:42 am Reply with quote    Back to top    

Thanks guys!

but it's still a problem.

Ray,
It is when I right click on CopyOfUSPREP and attempt to rename it that this error message occurs. It does not let me rename it.

Stuart,
I need to use this CopyOfUSPREP in a job.

Any other ideas on how to rename it?
Rate this response:  
Not yet rated
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 518
Location: Melbourne
Points: 3853

Post Posted: Wed Jul 17, 2013 9:19 am Reply with quote    Back to top    

One way would be to export to DSX and then:

- Change USPREP to the name you want. You'll need to do it for each of the files in the ruleset called USPREP.*, and remember under the .SET file entry it has a list of the files. So they will need to be changed there too.
- Change the folder path away from the standard rulesets
- Set the ReadOnly property to 0 for each of the files
- Presumably you want control over the .TBL files too, so change the names of them and make sure to update the references to them in the .PAT file and also in that file list under the .SET file entry.

Then reimport the DSX.
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Wed Jul 17, 2013 9:44 am Reply with quote    Back to top    

Hi all,

The trick is to make sure the renamed rule set ENDS in USPREP.

CopyofUSPREP to USPREP_XX will not work. You get the following error message: 'Cannot change a PREP Rule Set to a non-PREP Rule Set and visa versa.'

CopyofUSPrep to XX_USPREP WILL work. QualityStage 'knows' it is a PREP rule set because it ends in PREP....

_________________
Regards,
Robert
Rate this response:  
Not yet rated
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Wed Jul 17, 2013 10:08 am Reply with quote    Back to top    

Robert!

You got it! That worked just great for me!

It's unusual that that restriction does not apply to USNAME, USADDR, etc. but it does to USPREP.

Thanks!
Rate this response:  
Not yet rated
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Wed Jul 17, 2013 10:10 am Reply with quote    Back to top    

Robert!

You got it! That worked just great for me!

It's unusual that that restriction does not apply to USNAME, USADDR, etc. but it does to USPREP.

Thanks!
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Wed Jul 17, 2013 10:12 am Reply with quote    Back to top    

Great!

Yes, it is a bit 'unusual'.... Laughing

Also (for the record), the XXNAME rule sets will have a similar issue in that the drop-down for 'Process All As Individual', 'Process All as Organization', etc will only appear if the rule set ends in NAME

_________________
Regards,
Robert
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Wed Jul 17, 2013 4:34 pm Reply with quote    Back to top    

Good to know - should someone initiate a documentation enhancement request?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Thu Jul 18, 2013 7:39 am Reply with quote    Back to top    

I believe there is one, but another one would not hurt...

_________________
Regards,
Robert
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours