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     Accessing HOLD Files in Called Fex

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Accessing HOLD Files in Called Fex
 Login/Join
 
smiths
Platinum Member
posted
I have a fex (fex1) that generates several HOLD files (say H1 and H2). fex1 has a drilldown to another fex, fex2. How can I access the HOLD files H1 and H2 from fex2? I don't want to pass the data from the HOLD files in fex1 as parameters to fex2, nor do I want to regenerate the HOLD files in fex2. There must be an easy way to access the HOLD files generated in fex1 from fex2, but I don't know (or don't remember) how to do this.

Thanks!
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Sean,

Use APP HOLD FOLDERNAME in fex1.
FILEDEF H1 DISK FOLDERNAME\H1.ftm in fex2


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
smiths
Platinum Member
posted Hide Post
Thanks for the quick response Tom!

I will have many users running this code simultaneously, and their hold output will always be different. Is there a special FOLDERNAME (directory) that I could use to ensure no conflicts?

Thanks again.
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Sean,

I've done this many times, BUT, with SECURITY ON...

fex1:
APP HOLD FOLDERNAME
-RUN
-SET &USERX = GETUSER('A8');
-SET &FILE = &USERX || '1';

ON TABLE HOLD AS &FILE
END

fex2:
APP HOLD FOLDERNAME
-SET &USERX = GETUSER('A8');
-SET &FILEX = &USERX || '1.ftm';
-SET &DDNAME = &USERX || '1';


FILEDEF &DDNAME DISK FOLDERNAME\&FILEX
-RUN


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
smiths
Platinum Member
posted Hide Post
Ah OK, you create a separate directory per user.

When we execute an ON TABLE HOLD command, the HOLD file is magically stored uniquely per user somewhere (can anybody tell me where that is?), and I was hoping there is some way to mirror this same directory with the APP HOLD command that you have suggested.

Thanks,
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Sean,

We always create a folder for user data repository, i.e., DATAHOLD

then:
fex1:
APP HOLD DATAHOLD
-RUN
-SET &USERX = GETUSER('A8');
-SET &FILE = &USERX || '1';

ON TABLE HOLD AS &FILE
END

fex2:
APP HOLD DATAHOLD
-SET &USERX = GETUSER('A8');
-SET &FILEX = &USERX || '1.ftm';
-SET &DDNAME = &USERX || '1';


FILEDEF &DDNAME DISK DATAHOLD\&FILEX
-RUN

Not a separate directory, a UNIQUE HOLD file. At the end of fex2, DELETE/REMOVE the file

This message has been edited. Last edited by: Tom Flynn,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
smiths
Platinum Member
posted Hide Post
Tom,

Sorry, yes, that's what I meant to say!

Thanks again for all your assistance!

Can anyone help explain the default directory where the HOLD files are stored when APP HOLD is not used? And if/how I can simulate that directory with APP HOLD?

Thanks,
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Sean,

They are stored on VENUS, then erased at the end of execution, usually looks like, with ? PATH:

APPHOLD = /u01/iadmin/ibi/srv71/wfs/edatemp/ts000003:

It is a temp directory...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
smiths
Platinum Member
posted Hide Post
Tom,

OK, so I guess WebFOCUS handles this in the edatemp directory (based on the user's process id I guess), and we need to handle it in some way as you have suggested, such as creating a filename based on the user's userid.

Thanks!
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 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     Accessing HOLD Files in Called Fex

Copyright © 1996-2020 Information Builders