Re: Help with Effective Dated Lookup Table

["Van, Lily" <Lily.Van@TRANSAMERICA.COM>]

Hi Doris,

If you have on-line SQR help, it'll give you more detail.

load-lookup
name=DEPARTMENT
rows=50
table=DEPARTMENT_TBL
key=DEPTID
return_value=DEPTNAME
where=' A.EFFDT =  (SELECT MAX(EFFDT) FROM PS_DEPARTMENT_TBL
        WHERE A.SETID = SETID
          AND A.DEPTID = DEPTID
          AND EFFDT <= SYSDATE)'

I just gave you the syntax.  The rest you have to fill in whatever fit
your needs.  Hope this helps.

Lily

> -----Original Message-----
> From: Doris K. Brinson [SMTP:DBrinson@COMMHOSPINDY.ORG]
> Sent: Wednesday, September 30, 1998 9:18 AM
> To:   Discussion of SQR,              SQRIBE Technologies's database r
> Cc:   Van, Lily
> Subject:      Help with Effective Dated Lookup Table
>
> Does anyone know how to use the Load-lookup command to load data
> that is effective dated?  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.
>
> Any help would be appreciated.
>
> Doris.