DSXchange

Or maybe create your own dsjob shell script that calls dsjob with run and then with logsum.

Maybe I am joining in the middle and missed a few lines.

In that case, you can try the 'echo' command to confirm that all parameters are being passed correct.

Secondly you can provide a wrong file name and see whether you get any output.

Do you have the job that fails?

Can you run it again and confirm the results?

Can you connect to Oracle from DS Server via sqlplus with same parameters like those to STP?

Oh!!

From the question raised, I just took that the RCP is enabled until the stage level.

So I will go with kumar_s's answer.

Many Factors !!??

It is very easy to write within DataStage. But you need to make sure whether you expect any invalid values be present.

dsEdi,

What is the issue you are facing?

Why can't you convert output defn from Varchar to Char?

By doing this you do not have to include transformer to modify.

As you are using Server Edition, you can use IConv. Search for it.

If I am guessing correct, you are in Server edition on Unix.

By using different paritioning method, you are re-partitioning the data. So you are having the problem.

This is what others are explaining in different words.

It is not unusual.

What is the sequence logic you have given?

Search the forum. There are quite a few routines similar to your requirement.

Try using IConv.

(YourDate - FirstDateOfTheYear) / 7

You can deduce the first day of the week and adjust current week no.

Did you try %yyyy-%mm-%dd?

Maybe the "other application" is locking the table !!

You can achieve that by SQL itself.

What do you wish to accomplish after locating such situation is what you need to know to code in DS.

By-the-way, can you let others know the actions or initiatives you have taken to solve it. This will allow others to assist you where necessary.