[SOLVED] Environmental Variables

July 10, 2018, 04:13 PM

We used to have a variable, displayable using either “-? &” or “-? &&”, which contains the environment, prod or dev, before we went to the latest 8202M. The question is: How do we get it back?

I can use &EXCELSERVURL even though it doesn't show up in “-? &”, it's available.

This message has been edited. Last edited by: Doug,

July 10, 2018, 06:29 PM

Hallway

quote:
either “-? &” or “-? &&”

Those still work in my 8202M environment. However, they seem incomplete. So I have created a fex to query the sysset master file.

  
TABLE FILE sysset
PRINT  
    SETVALTYPE
    SETMAXLEN AS 'Max,Length/,Value'
    SETFPROMPT AS 'From,PROMPT'
    SETFTAB AS 'From,TABLE'
    SETFPARMS AS 'From,PARAMS'
    VALUE AS 'Available,Values'
    VALDESC
    CURR_VALUE
    IS_DEFAULT
BY SETNAME
BY SETDESC
BY SERVDESC
WHERE SETNAME CONTAINS '&';
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY OFF
ON TABLE SET NODATA ''
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,$
TYPE=REPORT, LINES-PER-PAGE=UNLIMITED, $

ENDSTYLE
END

Although, this list still seems incomplete.

For example &DATEHHMIA is not included in that query, but if you have this code:

  
-TYPE &|DATEHHIA: &DATEHHIA

It will return the time of day in AM/PM format.

This message has been edited. Last edited by: Hallway,

July 11, 2018, 03:33 AM

Efrem

What's your GEN # of 8202M.

I tried it in an 8202M Gen that I have an it seems to work fine.

Detail:

CURRENTLY DEFINED & VARIABLES:
&&DB_INFILE = EXPAND_ALWAYS
&ECHO = ALL
&EXCELSERVURL = SET EXCELSERVURL=http://bigscmrh74.ibi.com:25100/ibi_apps
&FOCEXURL = /ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERV
&FOCHTMLURL = /ibi_apps/ibi_html/S74_15312605521F
&GOOGLEMAPSAP>=
&IBFS_OlapFil>= IBFS:/WFC/Repository/Efrem
&WFDESCRIBE = XMLPROMPT
&WF_TITLE = AdhocRequest
&ACCEPTS = 0
&APPROOT = /bigcfg/714/ibi/apps
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 07/11/18
&DBMSERR = 0
&DELTD = 0
&DMY = 110718
&DMYY = 11072018
&DUPLS = 0
&FOCFEXNAME = ADHOCRQ
&FOCFOCEXEC = _ADHOCRQ
&FOCGRAPHCNT = 0
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FORMAT = 0
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 071118
&MDYY = 07112018
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&SETFILE =
&SORTIO = 0
&TOD = 03.30.59
&TRANS = 0
&YMD = 180711
&YYMD = 20180711
&WFDESCRIBE = OFF
-? &
CURRENTLY DEFINED & VARIABLES:
&&DB_INFILE = EXPAND_ALWAYS
-? &&

July 12, 2018, 09:51 AM

Doug

Hallway: Thanks. Unfortunately it's not there.

Efram 8202m Gen 60 / 02272018

Thanks to both of you. &EXCELSERVURL shows "SET EXCELSERVURL=http://MyEnvironment:8080/ibi_apps" which I can use to determine 'where I am'.

July 13, 2018, 04:33 PM

Doug

There's at least two options.\

1) We can use "-SET &HOSTNAME=FGETENV(20,'COMPUTERNAME',20,A20);" with caution. That is, keep track of where it's used as WebFOCUS is moved to another server and the hostname changes?

2) The use of "&EXCELSERVURL" as mentioned earlier. But, that comes with the risk of it being blanked out to 'fix' some Excel issues.

July 28, 2018, 06:54 AM

Don Garland

-SET &HOSTNAME=FGETENV(20,'COMPUTERNAME',20,A20);" works in 8202 but not in 8009.