Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     date/timestamp in file name
Go
New
Search
Notify
Tools
Reply
  
date/timestamp in file name
 Login/Join
 
Member
posted
Hi,

I would like to include a date at the end of a file name. I have a weekly report (distributed via email) that will generate the same file name over again.

This is problematic as I would like to store the files in the same folder, but cannot if the names are not differentiated by a date.

I could manually put the date in every time I move the file to the shared drive, but I think there MUST be a way for reportcaster to do this for me.

I am using Webfocus Version: 7702
 
Posts: 5 | Registered: May 24, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
That would be a function within your FEX, not sure that RC has that ability. try to create the final file, appended with a date, within your fex.
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Do something like:
 
-SET &reportname = 'report' || &DATE;
TABLE FILE CAR
PRINT 
     CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE PCHOLD AS &reportname FORMAT EXL2K
END
 


Note that you may need to set your redirection settings and set save to yes for exl2k or whatever your format. &DATE is populated by default. to see other variables you can use, do:
 -? & 


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
We do something like this
/*
DEFINE FILE
HIDDEN_SORT/I9 = &YSTRDY0;
END
TABLE
PRINT
BY
HIDDEN_SORT NOPRINT
BY
BY
BY
ON TABLE PCHOLD FORMAT EXL2K
*/

Set the RC Schedule to BURST the report.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
There are some other options

- Report library, to save the file in several versions
- save the file direct in the folder without a mail.




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, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     date/timestamp in file name

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.