DSXchange

Rajeev -- I see that you are very new at this. May I suggest that you contact Ascential (or your sales dude that sold you DataStage PX) for beginning training information, which mostly would help you understand how to use PX? This is a very cost-effective solution to get you up to speed in a minimal...

Several ways. 1. You can use the Open Command/Close Command. Click on "Options" within the Oracle stage and you'll see those options available. 2. Do a Before Job & After Job routines using sqlplus calls. 3. Use ExecuteCommand in the job sequencer to make sqlplus calls. (This is RECOMM...

JulianDate is the variable you need to pass.

Use MyDate there.

Normally umask are not set. But maybe it will actually work if you declare umask there, overriding what root have?

This would be a good compenstation for having root do 775 chmod all the time.

Can you elaborate a bit further on what you're seeing that is causing it to fail? Do you see any logs that says this? If so, please paste what the log says. You can also run JobMonApp in debug mode to trace the problem. (Don't forget to turn it off after you're done debugging, they create a HUGE log...

Have you ever develop in any programming languages before you are using DataStage? If not, I would suggest that you learn one, so you can have a better understanding on passing parameters, and other functions. DataStage is a programming language that is best understood by developers who have experie...

Please note that the term "key" within the lookup stage is not referring to the row's key indicator. It is referring to the LOOKUP's MATCHING key. You may have the following: Name, Address, Age. You may want to lookup Age, and have specific value translated to another value, such as "...

Do a search on this forum for "unlock jobs"

Due to changes to how Datasets are built, Datasets are not readable between 7.1 (and earlier versions) and 7.5.

*sigh* I wish I could help you further, but I am afraid that any further suggestions would be talking out of my butt. It sounds like a remote shell (RSH) privs issue. But I do not know exactly how QualityStage 'deploy' everything (I thought it was SFTP at first, but was wrong on that...) I'll poke a...

Make sure your JobMonApp process is running.

viewtopic.php?t=85983&highlight=jobmonapp

Thanks for your responses. It sounds that if we go for enterprise edition, that we will have to assume that we are starting from scratch and allow time accordingly. Not necessarily. You could still run Server jobs. Just do a phased switch -- focus on certain jobs that are not performing to your pre...

Not in EE's jobs. But there may be a routine or two that you can invoke. Either do a search for "Routines get invocation" or bug Kim Duke for his highly skilled service (within your price range.)

Excellent. Thanks for letting us know.

Your server may be overloaded. Your network may be overloaded. Your mounted drives may be overloaded/nearly full. You may not have enough memory. You may not have enough/slow swap space. Contact your system administrator and discuss with them about improving Sun's C++ compiler's performance. There a...