DSXchange

Yes - Join stage, OCI stage, whatever. By the way, the Join stage is only in the PX/EE product - not the Server edition.

Me, I'd try to handle it on the database side. Not sure the particulars on DB2 (being an Oracle person) but you could create a reference table that contains all of your "quarter hour slots in a day". (or perhaps do something on the fly with the equivalent of a 'select from dual'?) Then simply do a u...

It was worth a shot.

I generally hesitate to tell people to edit the registry as many are not comfortable doing so, but glad it worked out for you. Don't forget to check any of your customizations as they more than likely got 'reset' as well.

Can't you string multiple commands together when you do ExecTCL, much like you can with ExecSH, semi-colons and UNIX commands? Would that help?

That's true... had to go check my scripts to verify that. Keep in mind the fact that you can have one "central" location for information like this. The file can contain multiple lines if you have multiple servers.

Why not do it 'before job' via a script?

Use the full pathname to the file.

Sure... kinda necessary, actually. Are you having a problem trying to do so?

Funny, that was the very post that I linked to above.

And Tony, you left off my little winky guy when you quoted me. I was kidding... mostly.

You might want to explain exactly what you mean by "different levels of user id and password" and then you'll stand a better chance of getting some useful advise.

Heck, I didn't know you could turn that off.

If a right-click up in your menu area doesn't give you the option to re-enable it, go with the "reinstall the client" idea. That should fix it for you, I would think.

I'm glad you were able to figure that one out on your own, Matt. Those kind of things can be difficult to solve 'remotely'.

And thanks for posting the solution. That helps the searchers who come later who have the same problem.

My ODBC look up has queries with <= and >= conditions in it.This condition is not possible in hash files. Strictly speaking, this isn't true. Yes, it's not an "out of the box" in the GUI kind of thing and you do have to do some work to achieve something like that, but it can be done. See this post ...

I was digging around in my Favorites to help on a different topic and stumbled across this post. The KBA version. Thought I would save you some searching. So there's three tips in one here: 1) The answer to your question. 2) The fact that with almost 35,000 posts here, most questions have been asked...

Well, then I guess the answer is to not do that.

Why not run your output to a local file and then copy/move it to a network resource as a seperate step after completion? Unless someone figures out why the hang and how to work around it, that is...