Focal Point
MVS Batch use of -HTMLFORM

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5721067331

July 31, 2003, 12:43 PM
Rich Dickeson
MVS Batch use of -HTMLFORM
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
September 10, 2003, 08:18 PM
<monte2000>
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
September 29, 2003, 03:16 PM
Lou DeTota
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.