DSXchange

Yes! Absolutely no need for the if-then-else derivation, just let the expression naturally resolve to a boolean. :D

Post what you've tried so far.

Write out the steps they do to calculate the numbers from the log. Look into using dsjob to pull the relevant information from the job logs at the command line and scripting to get what you need from the output. That or a Server job or routine to code the same thing in BASIC using the DSGet* functio...

So... what are you supposed to do with the "non-distinct" occurances in the source data? Apply all in order, only use the first/last, pitch them?

And yet we seem to be talking about run-time limits here. They've alleged that the 'Abort after' setting on the Reject link is zero and (from what I recall) there would be a more explicit message is that is what triggered the abort. Seems like one warning was written to the log and that is what &quo...

Best to get help on stuff like that from whomever gave it to you seeing as how we don't know anything about your tables. Still, seems like a CASE statement could get you what you need.

:!: First thing you should always do is start your own post. I've done it for you this time by splitting the topics and changed your wording slightly to link to the post you decided to jump on the end of. I also added [/b] tags to preserve all of your lovely formatting, otherwise the forum software ...

First, let's get you in the correct forum - the one this started in was for discussions of FAQ topics (hence the name) not for problem solving. This one is for solving problems with PX jobs, an assumption I've made along with your version and O/S. Please let us know if any of the choices I've made a...

How about an answer for the second question.

What exact version of DataStage do you have? Are you current on patches / fixpacks? Checked with your official support provider to see if this is a known issue?

That's true, a loop will get you all jobs... but that may or may not fulfill the "whole project" requirement. Do you really need everything from a project or would all jobs work for you?

Are you asking if you can build generic jobs per module using something like the SCD stage, schema files and/or RCP rather than specific jobs per table? What does "I need only to append the data into ods" mean? To me that doesn't sound very type-2-like.

I don't but it might help those that do to be more specific about the nature of your struggles. Are you getting errors? Things not working as expected?

That and let's get you in the right forum.

:? Hmmm... could have sworn that was documented even back in the 7.x days, specifics on how you needed to write the SP to enable this to work correctly. Even for Oracle. Could be wrong and not in any position to check the latest docs myself. I'm sure someone else will be along and add their two cent...

It's set when you run the job, either using the Limit tab from the Director or via the -warn option if using dsjob. Are you sure your job is Aborting or does it show "Finished (see log)"?