DSXchange

cd $DSHOME
. ./dsenv
/bin/uv
Will get you to TCL prompt.

ArndW wrote:There is no need to do much if your original project was not broken. In your new server just add the project name and the existing path and DataStage will detect the existing project and keep the contents.

Sounds so simple I would try the next time.

I have another job as follows: SeqFile1 ---> RemoveDuplicates ----> SeqFile2 Here due to combinabiltiy mode, all the operator got combined into to single operator under APT_CombinedOperatorController, it may be a sequential read with unique option on the key to avoid duplicates, and piped to output...

Ray and Kumar_s, thank you for your response. I have a few follow up questions: 1)So are all files, sequential and datasets, converted to virtual datasets? 3)So eAny <> eCollectAny means: from Sequential TO Parallel AND from Auto Partitioning TO Auto Collecting? That doesn't make sense because the ...

Making it two jobs will give you more modularization as well. As mentioned earlier, you can avoid the Aggregator to make it bit more efficient. If you focus is all about performance tuning.

But its complains as such.
What is the datatype for the field REDEPLOY_EFF__DATE , TERMINATION_DATE and EFFECTIVE_DATE?

Hi welcome to Dsxchange :D !!!!
Are you sure that there is not change in the metadata?
Was there any migration of the file across servers?
IS the special character at the end of the lines?

There is no recommended straight forward method. Still the simple method I often follow is, create a new project. And delete all the content in side the project directory. Copy the Content of the existing directory to the new project directory. Now you can see the jobs in Designer and manager. But s...

Till the time Ray get back, you can post your query that you are using in the UV stage. You can explian bit more on you job desing.
Could you access your database by other means without any timeouts?

What is the intention at which Datastage jobs are required to be called from webservices?
Are they not going to be in Batch mode? Are they going to be used in Realtime? If so, in addition to Craig's suggestion, you can considerer RTI as a helpful candidate.

Inorder to avoid getting sinked in volcanic eruption, may be you need to get rid of the Datastage illusion created by Sauron.

Arnd is focusing on the partition method you have used. Improper partition method will give you wrong result.
To get a better picture, you can explain on what is expected and what is the actual outcome.

Yes, there could be several method to solve this. Do you mind sharing the method you have chosen. So that it can be useful for further searchers, somtimes you may bet better advise as well.
And you can mark the topic as resolved as well.

See Ray's reply here!!!!! I still dont know what is that page. Seems to be some kind of mail archival.

Is it by any chance, again a part of your Interview questions?