DSXchange

No. Forget about the rowsplitter, replace it with a Sequential File stage.

That's not what that stage is for. Use a transformer and split your name field in the derivation there - one field in, two fields out.

Yup.

Hence my follow-up.

*I* marked it as resolved as it was my issue... and my resolution was posted earlier.

Yes: Folder -> XML Input -> Sequential

Transformers between them if need be. Is there an issue you are having with the Folder stage?

You would need to write your own custom routine that preps and calls DSExecute, then run that.

Make sure you understand the 'value add' of the absolute value function that DS threw in at no charge, if you go that route. It means you'll never get a negative difference between dates, that may or may not be a good thing.

Convert them to internal format using IConv and subtract the results. Difference will be in days.

Good. Now for the last bit of paperwork before you toddle off to bed. Please mark the topic as 'Resolved'.

It's documented in either of the X Job Developer's Guide pdf manuals in the Command Line Interface section near the end. Or you can plow through it from the command line, issue 'dsjob' without any parameters and it will give you a normal usage statement.

Ok, more please. What operating system is your DataStage server installed on? That's what the "OS" question was asking. For that version it must be some flavor of UNIX, not Windows if you are working with Parallel jobs. You are asking about a parallel job, aren't you? ps. No need to quote the entire...

Replace "-wait" with "-jobstatus", don't add it. Not that it hurts, mind you, it's just that only one or the other is needed.

Left-most if you are in the Properties dialog box and by using the right mouse button, right-most in the Transformer itself by using the left mouse button. Regardless, the name column it is.

Add a transformer between the two stages, then use that name when you go to retrieve the rows processed. As a general rule, I never link two passive stages directly together. DataStage will add an 'invisible' one for you, why not make it visible and have full control? Besides, I've seen way too man...