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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Focus/Jcl
 Login/Join
 
Sonny
Member
posted
Hello Folks,

I wonder if anyone can guide me with the proper way to have a JCL execute a FOCUS report, save the file to to a dataset, then ftp to another machine.
The focus report is correct because I can execute manually and obtain correct data. The ftp portion of the jcl works. I just can't seem to figure out how to generate the file to ftp.
Btw, zOS 1.9, Focus 762.

Thank you.

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


Sonny
 
Posts: 4 | Location: California, USA | Registered: February 06, 2009Report This Post
<JG>
posted
You cannot send the file to ftp, you must create the file as a physical dataset
or pds member which is not deleted at the end of the Focus step in the JCL.

Your FTP JCL step will then be able to find the file.
 
Report This Post
Sonny
Member
posted Hide Post
I think I got it working with

DYNAM ALLOC DD ddname DS ....

TABLE FILE ...
.
.
ON TABLE SAVE AS ddname
END

Is this the correct way to create the report as a physical dataset?

Btw, is it normal for FOCUS variables like &MDY to not work when executing from a JCL?


Sonny
 
Posts: 4 | Location: California, USA | Registered: February 06, 2009Report This Post
<JG>
posted
You can either do it the way you have using DYNAM in the Focus request or allocate the file in the JCL with the KEEP option.

Standard Focus variables like &MDY should be available even when run as a batch job.
 
Report This Post
Sonny
Member
posted Hide Post
Thank you very much. I will try it again. I am new to the JCL world so I must have a few more bugs that are causing the &MDY error.


Sonny
 
Posts: 4 | Location: California, USA | Registered: February 06, 2009Report This Post
PBrightwell
Master
posted Hide Post
&MDY is used in FOCUS/WebFOCUS for the system date. What are you trying to accomplish? Do you have a sample of your program and your JCL. Remember to put the code between code tags < / > above.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
j.gross
Virtuoso
posted Hide Post
quote:
Btw, is it normal for FOCUS variables like &MDY to not work when executing from a JCL?


Yes.

In short, the SYSIN script is not a focexec, so it's not processed by dialog manager, and no substitution takes place.

When a focexec is run with the EX command, it is pre-processed by Dialog Manager, and the resulting lines are then handed off to another process that executes pure Focus code. But the sysin stream (whether following //SYSIN DD * in JCL, or input line-by-line in CMS or TSO) is subject only to the latter process, so references to system variables (e.g., in a report heading) remain as is.

To take advantage of D.M. facilities, store the code as a member of a pds allocated to FOCEXEC, and put an EX command in the sysin script.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders