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     Hold files in batch WebFocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Hold files in batch WebFocus
 Login/Join
 
Silver Member
posted
I am running reports using the IBATCH jcl that came with our WebFocus 715 installation. I noticed that whenever a report creates a hold file and uses that hold file for another TABLE FILE request, it fails because it cannot find the previous hold file that was created. The error was (FOC36219) AN ERROR OCCURED WHEN OPENING FILE: ATTPF2. When I run the same report in DevStudio, it runs fine.

It appears that when running in batch mode using the IBATCH jcl (which uses TSCOM300 -t), the hold file does not get saved, therefore it could not be referenced later on in the report.

Is there a switch or SET command that can be used to fix this, or does this mean that I have to DYNAMICALLY ALLOCATE each hold file so it can be referenced later on? I hope the answer would not be -- you cannot use hold files when running in batch mode.

Please help.

SOUCE CODE:
-----------
-SET &ECHO=ALL;
-RUN
TABLE FILE CAR
PRINT COUNTRY CAR MODEL RETAIL_COST
ON TABLE HOLD AS CARLIST
END
-RUN
TABLE FILE CARLIST
PRINT COUNTRY CAR
BY COUNTRY NOPRINT
END
-RUN

SYSOUT (using IBATCH jcl):
--------------------------
-RUN
TABLE FILE CAR
PRINT COUNTRY CAR MODEL RETAIL_COST
ON TABLE HOLD AS CARLIST
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 18 LINES= 18

0 ERROR AT OR NEAR LINE 6 IN PROCEDURE test_batch_hold
(FOC36219) AN ERROR OCCURED WHEN OPENING FILE: CARLIST
TABLE FILE CARLIST
PRINT COUNTRY CAR
BY COUNTRY NOPRINT
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: CARLIST
BYPASSING TO END OF COMMAND
>>

VIEW SOURCE (DevStudio):
------------------------
-RUN
TABLE FILE CAR
PRINT COUNTRY CAR MODEL RETAIL_COST
ON TABLE HOLD AS CARLIST
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 18 LINES= 18
TABLE FILE CARLIST
PRINT COUNTRY CAR
BY COUNTRY NOPRINT
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 18 LINES= 18


Thanks,
Ronnel C
WebFocus 7.1.5
IBM ZOS 1.6
 
Posts: 44 | Location: Fort Wayne, IN | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
Are you using an APP HOLD command?

When you are running it out of Dev Studio it is in a temp hold file.

APP HOLD SOMETHING


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Ronn, you can most certainly use interim hold files when running in batch.
Do please edit your profile signature to tell us your configuration,version, platform etc.
(Are you running on an as400?)
Your hold file is being held off your path somehow, as Prarie says. You can open a case and get a css rep to log in with you via Remote Assist and figure out whats up. But be assured, you can knock yourself out as creatively in batch as you can live. Wink




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
Silver Member
posted Hide Post
Sorry about that. I'm still new with this messaging board.

We are using WebFocus 715 on an IBM ZOS 1.6.
Our ReportCaster of course is in a Windows server, but the Report Server is in ZOS.

Thanks for the reply.


Thanks,
Ronnel C
WebFocus 7.1.5
IBM ZOS 1.6
 
Posts: 44 | Location: Fort Wayne, IN | Registered: February 07, 2007Report This Post
Silver Member
posted Hide Post
...in addition, our application paths are located in Unix HFS folders. Although a couple of them are mapped to mvs partition datasets.


Thanks,
Ronnel C
WebFocus 7.1.5
IBM ZOS 1.6
 
Posts: 44 | Location: Fort Wayne, IN | Registered: February 07, 2007Report 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     Hold files in batch WebFocus

Copyright © 1996-2020 Information Builders