Focal Point
[SOLVED] Printing parameters

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3137055476

February 03, 2015, 12:27 AM
MrM
[SOLVED] Printing parameters
Hi

Is there away to print parameters. I like to make a logging file.

example :

TABLE FILE CAR
PRINT COUNTRY
CAR
&FOCFEXNAME
&YYMD
END

This message has been edited. Last edited by: <Kathryn Henning>,
February 03, 2015, 01:45 AM
Pravin.Singh
Hi,

The question is not much clear. If you want to print the parameter while debugging, use -TYPE &FOCFEXNAME.

Thanks,
Pravin Singh


WebFOCUS 7703
Windows, All Outputs
pravinsinghwebfocus.blogspot.com
February 03, 2015, 02:17 AM
MrM
Hi,

Thanks for your reply.

I want to save a file with global parameters such as &YYMD &TOD &FOCFEXNAME. Then I can use this file to report how often applications are been used.

Thanks,
Mark
February 03, 2015, 03:47 AM
Pravin.Singh
Ok.. I got it now.

Try the following code:
APP HOLD baseapp
TABLE FILE CAR
PRINT COUNTRY
CAR
COMPUTE FEX_NAM/A50= '&FOCFEXNAME.EVAL';
COMPUTE LOG_DATE/YYMD= '&YYMD.EVAL';
ON TABLE HOLD AS HOLD_LOG FORMAT FOCUS
END


You can specify the folder where you want to store the Master file and the focus files. Please note while holding, you should give format focus.

Focus file HOLD_LOG.foc and master file HOLD_LOG.mas will be created in baseapp app which you can use for reporting.

Thanks,
Pravin Singh


WebFOCUS 7703
Windows, All Outputs
pravinsinghwebfocus.blogspot.com
February 03, 2015, 03:55 AM
Ram Prasad E
Check if you have license and enable Resource Analyzer. It captures more than this and stores in RDBMS tables. Either you can use WF provided reports, or create your own by hitting RDBMS tables.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
February 03, 2015, 04:25 AM
MrM
Hi,

Most grateful, thanks for the solution and suggestion.

Mark
February 03, 2015, 05:42 AM
Twanette
Hi Mark,
There are a number of posts related to the "logging" of usage stats on this forum with a variety of possible solutions e.g.

IBI - Reports hits counting


WebFOCUS 8.2.06 mostly Windows Server
February 03, 2015, 10:54 AM
George Patton
Your report will run as you have typed it.
However you might get something closer to what you want by putting the parameters in a heading or footing.

And I guess it depends on what you want to log. Do you want the log to contain actual data - as you have in your example - or do you want it to be a log of the transactions that make up your data ?


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
February 03, 2015, 11:25 AM
Doug
Please consider FILFEDEF ... APPEND... as well as the above.