DSXchange

I'd be curious what 'house keeping' you are worried about. And if you really were worried about hashed files, they can be easily purged automagically - heck, you could even make that the trailing end of your job stream if you so desired.

Well, there you go. Golden. :D

I try.

Wasn't sure... it was more of a "just in case" kind of thing. Or maybe like where you'd put a NSFW tag on a posting in other venues.

I can see why. It's pretty... lame.

Interesting. For the curious but easily offended, be aware of this subtitle:

"Crazy math s**t to freak you out, and swear words to hold your attention"

Without the stars, of course.

Or post your XPath expressions and indicate which you've marked as the key.

You should check with your DBA or IBM Support to be sure. Or just try, not like you'd hurt anything. We all know that a 32 bit implentation of DataStage requires a 32 bit client but I don't know if you can use that to connect to a 64 bit instance. I've used a full 64bit environment with no issues, s...

If you've search the forums, then you should know the first piece of advice you're going to get - Reset (not recompile) the job after it aborts and let us know if a 'From previous run...' message appears in the log. If it does, paste it here. Also paste the original error or any phantoms you get. An...

I don't believe there's a macro that will get you the format you need.

Assuming your datatype is Timestamp in the job and DATE in the database, there are a ton of posts here on how to do this. A Search should turn them up.

In my mind, the question would be - does a version of the MCM ship with the 8.x client? You won't be able to use the 'old' one but if the capability still exists with 8, then it would ship with the 8 product.

Fields 'move' in a hashed file when your metadata isn't identical across uses. Meaning, if you create the hashed file with two keys and three data fields then your lookup will need the same two keys and three data elements - and they must be declared in the same order. Now, as with most rules, there...

Actually, it does work, just not in the way you are (apparently) expecting. So the generic answer to your generic question would still be 'yes'. I've asked twice now and you've yet to say exactly what your expectations are. Or why you would want to turn the 'Automatically handle' option off. If you ...

That's my understanding, hence my answer. We shall see.

That wasn't the question.

Didn't necessarily mean just a new job, but a 'non-upgraded' (i.e. clean) install. [shrug] In any case, let us know how your saga turns out.