DSXchange

I am tring to import a stored procedure definition, but the DNS name is not showing in the drop down box. Anyone know where the config file is located to add the new DNS names?

After the two sequential files process I want to update a tracking file in oracle and create a header and trailer record... I though it would be cleaner if I could add wait function to the transform, instead of having the next steps be an output from the sequential files.

This might seem like a simple question but I have a Transform with 3 outputs... 2 sequential files and 1 database file. I want to have the database file execute after all the data has been moved into the sequential files, is there a contraint I can use that only activates the database link after the...

Manually changing over a 1000 jobs and subjobs is not the way I want to go... I agree with Kim doing it in Manager is easier. Also you can do that using designer....Or another way is to right click the job in designer and select the properties. Inside that you can go to Category tab and type your ne...

We are trying to clean up our datastage env, currently there are over 1000 jobs and we are looking to mass change all the jobs. If we create a new structure tree anyone know a way of moving the objects without having to re-compile them. Our though was to change the Category tag in each job, has anyo...

You have to open the file in something else, we use a control batch job and the code looks like : OpenSeq "G:\DataStage\DStage_Data\ACSPROD1_Control.txt" To INLINE Then ReadSeq DataLine from INLINE Then Server = Trim(DataLine) End CloseSeq INLINE End Call DSLogInfo("AS400 Control: &qu...

I am looking into extracting data from FDR, using ODS which my company just set up. Does anyone know where I can find information on how to do this. I believe that they are using MQ Series and sending a XML request in one connection and then waiting on another connection for the data but I am still ...

Thanks, I'll take a look into those options

Can you connect to a Lotas Notes Database and extract data? If you can how?

The only problem is I dont think this can connect to a secured shell, I am going to try to use openssh. At least this is what our unix admin told me.

I installed the product to my computer to test it, and it placed an icon on my PC... I can run shell commands when I use the executable that it installed but how do I run them from the dos command line?

Where can I download cygwin and find the documentation for it? Is there a way to do it with Native DS? without installing any other products?

DS is running on Windows, can't use rsh right????

We are running Oracle 9i on a Solaris 8 box and I was wondering if there is anyway to execute a shell script that is on that remote box?

I am trying to add a new Data Stage developer and went to the server to add them to a user group. I wanted to add them to a existing group called DataStage Developers, but when I do they can't log into designer or any of the other applications. The only way that I can make it so she can logon is if ...