DSXchange

I'm sorry, but you'll need to restate your question as it's not really obvious what you need help with. I can pull this piece out which seems to be the heart of the matter: is it required to refer to those table columns somewhere in the input or just the sql will take care of it However, still not ...

Curious if you've tested what happens when a checkpointed Sequence job with Loop stages fails and you restart it? I have, but only in a situation where the loop count wasn't really relevant - it did skip around and restart from the correct stage inside the loop. However, since my loop was controlled...

Its not possible. But you can set Userstatus of Job 2 in Job2 and access it in Job4. Already been answered, twice before this I think. Unless you have a Sequencer in between Job2 and Job4. Hmm.. not true. Well, except in one particular version from what I recall, and that was a bug that was since c...

From a private email: Thanks for your reply !! I am using Ascential Datastage scheduler, but I need to trigger scheduling of particuler job based output from an execution of other job. First off, private email is for exactly that - private conversations. This is the place to continue a conversation ...

... or just make sure your table names are correct.

Actually, it *is* performing aggregation functions. The problem is the fact that you are grouping on 'every input column' which sounds like it is making every record a separate group and so a singleton sum. You can't pass any 'extra' columns to the Aggregator, only the ones actually involved in the ...

What kind of help do you need? This isn't a DataStage transformation error, but rather a simple database issue that could happen with any tool. You've violated a Unique Constraint and a Primary Key one to boot going by the name of it. The constraint enforces the field or group of fields which uniqu...

Of course... I didn't mention any issue with the statements about any job being able to retrieve it, just the 'not job specific' part. Also understand that UserStatus isn't always available. If a job aborts and is reset, the User Status that may have been there is no longer accessable until it runs ...

Yes.

3. Is it possible to set $UserStatus of job#2 inside job#4 or in sequencer. I know how to set the user status of a job by using simple one line routine but not sure if there is way to set a other job's user status by sending job name or something like that. UserStatus is not jobspecific. You can se...

Perhaps you could explain why you think you need to "access DS_JOB and DS_OBJECTS of RETAIL project from FINANCE project"?

No, it's because the name of the hashed file is invalid and is confusing the mkdbfile command. Typically this is because the Job Parameter used in the stage is not defined in the job, so the #PARAMETER_NAME# is still there untranslated.

No, I don't believe so. The only 'resource' you would be constraining, one way or the other, would be the wetware portions.

Cool.

So, what's left?

In other words, you can't afterwards. You need to do a lookup against itself and check before sending to one output link or another, in essence capturing them during the run.