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     MVS Batch use of -HTMLFORM

Read-Only Read-Only Topic
Go
Search
Notify
Tools
MVS Batch use of -HTMLFORM
 Login/Join
 
Rich Dickeson
Member
posted
I want to run some batch WebFOCUS using -HTMLFORM BEGIN and END. As background I have encountered a situation where IE 6 times out at 5 minutes and I have a WebFOCUS query that allows the use to enter a date range that could as for a YTD query. The amount of data retrieved is large and does consume over 5 minutes..

I have sucessfully used WebFOCUS to issue a DYNAM SUBMIT command and could use the same technique if I tested for a large data range being entered and if found, issue a background job to run.

In the background job, I would want to run the identical code and produce an HTML output file that could be viewed by the user when the report is finished (I am email an alert notifying the user his/her report is ready to view)

WebFOCUS has a nice trick with the following

-HTMLFORM template SAVE AS REPORT1

If this works in batch (JCL) I could save the results of the report in a PDS library and view if with

-HTMLFORM REPORT1..

Any ideas or other approaches?

Thanks in advance
 
Posts: 19 | Location: Omaha, NE | Registered: July 23, 2003Report This Post
<monte2000>
posted
The Product Manager tried this on NT (doesn't have an MVS WF server set up). It works for him. However, the manual has a typo. On page 8-58 of the WF 5.2 Developing Reporting Applications manual, point 3 says that 'filename' is created in step 2; it's ACTUALLY in step 4.

Also, he suggests not pointing output directly to a member of a pds but pointing to a sequential file, then use DYNAM COPY to copy it into the pds. Otherwise there could be problems.

This is his FEX
FILEDEF HTMLPAGE DISK C:\WORK\HTMLPAGE.HTM
TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD FORMAT HTMTABLE AS COUHTM
END
-RUN
-HTMLFORM FILENAME SAVE AS HTMLPAGE
 
Report This Post
Lou DeTota
Member
posted Hide Post
Rich,

If you are on MVS WebFOCUS you can also copy your output to the UNIX Systems Services under a directory of your choice by using the OCOPY command (consult the USS command reference from IBM) as a subsequent JCL step.
 
Posts: 17 | Location: SSA, Maryland | Registered: May 06, 2003Report 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     MVS Batch use of -HTMLFORM

Copyright © 1996-2020 Information Builders