DSXchange

Sure, it isn't too difficult to make the job use multiple readers. Each 'reader' defines a sequential file stage then a transform to filter out unwanted records [i.e. use MOD(RowNum,#ofReaders)=0] then going to a link collector stage. But it would be surprising if the sequential file read were the a...

Ray - you've done the needful. Thanks.

There is no direct function to get quarter, but you could extract the month number, then take the truncated result of dividing by 4.

NAK is char 15, not char 21. I don't know where you picked up the 21 from.

Unless you intend on using the new EE functionality there is not much that needs to be done, the existing server jobs will run as they did before. EE might look similar to server, but it is a different product altogether and the first thing you should think of doing is enrolling in training. Many of...

You are trying to do too many things at once. Take a step back and debug step-by-step. Create a job with just the command stage and then use a routine activity calling UtilityMessageToLog to output your ExecCmd.$CommandOutput value. Is it what you expected? Is the first line actually the output you ...

Hello and welcome to DSXchange.

The transform stage will let you use the CHAR(15) function to generate this character.

In order to do the comparison an implicit conversion is done, after which the two values are identical.

"YYYY-MM-DD" is an invalid conversion code, use "D4-YMD" instead.

That means that one (or more) of your job activity command parameter values are of the incorrect type.

That is not the way it works; if the routine is successful then it will execute the after-job, otherwise it won't execute the after-job routine.

The correct variable to use is "@OUTROWNUM"

Yes, it can be done. But it involves writing some DS/BASIC code. It is simpler and safer to use the auto-purge settings to let DataStage do this work for you automatically.

Try outputting "ReadFile.$CommandOutput" to a message in the logfile in your job sequence to see the contents.

If you start a dssh session or go into the Administrator, what is the output when you issue the command "LIST &UFD& DSParams"?