DSXchange

Welcome! That's what happens when you do the 'DS.REINDEX ALL' and don't have exclusive access to the project in question and I do mean exclusive as in nothing running and no-one connected. If you are unsure how to arrange that, do it immediately after stopping & starting DataStage and warn peopl...

Jayanto, all you need to do is post your question in the appropriate forum and someone will help you as soon as they can. No need for personal emails on top of that.

First thing that came to mind was cliff diving. Where have you heard this in an ETL context?

Have you done anything with dsjob before? You just need one -param name/value pair to pass the filename into the job from the command line.

Looks like you're losing way more than just the project indexes, so I doubt that rebuilding them would actually fix things for you.

They're not asking why it aborted, but rather how to get it to pick up from where it left off when it is restarted. Unfortunately, checkpoints have nothing to do with this, that only affects Sequence jobs and job activites there.

And the answer is - only if you code it in.

Well... not sure how much help anyone here can be. If it's happening frequently, seems you have either a rogue person or a rogue process. Does 'frequently' also mean 'regularly' as in on any kind of a schedule? Do you have any scripts or routines running on the server that try to automatically clean...

OK... let's see if we can turn that frown upside-down. From the error it seems you are using the Stored Procedure stage for this. What is your exact job design? Have you used this stage in the past in this manner and you have had success before this (meaning, the problem is specific to this job) or ...

Finally, The sequential fine having any delimiter ( space, comma, pipe ), it is working fine. That just seems... odd to me and not any kind of behaviour I recall seeing in the past. I would have said the same thing Ray did. :? So can I treat this is a bug in data stage V8.1 version. Do I need to as...

That's good information, thanks for sharing. Have you reported this to IBM?

Then I used col1 as the only hash key and the col2 was sorted in descending order and also col2 was removed as a partitioning key. In this scenario it worked..and I got desired output, but why this behaviour Well, because it was the right thing to do? :wink: You partition on the grouping key(s) to ...

Not sure how simple it would be to query the repository to find them directly. Since there is an option to include them in the export, one could always include them and then compare the two results. Not fun but do-able.

So... what's your actual question? :? Without knowing how your routine runs jobs, it's hard to provide specific advice. It seems like you know you just include the Invocation ID with a 'dot' after the job name when launching it. How exactly does 'GetJobsToRun' work? Seems to me the best approach wou...

As noted, use a BASIC Transformer in your PX job to leverage that transform.

Well yes, IBM owns both products but what I meant was whomever your support is contracted out to. It may be direct with IBM or may be via a third party, you'd need to check with your company if you're not sure.