DSXchange

Maybe someone has manually stopped the job at that stage.

SP2 ?

Did you try from SQL Plus from DS Server?

There are lots of way to achieve this. But why do you need this?

Can you provide
a.) The code of the routine
b.) The step by which you called it
c.) Values passed
d.) Value returned
e.) Reason what makes you think it is wrong

The req is in Win.

Docs are in ascl website and embedded in this forum.

Search is your friend.

I will suggest you to try little bit harder. Your question is very generic and it will be up to you to get the values and not ask others to provide them to you.

Did you try google or other website(s)?

Your logic appears to be defined to pick the least of the 2.

The result is therefore the least of the two.

Or simply put them in separate jobs to complicate it further and add them using sequencer.

Right(PadString("","0", length) : Trim(YourValue), length)

You can get that from Datastage export file.

Did you link the columns correctly? Did you try with a sample constant?

You can define the file to be of varying length to achieve this.

First, if they are so disparate, why do you need to merge / join / concatenate them?

Second, (as ArndW had asked) how do you wish to link them? Row by row or col by col?

Third, what if one row or col is removed from one of the files? Do you need to bother about it?