Exporting selected containers from a project?
Posted: Mon May 18, 2009 1:16 am
Hi,
Actual problem statement:
I need to do a QC check on our DEV project before migrating to TST. In particular, I need to know which jobs have hard coded physical paths or database connection strings (eg. db instance, username, password). All of these job parameters should be "$PROJDEF". Our business process only allows migration via Datastage Version Control, not export/import of a DSX file.
Related problem statement:
So my quick and dirty approach is to export the project to a DSX file, search on BEGIN DSSUBRECORD, note the jobs with hard coded parameters, and fix them in the Designer UI.
However, we have HUNDREDS of development jobs in the project. We've moved them all to their own (sub)containers.
It would be nice to exclude them from the export, i.e export all jobs in containers FOO, BAR, and BLAH, but exclude jobs in container TESTING.
So, is this possible? It doesn't appear so from the DataStage Manager Export UI.
[Note: so I opened the full DSX file in TextPad, and started searching on BEGIN DSSUBRECORD. This will be way too painful for the actual problem definition. So, if anyone has written a job or script, or can at least suggest a better approach, that would be great.]
Regards,
Scott
Actual problem statement:
I need to do a QC check on our DEV project before migrating to TST. In particular, I need to know which jobs have hard coded physical paths or database connection strings (eg. db instance, username, password). All of these job parameters should be "$PROJDEF". Our business process only allows migration via Datastage Version Control, not export/import of a DSX file.
Related problem statement:
So my quick and dirty approach is to export the project to a DSX file, search on BEGIN DSSUBRECORD, note the jobs with hard coded parameters, and fix them in the Designer UI.
However, we have HUNDREDS of development jobs in the project. We've moved them all to their own (sub)containers.
It would be nice to exclude them from the export, i.e export all jobs in containers FOO, BAR, and BLAH, but exclude jobs in container TESTING.
So, is this possible? It doesn't appear so from the DataStage Manager Export UI.
[Note: so I opened the full DSX file in TextPad, and started searching on BEGIN DSSUBRECORD. This will be way too painful for the actual problem definition. So, if anyone has written a job or script, or can at least suggest a better approach, that would be great.]
Regards,
Scott