Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Printing calculations without using any tables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Printing calculations without using any tables
 Login/Join
 
Silver Member
posted
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)
 
Posts: 42 | Registered: April 29, 2010Report This Post
Master
posted Hide Post
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
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Silver Member
posted Hide Post
Thanks! This is going to save me a huge headache.


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 42 | Registered: April 29, 2010Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Printing calculations without using any tables

Copyright © 1996-2020 Information Builders