 |
|||||
|
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
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Best way to import FOCUS database MVS->Linux
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Best way to import FOCUS database MVS->Linux Read-Only TopicGo | Search | Notify | Tools |
| Best way to import FOCUS database MVS->Linux | Login/Join |
| Platinum Member |
We are looking into moving applications and FOCUS databases from MVS to Linux. Yes, we could download flat files and write a MODIFY to create a FOCUS database on Linux, does anyone else have another way to do that is more eloquent? WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML | ||
|
| Expert |
Rhonda, That actually works the best and is the safest. There is a fairly recent post on moving a FOCUS database from Unix to Windows. The technique is the same. Check it out. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
Here is the link. It was MVS to Windows. https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/5581019192 Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Virtuoso |
There is an import command in Focus for Unix (called "IMPORT") that you might want to look into. You ftp the focus and master files from MVS to Lynx, issue some settings, then Focus will import the focus files for you. It should be in the documentation for Focus for Unix. I used it many years ago for importing from VM to AIX ... it turned out to be a real time saver. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Virtuoso |
Rhonda, We did this a lot for our customers. We even created a set of procedures to automate the process. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Platinum Member |
Thanks for the recommendations and links to documentation. I was wondering if the IMPORT command/utility on the Unix platform was still intact. WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML | |||
|
| Virtuoso |
I concur, you need to avoid issues of EBCIDC to ASCII conversions. Have fun. Leah | |||
|
| Virtuoso |
Rhonda, Another word. If you have many files to move from MVS to Linux, we can help. We have some FOCEXECs that do just that. They analyse the MASTER on the MVS; create HOLD files (either from individual segments or from full hierachy paths); FTP the HOLD files to Linux (we did this with Windows, but it is the same); recombine the transferred files into FOCUS files on Linux. If you have IMS files, they can also be imported to Focus files from MVS to Linux. So we run the MVS procedure on MVS, then run the Linux procedure. It saves a lot of time and prevents headaches. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Platinum Member |
Thanks again for the responses. They are all very helpful and has given us options. WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML | |||
|
| Expert |
Daniel, have you been nicking my code, I wrote the same thing 6 years ago.  Read the Master, extract each segment, FTP to (for me PC), and reload. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
Waz, Well, we also have here a much more sticky problem. It is called Hebrew. As you (probably) know, Hebrew is written right-to-left. However, numbers are written left-to-right. And some of our customers have fields with mixed data: Hebrew, English, numbers and special characters. Then the code pages are different. Not the same even on M/F. We have fun! Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
I never thought I would say it, but thank [insert your god here] i work in an english society.  This message has been edited. Last edited by: Waz, Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Danny, I have a whole new respect for you. Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Best way to import FOCUS database MVS->Linux
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Best way to import FOCUS database MVS->LinuxCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |