Hi,

I am relatively new to Webfocus. One of our potential customers are looking for an option to migrate the existing Focus on mainframe application to Webfocus on Windows server. The focus application currently makes use of DB2 on zOS. I am just trying to understand the feasibility of migrating the Focus applications to Webfocus. Also, I am trying to find out if there would be any difficulties in accessing the DB2 data from Webfocus. Any help in this regard would be really appreciated. Thanks.

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

Many people access z/OS db2 from off platform. There are even some performance enhancements in z/OS db2 that are only available when the request comes in from off platform (better use of their ziip processor).
One item to watch for if you care ... DB2 z/OS sorts the data in EBCIDIC order - numbers come after letters for alpha strings. 5 years ago, doing a SELECT against UNIX db2 versus z/OS produced different collated answers. Maybe they have a switch for that now so if they know the data is going to ASCII land they will adjust.

But the important thing to watch for is you can not do things like IF ALPHA GE '00000' ... must be a number. Especially if your dev environment will be on a windows test db and production is on z/OS.

Another thing you should keep in mind is the user interface.
What does your customer use? -CRTFORM?
If so, you will probably have a lot to do when you WEBify the user interface. We have had a lot of experience and developed techniques to do this. You can contact me if you wish.

Also MODIFY CRTFORM's.

Is this an application or kust reporting ?