DSXchange

Is there a way of copying a load of parameters from one job to another? Personally, I would export the jobs as XML and copy and paste the appropriate sections, but my colleague is not entirely confident with that approach.

Quickest way is make a shared container somewhere in source job and copy it in target job.

PhilHibbs wrote:Is there a way of copying a load of parameters from one job to another? Personally, I would export the jobs as XML and copy and paste the appropriate sections, but my colleague is not entirely confident with that approach.

If you know how Datastage writes DSX files, you can copy and paste relavent sections and import as new job etc... Other wise your job will end-up with UV database with wrong entries and causes serious problem.

Sure, look at Parameter Manager offered by this forums owners, or even use the hack job I wrote at my website. There's lots of utilities available but not from Ascential.

kcbland wrote:...or even use the hack job I wrote at my website.

Where would I find this "hack job"?

PhilHibbs wrote:

kcbland wrote:...or even use the hack job I wrote at my website.

Where would I find this "hack job"?

You better consider parameter manager tool. As per Ascential, there is no plan to provide in next few releases that kind of functionality. Proabably you will have ROI.

In your source job, delete everything except the parameters and "Save As" "ParameterTemplate" or some other name of your choice.

Copy ParameterTemplate to TargetJobInitial.

Open both your target job and TargetJobInitial.

In your target job do a "Select All" and a "Copy".

In TargetJobInitial, do a "Paste" and save as you new target job. Or save, copy, rename, etc.

Not very sophisticated, but it works.

Larry

Maybe a simpler mechanism is to define your entire non-parameterised job as a shared container (as already mentioned above) and paste it into a copy of the parameterised job and un-construct the container.

At sites where I am the team leader, we use job templates as much as possible. Almost the first things set up are jobs containing the full set of standard parameters. Any job created from such a template can delete any parameters it does not actually require.

This method has the additional advantage that parameters are always defined in the same way using the same name, same prompt text, same type and same help text.

Parameter Manager for DataStage is also a good tool, particularly if you need to retrofit parameters into jobs.