Focal Point
Printing calculations without using any tables

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

September 06, 2013, 05:03 PM
Josh K
Printing calculations without using any tables
Is it possible to print some calculations without using any tables?

Say I have some code like this. Can I create a report just to print these values? That way I can test some calculations based on current date without involving any tables yet.

-SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ;
-SET &SAVEDATE=EDIT(&WORKDATE,'99999999$');
-SET &TIME8A = 'A2345678' ;
-SET &TIME8A = HHMMSS(&TIME8A) ;
-SET &TIMEBGN = &TIME8A ;
-SET &TIME6A = EDIT(&TIME8A,'99$99$99$');
-SET &SAVEDTTM= &SAVEDATE || '_' || &TIME6A;
-SET &SAVPATH = 'D:\file_' ;
-SET &HISTNAME = &SAVPATH || &SAVEDTTM || '.XLS' ;
END
-RUN



WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
September 06, 2013, 05:08 PM
eric.woerle
Josh,

If all you want to do is see the & output then I would use the -TYPE command. like this:
-TYPE WORKDATE --> &WORKDATE
-TYPE SAVEDATE --> &SAVEDATE
-TYPE TIME8A   --> &TIME8A
-TYPE TIMEBGN  --> &TIMEBGN
-TYPE SAVEDTTM --> &SAVEDTTM
-TYPE SAVPATH  --> &SAVPATH
-TYPE HISTNAME --> &HISTNAME  



Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
September 06, 2013, 05:44 PM
Josh K
Thanks! This is going to save me a huge headache.


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
September 08, 2013, 05:11 AM
FrankDutch
If you start with

-SET &ECHO=ON;
You can see what you get

And the END command is here useless .




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7