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.
Just want to know how you can avoid the message "The system cannot find the file specified" when you go into WebFOCUS, change directory from the default:- D:\ibi\srv81\wfs\edatemp\ts00001 To : D:\DEV\daltoni\temp (say) Then do a report that creates an OFFLINE.FTM file and attempt to copy it as follows:-
-SET &ECHO=ALL; -RUN DIR -RUN
CD / -RUN CD D:\daltoni\temp -RUN
DIR -RUN
OFFLINE TABLE FILE CAR PRINT CAR END OFFLINE CLOSE -RUN
COPY OFFLINE.FTM D:\daltoni\temp -RUN -EXIT
How do you revert to the original D:\ibi\srv81\edatemp\ts00001 directory ?
By the way here's the echo output…… -RUN DIR -RUN Volume in drive D has no label. Volume Serial Number is 00D6-BFDC Directory of D:\ibi\srv81\wfs\edatemp\ts000001 16/04/2019 16:28 . 16/04/2019 16:28 .. 16/04/2019 16:27 0 stderr.log 16/04/2019 16:27 0 stdout.log 16/04/2019 16:28 0 sysh_4960.tmp 3 File(s) 0 bytes 2 Dir(s) 70,688,927,744 bytes free CD / -RUN D:\ CD D:\DEV\daltoni\temp -RUN D:\DEV\daltoni\temp DIR -RUN Volume in drive D has no label. Volume Serial Number is 00D6-BFDC Directory of D:\DEV\daltoni\temp 16/04/2019 16:10 . 16/04/2019 16:10 .. 0 File(s) 0 bytes 2 Dir(s) 70,688,927,744 bytes free SET TEMPERASE=OFF OFFLINE TABLE FILE CAR PRINT CAR END OFFLINE CLOSE -RUN 0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10 0 OFFLINE... COPY OFFLINE.FTM D:\DEV\daltoni\temp <== this copy statement expects OFFLINE.FTM to be in D:\DEV\daltoni\temp -RUN The system cannot find the file specified. <== the file is actually in D:\ibi\srv81\wfs\edatemp\ts000001 -EXITThis message has been edited. Last edited by: FP Mod Chuck,
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
The reason I need to do this is that one of our older applications uses OFFLINE, followed by a report, then OFFLINE CLOSE followed by a COPY of the OFFLINE.FTM file to somewhere safe. The OFFLINE.FTM file is held temporarily in \ibi\srv81\wfs\edatemp\ts00001 (or similar). If however you introduce DOS CD statements to alter the current directory prior to running the report to something else, the OFLINE.FTM file still goes to the \ibi\srv81\wfs\edatemp\ts00001 directory, but the COPY statement fails because the the new active directory has been changed. It also points to the new directory for the duration of the session. I hope this explains things.
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
As mentioned to you, using OFFLINE is archaic (most recent members will probably say "what?") and should now be changed to use more "modern" forms of coding.
Try using ON TABLE HOLD AS …… FORMAT …. to use direct control over your output. Even using FILEDEF as required.
Continuing to use OFFLINE will only lead to issues later "down the line".
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004