DSXchange

No, you can't - and I was wondering if that was why the question was being asked. Note that you use the UV stage, not the Universe stage, over the hashed file for this.

I'm also wondering if this is a "before job" issue, something being run there that is taking "more and more time" to complete. This can appear to people as the job taking a long time to start if they're not reading the logs correctly or are unaware of its presence. Of course, tha...

I have no previous XML experience That's going to be your biggest issue right now, unfortunately. Is there anyone you work with, even if they don't know DataStage, with XML experience you can have help you? Hope you understand these forums are not really here for teaching XML but rather answering s...

Every stage other than OCI uses a ? for the bind variable and they are positional, meaning the first one binds to the first column, etc. This is modified by keys v. non-keys i.e. fields in v. out of the where clause. Therefor you cannot send the same field in more than once but rather need to repeat...

I'd suggest first creating the lookup as a strict equi-join and letting it generate the sql needed. Then take that and modify it to add in the range logic.

That would really be a question for IBM, but I would think one would cover both - but don't take my word for it, go back to the source to be sure.

vasubabu wrote:In xmlinput stage i have selected the option as XMLDocument.

But seeing as how you're not sending in the contents of the document but rather just the path to it, you need to set that to "URL/File path" instead.

Hopefully you saw the words total load and recognize it means everything running there, not just DataStage, yes? And is this an issue with all jobs, or just one particular job? Unclear from your post.

These kind of internal repository issues, especially now with 8.x and the complications it adds, need to go back to your official support provider for resolution.

It would help others if you posted the actual resolution here rather than just marking this resolved. Thanks.

Perhaps we can approach this from another angle. Rather than saying "convert X to spaces" - what are you expecting the output to be? In other words, what are you expecting to be left after this for your target?

You'll be fine, but I'd suggest you actually create your KeyMgtGetCurrentValue routine (from the non-concurrent 'next value' version) just from the standpoint of it being more obvious what is going on.

Welcome. :D Please verify exactly what it is you mean by a 'binary file'. Sometimes people have asked this question for packed fields in an EBCDIC file, for instance, so let's make sure we're all on the same page before we go too much further. And the more details you can provide about what you need...

Yah, yah... not notice Mr Winky?

I'm sure I answered that recently in a different thread. Too busy to search for it at the moment. Solution involved use of Job1 user status area. http://www.dsxchange.com/viewtopic.php?t=126249 Also suggest you search the forums for "setuserstatus" a function that helps with leveraging th...