DSXchange

Just to take it out of the equation... and to remove the possibility that they are being created by people logging into the server with an 'old' client and possibly causing the issue. Are people connecting to the Production project from their clients using something other than the 'single id' that i...

Oh, it's working - just not like you want it to. Ok, that was silly of me to fixate on your syntax instead of what I know works. And it wasn't until I built a teeny little test job that it dawned on me... $ReturnValue is always zero because the command runs without error. What your trigger needs to ...

vijaykumar wrote:i want to know what does 0 ROWS/SEC INDICATES.

It means they were all loaded in less than a second... or you loaded nothing.

Ok, have you looked at the output from your command when there are no zip files in that directory? I just built a small test and I get a number if files exist but if they don't I get two rows of output: $ ls *.zip |wc -l *.zip not found 0 You need to redirect stderr out to nowheres-ville so it doesn...

This is the post I was referring to above:

http://www.dsxchange.com/viewtopic.php?t=105955

Also, my sequencer has just 2 stages. First, an ExecuteCommand stage and then a Notification Activity stage. For a certain value, I want the flow to go to the Notification stage otherwise I just want the sequencer stage to end there. Do I have to have another stage for different values? No, just do...

Screen output from commands are returned in a dynamic array, so you'll get more than just the count returned. There just was a nice thread on all this, I'll have to see if I can dig it up. You need to check the first element of the returned value for zero, either that or filter out the @FM character...

Nice catch, Ernie. Odd as it looks, the XPath expressions go in the 'Description' field. Hopefully that simple change will solve all your problems!

Perhaps you should consider upgrading your Client to match the Server, no?

Post your "simple ls command".

Please don't post the same question in multiple forums. I've already responded to this in your General Forum post.

There really isn't a commond line option for scheduling a DataStage job. However, there *is* a command line option for running a DataStage job which can be be leveraged by your scheduler. What is your scheduler of choice, by the way? That option is dsjob and it is fully documented in the Command Lin...

Your XPath expressions don't match up to what it found in the file. Not sure how much plainer to say it. Don't forget that namespace plays a role here as well, but problems there would typically (but not always) generate errors during the run. You haven't given us any information that we can use to...

You don't want to catch every error, you want to avoid generating any errors. There's no reason on the planet for a Server job to ever generate any warnings. You should be checking for uniqueness before sending anything to your database and either turning that operation into an update or logically d...

And rather than checking the status for its numeric value, you are better off using the equated value. For example, instead of: JobActivity.$JobStatus = 1 Use: JobActivity.$JobStatus = DSJS.RUNOK Not only is it more 'future proof' but it also uses the meaning of the number (which is what you really ...