DSXchange

Not sure where the 'date' came in, snuck out my fingers when typing 'range lookup' I guess, since that's the usual context for this. It be fixed now. I don't think a hashed file solution of the nature you posted will work for the OP, but seeing as how what they need is all still a little hazy... we ...

If you're not sure what to search for, try range lookup as an Exact search. I got 51 hits doing that.

So there's really nothing 'dynamic' about your question per se, you're just asking how to do a range lookup? If so, there are a ton of conversations here on doing that. Most deal with doing it via a hashed file or Universe table as it's not exactly straight-forward. If you mean a direct lookup again...

Who said anything about UNIX? It says 'command prompt', that's a generic expression for your operating system. I guess for Windows, working outside the GUI is becoming a lost art... Click on 'Start', then 'Run...'. In the Run box put cmd and click OK, that will get you a command prompt, a.k.a a DOS ...

Just how 'dynamic' is your query? The date range constraint part is easy, just pass the two dates in as Job Parameters and use them in your query. You'd need to add more detail to your requirement to get a more focused answer.

Correct - but it is, of course, also Spock's Brain. :D

No, you got it. Our own little game show.

You were supposed to 'type' the file, not try to execute it.

Brain and brain, what is brain?

Or the 'newer' Link Variable approach for the check:

For anyone playing along from the home audience, there's no underscore in any of these trigger values. It shouldn't even compile like that, so I'm sure everyone is using them properly but typing them incorrectly here. We now return you to your regularly scheduled problem. ps. swades - you need to t...

The Install and Upgrade Guide talks about rsh in the Configuring the Enterprise Edition chapter. And the Advanced User Guide for PX shows these environment variables, perhaps one of them is the one Ray meant:

APT_PM_SHOWRSH
APT_PM_USE_RSH_LOCALLY

Right, two lookups to the same hashed file. Check either or both results as appropriate.

I know you've got the smiley there, Whale, but it's not about processing power. Oracle used to play that game, called them 'Power Units', different CPUs or Server classes were assigned different amounts of Power Units and thus different amounts of money. Didn't go over well and didn't last all that ...

I_Server_Whale wrote:

DSguru2B wrote:vijaykumar, are you just playing with different stages

I guess so. And we will be going through all of them.

Oy!