Can I get the output to ? FILE filename into a variable? I'm need to find the last update time to be displayed on a report.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8
Windows, All Outputs
August 30, 2018, 12:24 PM
Tom Flynn
Hi Les, One possibility(I'm sure there are others):
Try APP QUERY and do a -READ or -READFILE on the HOLD:
APP QUERY ibisamp HOLD
-RUN
TABLEF FILE FOCAPPQ
PRINT *
WHERE FILENAME LIKE '%.foc';
ON TABLE HOLD FORMAT ALPHA
END
-RUN
?FF HOLD
-EXIT
Probably have to change the Date and Time formats...
This is a bit excessive, and uses a remote call to the loopback node of the reporting server, as well as the EMGSRV setting to route output to a file, but seems to work.
SET EMGSRV = FILE
-RUN
REMOTE DEST = LOOPBACK
-REMOTE BEGIN
? FILE CAR
-REMOTE END
-RUN
SET EMGSRV = ON
-RUN
EX -LINES * EDAPUT MASTER,EMGFILE,CV,FILE
FILENAME=EMGFILE, SUFFIX=FIX,$
SEGNAME=EMGFILE, $
FIELD=LINE ,ALIAS= ,A255 ,A255 ,$
EDAPUT*
-RUN
TABLE FILE EMGFILE
PRINT *
END
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 30, 2018, 06:49 PM
Les J
Sorry Waz, you did not win this time. Tom's was much simpler.