DSXchange

Do those other jobs have parallel Transformer stages? This error can occur if you have an incomatible C++ compiler, or the compiler can not be found. Jobs that don't need C++ (don't have Transformer or BuildOp) can still compile (= generate osh) and run happily.

That looks like a JD Edwards date and, if so, the first digit is significant; it's a century designator. So be very careful before arbitrarily discarding it.

Look at the second event in the job log to see whether they are there. Verify (APT_PM_SHOW_PIDS) that 2086 is indeed the job sequence. Check that these environment variables are recorded in the DSParams file in the project directory on the server. As a workaround, set them explicitly in the dsenv sc...

A regular browser ought to do it.

There isn't one out of the box - we would ordinarily recommend using COALESCE in your extraction SQL.
Otherwise build the requisite nested IF or your own custom routine or BuildOp.

Two characters at a time can be done simply in a server routine with a loop. Be sure to handle exceptions, such as argument not assigned, argument not null, argument contains odd number of digits, argument does not contain decimal numbers. You can invoke the server routine from any expression in you...

eze_ke wrote:Hey guys no one has suggestions nor has come accross like this

please Suggest

This is not a premium support site. Folks post as and when they can. Don't push. If you want urgent answers, sign up for premium service with your support provider, and learn the true cost of urgent.

Reject link from which stage is causing the problem?
Do you have a warning limit set?

Because most of the trace tools require adminstrator privilege.

Good catch. I'd forgotten that one!

You should probably use code page 1256 at least for this column, if not for the entire project.

It may be preferable to bring the data to something local using DB2 Connect (perhaps via DB2 stage). Then you can use ODBC or UV stage to perform lookups locally and still use the multi-row return capability - it will be much faster than trying to do it over a network and, in bringing the data to th...

Please post in appropriate forum.

Your Informix database was created "with no logging". Therefore it will not accept COMMIT statements sent by DataStage.

None at all, it's just letting you know what it found (in case you want to buy another 16 CPUs licensing from IBM!)

Hi kduke, Most of this stuff is freely given but don't try to pawn it off as your own work. Someone will figure it out. Besides none of us have all the answers. I still learn something everyday. please dont misunderstand me, my company paid to these jobs and they brought these information from IBM ...