Re: Is it possible in the Setup section, doing a load-lookup, to use an environment variable?

[John Milardovic <milardj@SX.COM>]

Sorry for the blank message.

Why don't you define the load-lookup and table name in the body of the
report?  You shouldn't have a problem then.

HTH
John Milardovic

> -----Original Message-----
> From: Ryan, Joseph A. [SMTP:jryan@JHANCOCK.COM]
> Sent: Thursday, October 07, 1999 8:41 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Is it possible in the Setup section, doing a load-lookup, to
> use an environment variable?
>
> Please, is it possible to use the getenv() function to get an environment
> variable for use in the Setup section during a load-lookup? I have tried
> many code variations without success. In the following code, I'm trying
> top
> make the "table=" statement in the load-lookup get the db name from an
> environment variable:
>
>
> Begin-Setup
>  Declare-Layout Default
>   Orientation = Portrait
>  ! Paper-Size = (8.5,10)
>   Top-Margin    = 0.50
>   Bottom-Margin = 0.50
>   Left-Margin   = 0.20
>   Right-Margin  = 0.20
>  End-Declare
>
> load-lookup
>         name=ItemStatus         !* Problem Status
>         table=arcd_n20..tcodedecode  <--------- !!!!!!!!!!!!!!! I want to
> use an env. variable here!
>         key=i_cd
>         return_value=decode
>         where='cat=354 and actv_ind=''Y'''
>
> I have tried using the getenv function right in that line, and also
> assigning a variable first. Please, if I were to assign a variable where
> would it go and what would it look like?
>
> Thank you to all who responded to my question yesterday regarding the
> environment variables!
>
> thank you