DSXchange

Ray and I have both given an explanation of how the Filter command works. You can also check the online help by pressing the 'Help' button that's inside the Sequential File stage and reading what it says there. In a nutshell, it expects a command that - when applied against the file in the Filename ...

I don't believe there is any other way - period - other than reading the log as you are doing now. Maybe you could query and get your own counts based on timestamps, but who would want to do that? Yuck.

Yup! Double-check your setup, it does work just fine.

That is the way to do it and the technique has been discussed a number of times here, for example in this post. Have fun!

sravan wrote:actually the stage variables are limited to with in the stage only.

Hence the name... and exactly what Kim already said.

Why it is being shown that *** No output from command *** when file d is being created in specified dir? It just means that running your command did not output any additional lines to the screen. What happens when you run this from the command line yourself? It simply returns to the prompt without ...

My Rule Of Thumb is to use NOTFOUND only on hashed file lookups and the old school IsNull check for all other reference lookups.

Unfortunately, we're not a substitute for a training class. If you can't arrange that, spend some time with the documentation. The Server Job Developer's Guide in addition to the previously mentioned one are two good places to start. There's also a Tutorial that can be installed and worked through, ...

The Filter command is not meant to work that way. It is expecting the actual filter command to be sending output to Standard Out and it attempts to source from that. For concatenation, put what you have in the Filter command in a Before Job ExecSH call and leave the Filename in the Sequential stage ...

Welcome. Interesting first question... have you tried reading the documentation that comes with the product? The DataStage Designer Guide pdf has a complete chapter on Local and Shared Containers. Give that a go and after that, if you have specific questions or issues someone here would be glad to h...

Post your Filter command and what's in your Filename field.

Well... searching for 'vertical pivot' will lead one to the Pivot stage which won't solve their problem. Yes, it does turn 'columns into rows' but that not what the OP needs based on the posted example. This is a 'horizontal pivot' actually and you technically need 'rows to columns'. Search on that ...

I did the search on the square root part, this didn't show anything. Searching reveals four other posts going back over two years where people have seen this error message. They all seem to have something in common - XML on Sun Solaris. It was acknowledged as a bug by Ascential and supposedly on th...

And the whole concept of collaboration where multiple developers would "edit simultaneously" a single job and changes would be merged just doesn't fly in the house of DataStage.

The 'old' row counts are stored in the 'Finishing (...)' messages in the log. Double-click on them to see the details.