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     [Resolved]Problem Creating HOLD File

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Resolved]Problem Creating HOLD File
 Login/Join
 
DJ
Member
posted
I have searched Focal Point for my answer, but cannot seem to find a solution to my specific problem so I am going to ask for help...

I have the following simple code:

APP HOLD BASEAPP
DYNAM ALLOC FILE TEMPHLD1 DS 'WEBFOCUS.APP.BASEAPP.TEMPHLD1.FOCUS' NEW REUSE
TABLE FILE CAR
PRINT COUNTRY
CAR
ON TABLE HOLD AS 'TEMPHLD1' FORMAT FOCUS
END


While I am getting the file allocated, the master data is not being generated for use by other procedures. What am I missing? Thanks.

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


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
 
Posts: 18 | Registered: April 13, 2009Report This Post
susannah
Expert
posted Hide Post
take the quotes away from the hold file name
you're on mainframe, i'm guessing? Is that why you're using DYNAM ALLOC ?
Your signature says you're on Windows.
If you're on windows, forget the DYNAM business
APP HOLD BASEAPP
USE
BASEAPP/TEMPHLD1.FOC NEW
END
TABLE FILE ....
ON TABLE HOLD AS TEMPHOLD1 FORMAT FOCUS
END
APP HOLD
-*
now go look in your baseapp

Go read one of the basic set of 4 manuals, DESCRIBING DATA ...that's going to help you get a handle on FILEDEF (for non focus files), USE (for focus files)



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
DJ
Member
posted Hide Post
Yes, sorry, I am on a mainframe (and I changed my profile) so I will need the DYNAM ALLOC.

I tried:

APP HOLD BASEAPP
USE
DYNAM ALLOC FILE TEMPHLD1 DS 'WEBFOCUS.APP.BASEAPP.TEMPHLD1.FOCUS' NEW REUSE
END
TABLE FILE CAR
PRINT COUNTRY
CAR
ON TABLE HOLD AS TEMPHLD1 FORMAT FOCUS
END
APP HOLD


and I got an error:

(FOC082) INCOMPLETE OR INCORRECT FOCUS FILE NAME IN 'USE' COMMAND: ALLOC

So I took out the USE and reran it. No errors that time, but still no master file for TEMPHLD1.


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
 
Posts: 18 | Registered: April 13, 2009Report This Post
<JG>
posted
Insert a -RUN after the APP command.

The problem is that it is not being executed and applied before the file and master is generated for it disappears withe the end of the connection.

I would also put one after the DYNAM
 
Report This Post
Danny-SRL
Virtuoso
posted Hide Post
DJ,

The USE command maps a FOCUS file to a MASTER with a different name and not to allocate. So, don't enclose the DYNAM command between USE and END.

The MASTER for TEMPHLD1 is by default written to a temporary file.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
DJ
Member
posted Hide Post
Still no metadata being created for the file. I get the file without a problem. Might there be an admin setting that has to be addressed? Has this turned into a technical support question? Frowner

Here is the last bit of code I ran:

APP HOLD BASEAPP
-RUN
DYNAM ALLOC FILE TEMPHLD1 DS 'WEBFOCUS.APP.BASEAPP.TEMPHLD1.FOCUS' NEW REUSE
-RUN
TABLE FILE CAR
PRINT COUNTRY
CAR
ON TABLE HOLD AS TEMPHLD1 FORMAT FOCUS
END
-RUN
APP HOLD


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
 
Posts: 18 | Registered: April 13, 2009Report This Post
Tom Flynn
Expert
posted Hide Post
For the Mainframe, all ON TABLE HOLD AS WHATEVER masters are held in a pds under the DDNAME HOLDMAST.
This may/may not be a temporary dataset.

If you want keep it permanently, allocate HOLDMAST to a permanent PDS and they will be routed there...

HTH

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
DJ
Member
posted Hide Post
Thank you susannah, JG, Danny-SRL and Tom! Your input made my day. For reference (in case someone else ever has this problem), here is the code that finally performed as I expected:

APP ENABLE
APP HOLD BASEAPP
-RUN
DYNAM ALLOC FILE TEMPHLD1 DS 'WEBFOCUS.APP.BASEAPP.TEMPHLD1.FOCUS' NEW REUSE
DYNAM ALLOC DD HOLDMAST DA 'WEBFOCUS.APP.BASEAPP.MASTER.DATA' SHR REUSE
-RUN
TABLE FILE CAR
PRINT COUNTRY
CAR
ON TABLE HOLD AS TEMPHLD1 FORMAT FOCUS
END
-RUN
APP HOLD


Thank you all for your help. Cool


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
 
Posts: 18 | Registered: April 13, 2009Report 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     [Resolved]Problem Creating HOLD File

Copyright © 1996-2020 Information Builders