[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Is it possible in the Setup section, doing a load-lookup, to use an environment variable?
- Subject: Is it possible in the Setup section, doing a load-lookup, to use an environment variable?
- From: "Ryan, Joseph A." <jryan@JHANCOCK.COM>
- Date: Thu, 7 Oct 1999 08:40:54 -0400
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