DSXchange

I don't know if case is still open but I had this kind of problem (It was SIGTERM error). Job stopped for huge reason in upsert with update only.

In fact, that was due to parallel update. I changed the OCi stage to sequential and the problem was solved.

We have a table with 270 columns and there were no problem to import using Orchestrate. For information, it is using Oracle. Maybe limits depends Oci.

Hi,

What's the 7.0 version type ? Server or Parallel ?
If you migrate from Server Jobs to Parallel Jobs, you will need to rewrite your whole jobs as it is not the same logic.

I don't think there is a lot of free documentation available related to because it is considering as consulting.

Otherwise you can create a technical field in your dataset which is different each time your job run and store this parameter in a technical table. Next before launching your job, you check if new records are present or not.

I just re-read your initial post and see that I misunderstood what you want to do. There are some DataStage functions that are available in the API, but those string and other functions you alluded to ... Thanks for the advice, but in fact, I don't want use BASIC Transformer bacause the routine hav...

I just re-read your initial post and see that I misunderstood what you want to do. There are some DataStage functions that are available in the API, but those string and other functions you alluded to ... Thanks for the advice, but in fact, I don't want use BASIC Transformer bacause the routine hav...

ArndW wrote:I just checked - the c++ function doesn't use any API calls, and the other object is a buildop which uses a whole different set of calls. ...

OK, so it seems there is no alternative way than to redevelop DS function equivalent in C++.

Anyway, thanks took some time to help me.

ArndW wrote:Once I get back to work I can get the list of include files and functions that you need ...

Thanks ArndW.

And I just implemented a c++ function in V8 today and it worked just as it has in the past. ... ok, so could you tell me what is the syntax to integrate in C++ script, the datastage functions because I use the NullToValue function for example and I got an error message from the compiler. `NullToVal...

Hi, I would like to know if one of you already used datastage built-in functions in C++ routine for DS PX v8 and if it is possible (or not) I have to migrate a routine from v7.5 Server to v8 PX and some function like Field, Trim, ... are used in the Server routine and to avoid to redevelop everythin...