Focal Point
Best way to import FOCUS database MVS->Linux

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

July 21, 2008, 02:42 PM
Rhonda
Best way to import FOCUS database MVS->Linux
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
July 21, 2008, 02:51 PM
GinnyJakes
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
July 21, 2008, 02:52 PM
GinnyJakes
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
July 22, 2008, 12:21 AM
dhagen
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
July 22, 2008, 04:00 AM
Danny-SRL
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

July 22, 2008, 09:18 AM
Rhonda
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
July 22, 2008, 04:04 PM
Leah
I concur, you need to avoid issues of EBCIDC to ASCII conversions. Have fun.


Leah
July 23, 2008, 08:59 AM
Danny-SRL
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

July 23, 2008, 01:22 PM
Rhonda
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
July 24, 2008, 05:59 PM
Waz
Daniel, have you been nicking my code, I wrote the same thing 6 years ago. Good One

Read the Master, extract each segment, FTP to (for me PC), and reload.


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!

July 25, 2008, 09:17 AM
Danny-SRL
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

July 25, 2008, 09:25 AM
Waz
I never thought I would say it, but thank [insert your god here] i work in an english society. Smiler

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


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!

July 28, 2008, 08:44 AM
PBrightwell
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