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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Is OUTFILE limited in FILEDEF?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Is OUTFILE limited in FILEDEF?
 Login/Join
 
Expert
posted
Summary: Are there any know limits (in particular: 8.3) to the use of "OUTFILE" in a FILEDEF commnad?

Does anyone know of any limitations on OUTFILE when used in a FILEDEF command, such as this:
FILEDEF OUTFILE DISK myappfolder/yyyymmdd_WSS_RPT_??????.txt
Note that the first 8 characters (yyyymmdd) are not going to be unique when "?????" is different for each of 99999 report generations for a given date. Or is OUTFILE a key or reserved word?

What I have found is that, when using OUTFILE, the only "yyyymmdd_WSS_RPT_??????.txt" file out there is the one from the last execution which issued the FILEDEF command. It seems as though it checks the 8.3 part of the FILEDEF'd name and over-writes it.

If anyone has come across this, then they know what this is all about, If not, it may seem a bit confusing ~ in which case I can, if need be, elaborate a bit more.

Thanks In Advance for your input,
Doug

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Can you give us some sample code ?

What OS is it on, I assume Windows.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
Doug,

try this:

-SET &x = 1;
-REPEAT :endloop 3 TIMES
-SET &ver = &x | '.txt';
APP HOLD saved_reports
APP FI outfile DISK saved_reports/outfile_20120119_&ver
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE HOLD AS outfile
END
-RUN
-SET &x = &x + 1;
-:endloop

I have'nt tried it with more than 5 iterations but in theory it should'nt make any difference.

Cheers
Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Expert
posted Hide Post
Waz: Your assumption is correct: Windows.
Håkan: My isse is not with the number of FILEDEF commands issued. It is the length of the final filename. In my case "rsyyyymmdd_WSS_RPT_??????.txt" is 25 characters long. But, it seems to have an issue because the 1st 8 characters are not unique. And in seeing it as 8 characters, it seems that it is always overwriting the previous file with the latest one. So, it seems that is checks the 1st 8 then write the full name to that file.

I did redo this as follows:
FILEDEF rsyyyymmdd_WSS_RPT_?????? DISK myappfolder/rsyyyymmdd_WSS_RPT_??????.txt
This worked as I expected, i.e: files rsyyyymmdd_WSS_RPT_000001.txt to rsyyyymmdd_WSS_RPT_001000.txt were created. With that in mind, I'm leaning towards an imposed limit associated with OUTFILE...

This message has been edited. Last edited by: Doug,
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Doug, I don't know of any limitation in Windows to a filename length.

OUTFILE is nothing more than a DDNAME, just like JCL.

You cannot, imo, have multiple dots in a filename or Windows will not know how to open it...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
Thanhks Tom,
quote:
You cannot, imo, have multiple dots in a filename
Sorry, do I have multiple dots someplace? The question marks indicate placehold for the example only. There are no question marks in the actual code.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Well, at the top you stated 8.3. Obviously, I misinterprated that, and, that was the reason for my statement...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
NP.. that was just a reference to the good ol (original) DOS filename sizes...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Does this happen for one file, no iterations.

Just a simple filedef and hold ?

If so, can you post the code.


Could there be some sort of OS setting that is causing it ?

This message has been edited. Last edited by: Waz,


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Perhaps it's a habit from my mainframe days, but I always avoid beginning file names with a number. You might try using a letter(s) as the first character(s) of the file names.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Guru
posted Hide Post
Doug

can't test it for the moment, but I would say, leave the logical name short and then just issue an APP FI logical_name DISK physical_name. There might be a limitation when it comes to the logical name, but as far as I know, the name of the physical file is just limited by the operating system. Besides, why do you want duplicate Master files, when you can use one only. You can even create a static Master file and SAVE/SAVEB the data file.

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Expert
posted Hide Post
quote:
I did redo this as follows:
FILEDEF rsyyyymmdd_WSS_RPT_?????? DISK myappfolder/rsyyyymmdd_WSS_RPT_??????.txt
This worked as I expected, i.e: files rsyyyymmdd_WSS_RPT_000001.txt to rsyyyymmdd_WSS_RPT_001000.txt were created. With that in mind, I'm leaning towards an imposed limit associated with OUTFILE...


If you have multiple procedures using OUTFILE as a DDNAME, just clear it at the end:

FILEDEF OUTFILE CLEAR
-RUN


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
quote:
FILEDEF OUTFILE CLEAR
-RUN
I had a
quote:
FILEDEF CLEAR
-RUN
in there. It seems that I left out the ddname. wouldn't "FILEDEF CLEAR" clear all FILEDEFs? Confused
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Nope...

Do a ? FILEDEF after FILEDEF CLEAR and the OUTFILE DDNAME will still be there.

BTW, the suggestion "just clear it at the end" was at the end of "every" procedure, BUT,
I know, that, you know, that was what I meant...

From the manual:
  
Syntax: How to Clear a Logical Name With Syntax

  FILEDEF ddname CLEAR

where:

ddname
     Is the logical name. It may contain one to eight alphanumeric characters.

CLEAR
     Clears the specified ddname.


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
Thanks for the refresher on this... Gotta tell FILEDEF what to CLEAR, as in: "FILEDEF ddname CLEAR".
... End Of Line ...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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     [CLOSED] Is OUTFILE limited in FILEDEF?

Copyright © 1996-2020 Information Builders