DSXchange

As noted, the short answer to your question is yes. If you are having a problem, please start a new post where we can discuss your particular issue.

Support, I would imagine. Not sure how many ABAP users are regular posters here.

So... in other words... you need to find the last day of the previous month?

Like I said, it's pretty straight-forward so I'm guessing that where you are looking for the file and where you are putting it may be two different places. I would make sure you have fully pathed the filename in the WFF stage, double-check that.

The WFF stage is pretty straight-forward. When you tell it to wait for a specific file it will 'fire' the success link once the file is found. Any failure link will fire if the file does not show up within the time you've told it to wait. Make sure you're not using a wildcard in the name of the file...

Did you do an exact search here for "Parallel job reports failure (code 139)"? There are 40 posts (not counting yours) that mention it, hopefully something in there in useful.

So... this question was posted again on another forum with a slight tweak to the requirements: If EndDate of the First Record is greater than the StartDate of Second Record, then reject the first record and capture it. I don't have any time left this morning but putting it out there in case someone ...

It is a pet peeve of mine, pushing one of my (sadly) many buttons.

:idea: Post your rules / requirements for this calculation in words first rather than make people puzzle it out from your example. Which right now really does need an explanation. :? If all you are talking about is a running total, then all you need is a stage variable in a transformer. If your last...

Seems to me the first question back to you is - did it work? I'm guessing the answer is no, especially with this little wrinkle in your requirements: If EndDate of the First Record is greater than the StartDate of Second Record, then reject both the records and capture it. The rub here is the need t...

I'm going to guess you have a metadata issue between the DB2 data and the flat file and they are being 'rejected' by the target stage. You might want to change the Reject Mode on it to something other than the default of 'Continue' and see if that helps shed some light.

Speaking of Ernie, thought I remembered a blog post of his on this or a very similar situation. Poked around and found this which looks like it might help.

Is this really a Server job question? All you've posted in the past has been for Parallel, hence the question.

Thanks for posting your resolution!

So... very new to DataStage, how about XML? Is that something you are familiar with or are you very new to that as well? And you really should have the xsd for this, it is used to generate the metadata needed to produce the output XML. Lastly, will this really be a Server job as marked? I'd also be ...