Re: Help with Effective Dated Lookup Table

[Krishnan Sarangarajan <ksaranga@RUAN.COM>]

Hi Doris!

> Does anyone know how to use the Load-lookup command to load data
> that is effective dated?

>From past experiences, I do remember be able to specify that I only want
rows that had say dates >= a date as requested from the ASK command.
Maybe, there is a way to use a hard-coded date but I am have never tried
this.

Of course, I ran the risk of picking up multiple rows if there was a
potential for them to exist.

> I want to be be able to load the all the earning code descriptions
into a
> lookup table, but I only want the current ones.

I know that I haven't quite answered what you were looking for but from
what I gather, one may not have a select query within the where clause
of the load-lookup statement.

> Any help would be appreciated.

I would recommend using an array for what you are wanting to achieve.
Referencing an array for this purpose has been a lot more efficient, in
Oracle, than using a load-lookup.

Hope it helps. Good luck.

Krishnan Sarangarajan
ksaranga@ruan.com
  Ruan Transportation
                3200 Ruan Center (DSM 6th Floor)
 Des Moines, IA  50309
[O] (515) 245-5655
[F] (515) 247-2065