DSXchange

Search for the version of PXEReplace() posted here.

So... "deprecate" as in not even log them? I thought the message handlers were all about demoting them from one alert level to a lower one rather than saying "don't even bother to write these to the log".

Is there a sewtting some where so that datastage only logs warning and above entires? Not that I've ever seen, at least not generically. I'm curious though, what kind of "info" messages are you seeing? Perhaps there is some kind of a "logging level" property in the MQ stage that...

So there is no way i can use a Transformer stage or any other stage in my parallel job. I have to handle this issue in a schema definition file. And that would be because you are building a generic job that leverages RCP. We probably should have been able to ascertain that but it's always best to m...

...I still kept transaction size as 0 as I do not want to commit until all rows are inserted... Do you realize that this might fill up your rollback space and not necessarily increase speed? But can be very common. At one client we ran every job with a zero transaction size so the loads were 'all o...

ArndW wrote:you are using a server routine to delete datasets

I've been sitting here, wondering if that might be the culprit but wasn't really sure the why of it.

Here's a crazy thought... renew your membership.

Off you go to your own topic...

Looks like rolling up your own mechanism to parse them would be... painful. Can you get your hands on a JSON Parser? I would imagine it could be leveraged via an External Source stage and seems to me it would be the quickest / most reliable way to accomplish this task.

I've already moved it. This is the correct forum.

So... these JSON files? First thing I'd ask is what you need to do with them other than "read" them? Knowing what your goal / target is here will help us help you.

Done.

Guess you figured out the issue. Ah well, let us know if you need any other help with this.

Cameron, that's not a lot of information to work with. I could attempt to guess what you mean by "HASH CRC" but I'd rather not... can you explain what your job designs look like? Sounds like you may be using hashed files to do existence checks for insert v. update which should be perfectly...

wittyme wrote:changed the array size from 1 to 10000

That was the significant change.

Don't worry about Index(), the Field() function is there to do exactly what you need.