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.
Do any one help me in converting a FOCUS program to COBOL program. How to define the structure of FOCUS in COBOL program? Is there any parent-child retrieval in COBOL?
Can any one send me the procedure and sample for converting a FOCUS to COBOL program??
Boy, I hardly know what to say. Unless FOCUS is going away, I can't imagine why anyone would want to do this. Nor is there a cookbook that describes exactly what to do.
But here are some ideas.
First, print out the master file description and access file if there is one and identify the data source. If the file is a FOCUS file (and based on your comments, I suspect it is), you are going to have to convert it to something else. The only truly mainframe hierarchical data base is IMS. Otherwise you will have to put each segment in its own file and join them.
Next, identify the business logic in the focexec. That will be found in the DEFINE, COMPUTE, and WHERE statements in the program.
Then, run the FOCUS program and look at the format of the output.
That should give you a good idea as to how to write the COBOL program (with many many lines) to reproduce the function of the few lines of FOCUS code in the focexec.
Are you looking to do this with Core FOCUS or WebFOCUS?
I believe what you are looking for is documentation on the FOCUS Host Language Interface (HLI). Have you downloaded the HLI User Manual for your platform from the Tech support site?
Unless IBI has changed the pricing structure for FOCUS, HLI is not free.
rb, could you give us some response on the ideas that have been posted here? We are poking around in the dark trying to give you ideas when we are not exactly sure what you are trying to do.
I have the same question as FerankDutch. Why do this?
If you truly want/need to convert a *.fex into a stand-alone COBOL program, I can post a bit more guidance as to where in COBOL you'd have to code the major parts of a *.fex process (DEFINEs, COMPUTEs, TABLE FILE, BYs, WHEREs, ON TABLes, STYLEs, etc.)
After 30 years of working with ALGOL, PL/1, Fortran and COBOL I appreciate the ease with which one can code processes in the FOCEXEC language. You must have a very good reason (or a Political/Policy need) to even consider retrofiting back to a COBOL process.
Now that I'm an 'ol f..t, I finally understand what my Dad ment when he said "These young'ens never know how good they got it!"
C. Burtt
WIN/2K running WF 7.6.4 Development via DevStudio 7.6.4, MRE, TextEditor. Data is Oracle, MS-SQL.
Posts: 154 | Location: NY | Registered: October 27, 2005
Interesting I learned FOCUS in 1993. I was handed a manual and asked to convert 200 COBAL reports to FOCUS. Can't imagine in 2007 having to go backwards.
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005
hi friends thanks for all your replies sorry for not replying for your messages i am engaged with some other work.
i like to introduce my self I am Revathi from India currently working in mainframe domain
the need for this issue that we have many reports already generated in FOCUS (core), as FOCUS is out of reach for many people , we try to generate those reports using COBOL instead FOCUS.
if you have any suggestion regarding this issue, please guide me.
Kind of odd that COBOL would be more "within reach" than FOCUS generated reports. Hmm
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
So you DO have Webfocus 2.1...wow - I don't even know what that does... When you say out of reach,...you mean to run them...or just recieve them? Seems it would be easier to make a front end for them to run..then convert them to COBOL. Is a WebFocus upgrade out of the question?
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005
BTW, I don't think there ever was a WF version of 2.1. It started in the 3.x range. You would think that's odd, but if you've followed IBI's product numbering schema for many years, it's no surprise at all.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
Okay, I'm not really sure if I'm interpreting this right, but I think he may mean that the developers in his company are Cobol programmers and the company is not going to provide training for these programmers to learn Focus, so it would be easier to convert the Focus programs to Cobol. If I am correct, then man, somebody from IBI need to talk to that company...
P.S. rb4u, tell your company to outsource the conversion to someone like... uhm, ME. hah hah. Or tell your boss to at least pay for one person to get basic training that way, you can have that one person interpret the Focus program into business case that you can then give to the cobol programmers to write.
can anyone suggest me with all the upgradation that are possible, not possible, and issues regarding this upgradation!
I would suggest that your local IB branch should be able to tell you what upgrade options are possible and also suitable for your current platfrom and configuration. (Z/OS with Unix partition, WebSphere etc. etc. etc.)
They should also be able to supply you with a list of current known problems with the release to which you intend to upgrade.
As for the horror stories, I'm sure if folks have encountered any, you'll soon see them posting.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
So which version are you REALLY on? FOCUS 7.3 or WF 2.1 (even though there is no 2.1) and if you have WF and/or FOCUS, why are you wanting to convert reports to COBOL? And if you're moving your reports to COBOL, why are you upgrading your FOCUS version? It's kind of hard to determine what you're asking for here--
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
it appears to me that this request comes from a outsource location itself, an offshore programming contract, where the offshore programmer just contacts the onshore volunteers to do the work. hmm. alot of that going on lately.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Thanks for ur response. As you said Curently we are using the Focus core 7.3, and we want the version upgradation from 7.3 to 7.6. Friends do anyone had done this version upgradation before..., or else do you have any idea what are the major and minor changes that we face after the upgradation in programming point of view. i would appreciate if anyone gives me the details regarding this.
Actually WebFOCUS did start with a 1.0 if I remember correctly. I believe it came out in 1996. I was working for IBI at the time contracted to the US Postal Service. Folks from NY came down to Washington DC to install it at the Postal Service. I never actually touched it and don't know if the USPS ever used it it but I know it was installed there.
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003