DSXchange

you are not allone with that problem. Are you loosing data? I suppose it is only a warning and has no data loss implications.

Give us a sample what you want to do and where you see the problem!

(K)lasse is a guess what the "K" in your name stands for. Am I wrong? Beside DataStage Jobs you can also develop DataStage Sequences. This might be a solultion for your problem. An other a bit old fashion is to work with dsjob on your server, there you can nourish the parameters by job sta...

Hi Rafik from 2nd (k)lasse,

you cannot load or change parameters after your job is started. That you will learn in future in 3rd (k)lasse.

What you can do is:

Write a sequence

Why don't you separate the update stream and the insert stream into two separate streams.

That might give you also a performance boost beside the other tipps.

do you have an index on the table.

Why do you use only on field in Oracle and not many.

What do you means in such a kind of scenario by "Update"

which ora-Stage do you use (OCI or Bulk)?

this is a very standard problem (normalize/denormalize) which is relativly easily to be solved.

Let me know if you don't find a solution by searching in this forum.

Thank you Ray for the answer, even though I am not able to read the complete answer nor to set this question on resolved.

try to check for any Null-values Ascii-value '000'. change them to space Ascii-value '032' or something else.

DOS-Line-Termination is CR and LF (CR=Cursor Return CHAR(13), LF=Line Feed CHAR(10). UNIX-Line-Termination is only LF Important is to write and read with the same kind of termination. If you mix them up you get an error. (to much colums). You can use both kinds of termination in both worlds without ...

When having a Routine and a Transform with the same Name and number of parameters in a Job-Derivation, the Transform wins.

Is there a way to force the Derivation to call the Routine?

you have still more typing errors. The word is written "through" and not "thru"!

tell you friend to never go to an DataStage Stage interview before a one week-DS-training and a three-week-DS-experience.

DS is a like a Ferrari. It is a good car but without training you kill it.

I had such phenomens also years ago. I suceeded in switching the "where"-Part to then end.