DSXchange

Ummm... yes. And I'd prefer you explained completely rather than briefly, briefly is just extending the pain. :? You keep using the word "select" - is there a database involved in this derivation somewhere? Are you needing to pull information from a table using SQL or is this just a simple...

FYI, the 2 duplicate post are not intentional, not sure how it happened. Can admin clean it up? Probably... unfortunately, it can be a common problem here. :idea: I always check after I post if there's any "delay" in the submit process just in case. I double-check because you can delete y...

I don't believe there is one. What does the data in your lnk.RECORD field look like? Something the StringToDecimal() function can't handle?

That's the problem, we don't know what the "it" is you are trying to do, what "issue" it is you are trying to solve. About I all see if you are trying to build a string of dynamic SQL, which by itself is a pretty trivial undertaking but after that... ?? How about you explain what...

I'm curious how you are planning on executing your 'select statement in a Transformer stage'.

I don't like to advertise my blog... except in my signature in every post.

That's OK, Ernie, we like you to advertise your blog, there's good stuffs in there.

And by "you might try" he means from inside a job, before job using ExecSH for example. Not manually from the command line. FYI

I don't personally have any hands on experience with WTX but did evaluate Mercator a number of years ago so I've seen "it" or at least a version of "it". From what I've understood its strengths to be, from hanging out here and from osmotic knowledge trawling the internets, none o...

This is quite an interesting way to handle this case and it is also pretty complex. As noted, though, it's a "one time complex" in my experience. After that, not so much. :wink: Like all things, there's more than one way to skin a cat, good to see you found something that worked for you. ...

More-so Ernie, of course.

I've done this in the past and it works great. Now, it does take a little bit of dedicated time to check it out and fully grok... err, understand it, then get it setup on your system but once you do it's cake to re-use and works as advertised. Nice, speedy range lookups of any kind. I'm sure there a...

How about we all stop for a second and get an explanation of the details of your job design. What exactly is your External Source doing? How exactly are both the ES and XML Input stages configured?

If you haven't downloaded and read this... do so. A little old but still a great reference.

I've seen several such examples going back many years. Granted it was with Server jobs but it manifested itself the same - completely bogus errors when using the MJC utility that compiled just fine individually because there was no problem with the job, just the utility. There were a couple of speci...

No, there's nothing "native" for this. So, however you would do this from your DataStage server without using DataStage is exactly the same way as you would need DataStage to do it for you.