DSXchange

Thank you for the suggestions!

Finally figured out this dsx file creation process. Thank you all for the help and suggestions!

Thank you! That worked. So once we open the file using NotePad, do we simply do a 'replace all' for all parameter sets? Then conduct an import using DataStage?

OK, I'll ask. Can you share for us why you are looking into this? This is a specific request from the powers from up above. Ideally, we would only wish to adjust the parameter sets in a specific folder and leave the rest of the jobs as-is. If I am understanding correctly, this is NOT possible? Corr...

So the answers is the dsx file. A silly question - how do I obtain access to this file if I cannot logon to the DataStage server? Is the dsx file truly the only way to accomplish this?

We are interested in making all parameter sets display the actual values that are contained in them within DataStage. e.g. If we have 20 jobs with a parameter set $dsfasdfa.sdfasdf$ for the value of '2015', we want to be able to open any job and see 2015 instead of $dsfasdfa.sdfasdf$. Is it possible...

Can you give some more context? We were trying to connect to 2 different database servers. It appears as if that connection was in fact correct and possible. The issue was that depending on which host we used, the parameter sets values had changed, causing other tables to populate versus the expect...

Can shell scripts be created but then 'installed' and/or run on the server by someone else, an admin perhaps? Yes it can, but we do not have access to that person. Unfortunately, I think the sequencer is our only option. We are testing jobs right now to see if it will work. Thank you all for the fe...

So this is the latest:

We are unable to access the DataStage server. Therefore, shell scripting is not an option. I believe I have successfully created the sequencer.

I want to create an Input Stage from a different server and have it push data into the Output Stages for our DataStage job. e.g. Server 1: Table S1A Server 2: Table S2a, S2b, S2c So I would like to push data into S2a, S2b and S2c using data from S1A. When I login to the DataStage client, I only have...

Is it possible to connect to 2 different environments using DataStage? If so, how does one do this? When we launch the client, it asks us for the server we want to connect to. However, when we connect, I am not able to determine how to set an input stage to connect to a different DataStage server.

priyadarshikunal wrote:Have you ever tried editing dsx files?

Never, would not know how to even begin doing so. Would that adjust the files and all dependencies across the DataStage environment?

I'd look into scripting a loop around dsjob. I would go with the option Craig mentions. RunJobsBackEnd is a function inside shell script which will be execute at the backend A what? Novice here, novice. I am not familiar with running shell scripts or even creating them. Provided I have no idea on h...

chulett wrote:Is your ETL server truly on Windows

No it is not. It is actually UNIX/AIX, my mistake. How do I take advantage of the MKS Toolkit. All posts I am coming across are suggesting using a sequencer (or scheduler, which we would prefer not to use) for this.

chulett wrote:...scripting a loop around dsjob...

How do you do this? Novice here, step by step instructions would be ideal.