I'm using the Import/Export utility in BAT to change the partition on a large number of route patterns, but instead of just updating the existing route patterns, it's duplicating them. I understand there may not be a unique ID for route patterns, and because same route patterns in different partition are an acceptable configuration, the system does not complain. But is there a way to avoid adding the partition, and instead just udate the partition field only? Thanx!
I'm not a programmer, looked into AXL, seems great, but not something I can pickup in next day or so. Is there a guide that explains how to use it for my specific purpose that you can reference? Any guides or info on the matter would be greatly appreciated, thanx.
If AXL is not looking like an option for you, you could try SQL on the CLI of the Publisher.
In this example, we're updating all 600X patterns in the Old-PT partition, to be in the New-PT partition.
run sql update numplan set fkroutepartition = (select pkid from routepartition where name = 'New-PT') where fkroutepartition = (select pkid from routepartition where name = 'Old-PT') and dnorpattern matches '600[0-9]'