Focal Point
List the procedures (FOCEXECs) on the default WebFOCUS Reporting Server (how to do?)

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

December 05, 2011, 05:27 PM
Dave02
List the procedures (FOCEXECs) on the default WebFOCUS Reporting Server (how to do?)
I've searched this forum for answers but I can't seem to find the right incantation to pull back a relevant thread.

The ReportCaster API Developer's Reference at http://ecl.informationbuilders...i/source/topic15.htm states the following:

quote:

The ReportCaster API provides methods that enable you to:

Create a report schedule specifying the run time, distribution method (e-mail, FTP, printer, Managed Reporting, or Report Library), notification parameters, report format, and whether to burst the report.
Schedule alerts.
Schedule the distribution of a file or the contents of a URL.
Schedule a Managed Reporting procedure.
Retrieve a list of scheduled Managed Reporting procedures.
List the procedures (FOCEXECs) on the default WebFOCUS Reporting Server available for scheduling.


However it doesn't actually show you how to do that. Looking over the included sample programs, there doesn't seem to be one that illustrates how to do this. The Javadoc doesn't help because I'm not sure what class I need to be looking at.

Any help would be appreciated.

Thanks,
Dave


WebFocus 7.6.11 on Linux for X64 (Intel, AMD) 64 bit - Licensed Cores: 4
HTML, PDF, CSV
December 05, 2011, 05:36 PM
Waz
This may well relate to the APP path active at the time.

You could always turn tracing on and see what query is sent to get the list ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 06, 2011, 10:51 AM
GamP
And it also depends on what your goal is with that knowledge.
If you want to produce this list outside of ReportCaster, simply do a APP QUERY appname and you'll see wht files are in appname. Add HOLD to the statement followed by TABLE off of that holdfile to narrow it down to whatever you want / need.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
December 08, 2011, 04:19 PM
Dave02
Thanks for your replies, however I'm afraid I'm new enough to web focus that I don't understand your answers. The only web focus training I've had is some Report Painter training.

My current task lies *way* outside of that limited training. I'm attempting to figure out the Java API for reportcaster so that I can query the server for a list of procedures that are available to be scheduled. Later on I will be using the API to actually schedule those procedures to be run a specific times.

On a related note, when I launch the reportcaster applet, and attempt to create a task as part of creating a new schedule, when I go to select the webfocus procedure and I login to the server, I don't see any applications or procedures at all.

I suspect this is because I don't have WF, or ReportCaster configured properly. I appreciate any help.

Thanks,
Dave


WebFocus 7.6.11 on Linux for X64 (Intel, AMD) 64 bit - Licensed Cores: 4
HTML, PDF, CSV
December 08, 2011, 09:15 PM
Francis Mariani
I'm not sure if you can fit this into your API coding, but here is a way to create a list of all programs in the application folders: http://forums.informationbuild...1057331/m/2417079316.

Meanwhile, if you have an Information Builders site code, you can create a Tech Support User ID and either open a case or search for a solution - you may find more answered than on this forum.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 09, 2011, 04:27 AM
Håkan
Dave, the Report Caster repository is stored in a number of tables. The table names all start with BOT, where BOTSCHED contains the schedules, with links to BOTPACK where the taskid links to the BOTTASK table. There you can find all info on the different procedures submitted by Report Caster. Have a word with your dba where to find these tables. Then create synonyms for them and create reports in the Report Painter.

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)