DSXchange

I would guess you could script something like that.

Why not just create another DataStage job to read the file and produce the 'report' you need?

ADN is dead and has been replaced by IBM's DeveloperWorks. Start here:

http://www-128.ibm.com/developerworks/

You'll need to register first, then you'll have access to what you are looking for.

What is the fourth paragraph in the first post?

(Dang, Wolfgang snuck in before me... that was for Guru)

Yup. And I personally haven't seen any need to delete one or the other when switching. The only thing that it tends to confuse or cause strange behaviour in that I've noticed is the person looking at the job.

It will still slow down... and it's all about Oracle. Are you doing pure inserts or one of those silly insert-else-update type actions? Have you had your DBAs monitor what is happening with regards to the target table while you are loading? Factors can be a number of things like the indexes on the t...

This is a volunteer site so there's nothing 'immediate' about what we do. People answer when they can... anything other than that needs to be redirected to your Support provider who are paid to provide that service and perhaps even supply immediate answers. That being said, I'm not sure what's so c...

loveojha2 wrote:Runtime Column Propagation, meaning it happens at the runtime only or...

Hence the name.

Ok... what about everything else? As noted, it can only return a single row when used as a lookup so you'll need to correct your query in order to make the message that brought you here go away.

No, it just means that you have to handle them rather than relying something else deciding what should be done. That's why each stage (except that darn email one) supports multiple output links and there are multiple trigger types!

Damn my slow fingers.

I gave you the names of two functions that will work for you. How about you take a second and check the Help available for them and work it out? That's how one learns... much better than if someone just hands you a solution on a silver platter.

Give it a shot, if you still have problems come back.

What stage are you using to do the reference lookup? As noted, when your query in the stage returns more than one record, only one will be returned. Some stages do this silently, some do it and log a warning as well. The solution is to rewrite the query so that it returns the singleton row you want ...

So... you want to remove an 'X' from the field in question? Anything more to it than that, like perhaps it needs to be the last character in the field?

If not, then a simple EReplace or Convert call to change it to an empty string (i.e. remove it) will do the trick.

Rather than continue the jokes - like it comes right after the ocard - perhaps you could let us know in what context you found this term... and how it relates to PX jobs. I don't recall seeing it mentioned so far in our forums.

my job sequence is doing exactly that, ie, job sequence 1 ----> Email Notification and job sequence 1 ---> job sequence 2 But once the email service is down, my job sequence will be aborted. Again, the email service being unavailable causes the Notification Activity stage to fail - not the Sequence...