Re: Load Lookup

[Pragya Chandra <pchandra@FASTENAL.COM>]

yes, you CAN have a concatenated key

> -----Original Message-----
> From: the dragon [SMTP:ceprn@HOTMAIL.COM]
> Sent: Wednesday, May 10, 2000 2:46 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Load Lookup
>
> sanjay,
>
> I am not certain what you are trying to do here, but load lookup tables
> only
> have 2 columns - the key value and the return value...
> return value can be concatenated, but I don't recall if you can have a
> concatenated key or not...
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
> ----Original Message Follows----
>
> Hi Guys,
>
> I have load lookup defined as below. It works fine if I have to get a
> return_value of single column, But if I have more than one column it
> errors
> out.
>
> Any suggestions for improvement
>
> LOAD LOOKUP CODE
>
> LET $LOAD_WHERE = 'ET.EFFDT <='
> LET $LOAD_WHERE = $LOAD_WHERE ||''''|| $AsOfDate || '''' ||' AND
>                                ET.EFFDT  = (SELECT MAX(EFFDT)
>                                               FROM  PS_EARNINGS_TBL'
>                                              || ' WHERE  ERNCD  = ET.ERNCD
>                                                AND  EFFDT <= '
> LET $LOAD_WHERE = $LOAD_WHERE ||''''|| $AsOfDate || ''')'
>
> load-lookup name=EAR_NAME
>              rows=500
>              table='PS_EARNINGS_TBL ET'
>              key=ET.ERNCD
>              return_value=ET.DESCR
>              where=$LOAD_where
>
>
> ERROR MESSAGES ********
>
> (SQR 1303) Error in SQL (perhaps missing &name after expression):
> select distinct ET.ERNCD, ET.DESCR ,ET.DESCRSHORT from PS_EARNINGS_TBL ET
> where ET.EFFDT <='2000-04-30' AND ET.EFFDT  = (SELECT MAX(EFFDT) FROM
> PS_EARNINGS_TBL WHERE  ERNCD  = ET.ERNCD AND  EFFDT <= '2000-04-30') (SQR
> 1304) Check SELECT columns, expressions and 'where' clause for syntax.
>
> SQR: Program Aborting.
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com