DSXchange

Or that.

Emphasis on significantly.

Not aware of any way to accomplish getting this information automatically added to the job's log. What stage are you using?

So, you need to merge any number of XML files rather than specifically three? And your error is coming from the ESS stage or the XML stage? You will be processing those XML files individually so I don't see how any kind of a 'merge' is possible without a more complex job design. Seems to me you'd ne...

OSD?

Anyway, perhaps this post might help.

Oracle 9? Why am I not surprised.

I only meant that Oracle supported FLOAT as it uses it internally for things like an unbound NUMBER field, not that you wouldn't have any issues with it. Such is the nature of floating point, I'm afraid. I avoid it as much as humanly possible.

But it was successful and there were no error. I'm assuming you forgot to add "however, it doesn't do what it was supposed to do" yes? :wink: Don't worry about the userid yet. First suggestion - don't make any assumptions about the environment the script will run in. When you run it from ...

Again, those are questions for your official support provider.

Sounds like the project is corrupted, have you involved your official support provider yet?

Or as you said, if some of these steps don't really need an ETL tool to perform them and can be converted to a shell script, that would be well worth your time in my book.

Open a PMR. They should be able to help guide you to a solution.

Wow... I think that's the first time I've heard of float actually solving a problem rather than causing it. And yes, Oracle can handle it just fine.

Do an exact search here for "ParamValue/Limitvalue is not appropriate", you'll see what the problem is as you're not the first person to encounter it.

Over the time these jobs get called quite a number of times. I can seen that the jobs have more than 2000 instances. No wonder you have log issues with them, did you mention that fact to IBM yet? Perhaps you meant 2000 total over all jobs but let's start with 2000 for one particular job. You do und...

Don't you actually need it like so?