DSXchange

You should pick better names than the default TRANS1 for the 1st transformer. What happens when you click the "more" button in the designer compile?

Please don't delete a job via that simple DELETE command. A job contains more entries in different files and also consists of additional hashed files that need to be deleted in order to keep the account clean.

Job should only be deleted via the graphical frontend.

Scott - I think the complexities of your site require a solution outside of the scope of what you can expect to get presented here. But you have the software tools available to craft your own solution. Either way, you will need to write code - be it a script or a batch/sequence job. The routines/cal...

In looking at the threads active since yesterday I found duplicate posts in many of them. Even though I login from different computers (i.e. different internet hosting companies) I still frequently get timeout messages while posting and just hit the back key twice and continue on since I know what i...

Gatelyes - looks like we said exactly the same thing; I just used more words.

I looked up cyberspace.com and it is a portal; not an application. If ssh is installed on your server, can you execute a "ssh" command from a cmd32 window? If that command works then your server is running and an ssh command to that server from a remote machine should work, given that the remote and...

Have you tried declaring a column called "Data" as an output of your join?

"Batch" is not a DataStage term and is open to many differing interpretations. I'll assume that you are using term as being synonymous with a DataStage Job Sequence which can then call other jobs. When you call jobs from a sequence you have the design time option of doing a "reset if required, then ...

You don't need a separate reject link; the lookup will return null values for the lookup columns or set a return variable (I cannot recall the name, but you can look that up) to determine if the lookup was successful or not.

Use the lookup stage to join the column, then use a transform stage in the same manne as before to perform your logic. The only difference is that in PX the lookup portion is done in another stage.

Can you TELNET to the DataStage server? If yes, then the connectivity is there and you need to set up SSH server and client. Which OS do you have and which SSH server are you using?

This doesn't depend upon DataStage but on your system configuration and how your firewalls are set up.

Your error is in the Job Control (last line of your post). What are you doing there? Is it a job Sequence or a server job?

To resurrect the thread - it seems that these double-posts are becoming more and more common. Perhaps a quick solution would be to increase the time-between-posts limit?

Anrewm - your problem hasn't been explained sufficiently. If you use telnet to your DataStage server is the performance acceptable? Do tracert and ping show anything out of the ordinary?