Focal Point
[CLOSED] Botsched to retreive file sitting on mainframe

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

February 01, 2013, 11:14 AM
Tomsweb
[CLOSED] Botsched to retreive file sitting on mainframe
I would like to use botsched to retrieve a large file from the mainframe to use as data
source for reports created in WebFOCUS.

This file is created nightly in a batch process.

Can anyone provide any pointers? I am researching this on the Techsupport site.

Thanks Wink

This message has been edited. Last edited by: Kerry,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
February 01, 2013, 02:09 PM
ABT
First off, when you say using BOTSCHED, do you mean you'd like to time this process to run under ReportCaster?

Off hand, I'd say to use System/Shell commands to do a copy (or cp) of the file into one of the WebFOCUS APP directories. You'll need a corresponding MAS file that provides the data definition.

- ABT

quote:
Originally posted by Tomsweb:
I would like to use botsched to retrieve a large file from the mainframe to use as data
source for reports created in WebFOCUS.

This file is created nightly in a batch process.

Can anyone provide any pointers? I am researching this on the Techsupport site.

Thanks Wink



------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
February 03, 2013, 03:32 PM
Waz
From your signature it looks like you have WebFOCUS on the Mainframe.

Where is the file to end up ?
Is there a WebFOCUS there ?

If so, and the connectivity exsts, you can get WebFOCUS to "PCHOLD" the file to one of the other WebFOCUS installs.

You could also call FTP if it is available.

We would need to know more info on the source and destination.


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!