DSXchange

There should be no limit on password length. If you type in a server name like dsdev. This has to be resolved by your machine or your domain name server. If you go to cmd in DOS and ping your server to see what the ip is and do the same on the other machine then compare them. Also try to telnet to t...

Your default group should be dstage. Also it could be a network issue. Different domain servers.

I would use () to isolate the OR in the IF statement.

You can do a SQL update to DS_JOBS and do the same thing. Ray does not want you to go around the product like that. It is a wise thing to not do these things or at least do them when you are the only one logged in.

Check out this post http://www.dsxchange.com/viewtopic.php? ... Properties

Sri You need to pass the value back in an argument in the routine. It will give you a warning saying you are changing the value of an argument when you compile the routine but it is okay. So in the sequence you need to call this routine in a routine acivity. The parameter for the following job activ...

No. Not without adding it to the environment variables within the project. The jobs run as phantoms which mean they connect to DataStage separately from the process that started it.

You can call this routine in a job's transform.

This has been covered a lot so do a search. You need to search for exception handler and UtilityAbortToLog routine.

If you download EtlStats from my tips page then there is a job named DSJobReportDb which parses row counts from the XML file produced by the dsjob command. This might save you some time. The dsjob command can run without the XML and give you a simple report. It might be easier to parse.

Hacking is fun. You hack too.

What are the values of the shell variables?

Thanks.

The sort command needs a separator. It cannot use column names. There is a sort filter example on ADN. Download it and figure it out. Also there are lots of posts on this so search for them.

Srikanth

You could put the lookups in hash files and do 5 lookups. Hard code the key values to the column names. I would do this in a function. Initialize the stage variables with one read for each column. Then the lookups are only done once.