Fw: Powerhouse - migrate/port from HP3000 MPE to UNIX or Windows
Joe Boyle
joeboyle_adt@hotmail.com
Sat, 24 Apr 2004 12:53:33 +0100
<html><div style='background-color:'><DIV class=RTE>
<P>there used to be a command 'set lang sql' in qshow which allowed the creation of syntax for the tables in the database. I vaguely recall that this was'nt widely publicesed coz' the sql syntax produced was a little on the generic side and will probably require tweaking; should give a good staring point though. </P>
<P>I seem to recall that you then type 'generate database' but might be 'generate all'. I'm not sure if this is available in Windows/NT, but I seem to recall that it was available on the other 3 main platforms.<BR><BR></P></DIV>
<DIV></DIV>>From: "Peter Bateman" <shediac92@hotmail.com>
<DIV></DIV>>To: powerh-l@lists.sowder.com
<DIV></DIV>>Subject: RE: Fw: Powerhouse - migrate/port from HP3000 MPE to UNIX or Windows
<DIV></DIV>>Date: Fri, 23 Apr 2004 14:24:54 -0300
<DIV></DIV>>
<DIV></DIV>>If you are going to Relational
<DIV></DIV>>from Image.
<DIV></DIV>>
<DIV></DIV>>You can attach your IMAGE databases to an ALLBASE envirorment
<DIV></DIV>>using IMAGE/SQL then QSHOW or SQLGEN can generate CREATE TABLE
<DIV></DIV>>statements
<DIV></DIV>>for you.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>>From: "Philip Jackson" <pj@icing-it.co.uk>
<DIV></DIV>>>To: <powerh-l@lists.sowder.com>
<DIV></DIV>>>Subject: Fw: Powerhouse - migrate/port from HP3000 MPE to UNIX or
<DIV></DIV>>>Windows
<DIV></DIV>>>Date: Fri, 23 Apr 2004 14:32:43 +0100
<DIV></DIV>>>
<DIV></DIV>>>Powerhouse - migrate/port from HP3000 MPE to UNIX or WindowsI have
<DIV></DIV>>>just finished helping a client move several applications from
<DIV></DIV>>>HP3000/TurboIMAGE to HP-UX & C-ISAM.
<DIV></DIV>>>
<DIV></DIV>>>We looked at moving to Oracle on HP-UX, but discounted it mainly
<DIV></DIV>>>because the primary application relied heavily on arrays and
<DIV></DIV>>>substructures - things that don't fit easily into a relational
<DIV></DIV>>>system. If we had been starting a new application then Oracle
<DIV></DIV>>>would probably have been used as the database, but the port was
<DIV></DIV>>>much easier from Image to C-ISAM. We didn't look at Eloquence as I
<DIV></DIV>>>don't think it was even in beta-test at the time we were looking at
<DIV></DIV>>>options.
<DIV></DIV>>>
<DIV></DIV>>>The majority of the code moved over smoothly. Most recompiled
<DIV></DIV>>>without problems, and most PowerHouse code changes were to do with
<DIV></DIV>>>the order records were retrieved.
<DIV></DIV>>>
<DIV></DIV>>>We did discover that several of our QTPs accidently created
<DIV></DIV>>>duplicate unique keys briefly while updating due to the order of
<DIV></DIV>>>updates - Image doesn't enforce unique keys on detail datasets so
<DIV></DIV>>>it never caused a problem before, whereas C-ISAM does it properly
<DIV></DIV>>>and would crash the QTP. However it was simple to fix once we
<DIV></DIV>>>figured out what was causing it.
<DIV></DIV>>>
<DIV></DIV>>>Our biggest changes were, as you would expect, relating to
<DIV></DIV>>>interaction with the OS for things like printing and streaming
<DIV></DIV>>>jobs. I would recommend that you investigate the running/creating
<DIV></DIV>>>of scripts/jobs on the fly (if you do that) very carefully.
<DIV></DIV>>>
<DIV></DIV>>>The HP-UX machine runs about twenty (thats 20) times faster! - of
<DIV></DIV>>>course it's a completely different type of machine and more
<DIV></DIV>>>powerful, but the speed increase was almost incidental and
<DIV></DIV>>>impressed even the most demanding users. In fact sometimes it was
<DIV></DIV>>>difficult to convince the users that the jobs that usually would
<DIV></DIV>>>take, say, 20 minutes to run were completed and printing in under a
<DIV></DIV>>>minute.
<DIV></DIV>>>
<DIV></DIV>>>If you do anything at all fancy with printing, unix will fight you
<DIV></DIV>>>all the way. There is no inbuilt way to print a range of pages, or
<DIV></DIV>>>part of a file, or even resuming a jammed printout back a bit
<DIV></DIV>>>without cancelling and resubmitting the print. While it does nice
<DIV></DIV>>>banner pages and is fine for printouts that, well, just print and
<DIV></DIV>>>don't jam, adding a new printer for example stops and restarts all
<DIV></DIV>>>print jobs currently printing from the beginning (or if you're
<DIV></DIV>>>lucky just stops them). We tried a couple of third-party spooling
<DIV></DIV>>>products but quite frankly they were relying on a greater depth of
<DIV></DIV>>>knowledge of networks and unix than we had or wanted, and were
<DIV></DIV>>>really aimed at a mixed os printing environment. A few things were
<DIV></DIV>>>better, but by-in-large I consider printer handling on HP-UX
<DIV></DIV>>>'incomplete'.
<DIV></DIV>>>
<DIV></DIV>>>Some of the more advanced users were used to using various line
<DIV></DIV>>>editors to write their own quizes. There was no way they could
<DIV></DIV>>>have handled vi on HP-UX - even some of the non-unix programmers
<DIV></DIV>>>spent days laughing hysterically over it - so we bought the new
<DIV></DIV>>>Qedit for HP-UX for them. There were other ways we could have done
<DIV></DIV>>>it - perhaps having shares on the unix boxes mapped in Windows so
<DIV></DIV>>>that they could have used Notepad or any other windows editor
<DIV></DIV>>>instead - but it was decided this was a better fit. And it helped
<DIV></DIV>>>some of the programmers too who were already feeling unloved by
<DIV></DIV>>>unix.
<DIV></DIV>>>
<DIV></DIV>>>The standard users wouldn't have noticed the difference between it
<DIV></DIV>>>running on HP3000 or HP-UX, if it wasn't for the enormous speed
<DIV></DIV>>>increase. Quick screens handle just about identically, and they
<DIV></DIV>>>even continued using the same terminal emulators.
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>Hope this answers some of your questions, and reassures anyone else
<DIV></DIV>>>looking at doing PowerHouse HP3000 to HP-UX.
<DIV></DIV>>>
<DIV></DIV>>>Can't advise with porting to PowerHouse on Windows, and as for
<DIV></DIV>>>converting to Cobol / Java, that would be a re-write rather than a
<DIV></DIV>>>'simple' port and therefore quite a different type of project.
<DIV></DIV>>>Maybe if you were going to be replacing an old PowerHouse
<DIV></DIV>>>application that no longer suited the business with a brand new
<DIV></DIV>>>better-stronger-faster-differently-featured one and you didn't want
<DIV></DIV>>>to stay with PowerHouse (shame!) then using a completely different
<DIV></DIV>>>language would make sense. But I can't see that porting between
<DIV></DIV>>>such very different languages would be a good use of your time and
<DIV></DIV>>>effort.
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>Philip.
<DIV></DIV>>>
<DIV></DIV>>>----- Original Message -----
<DIV></DIV>>> From: Fritsch, Peter-Robert
<DIV></DIV>>> To: powerh-l@lists.sowder.com
<DIV></DIV>>> Sent: Friday, April 23, 2004 10:54 AM
<DIV></DIV>>> Subject: Powerhouse - migrate/port from HP3000 MPE to UNIX or
<DIV></DIV>>>Windows
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>> Hi, what is the best way to port/migrate/run PowerHouse
<DIV></DIV>>>applications (with TurboIMAGE) from a HP 3000 / MPE to UNIX or
<DIV></DIV>>>Windows Servers.
<DIV></DIV>>>
<DIV></DIV>>> Are there runtimes for Powerhouse on UNIX or Windows, which can
<DIV></DIV>>>be used for the applications developed for HP3000.
<DIV></DIV>>> Are there porting or migration tools from PowerHouse to COBOL /
<DIV></DIV>>>JAVA.
<DIV></DIV>>>
<DIV></DIV>>> What is the best way for the exchange of the environment,
<DIV></DIV>>>whereby the applications should be still working under UNIX or
<DIV></DIV>>>Windows.
<DIV></DIV>>>
<DIV></DIV>>> Thanks a lot, regards Peter
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>> Ing. Mag. Peter Robert Fritsch
<DIV></DIV>>> Account Manager
<DIV></DIV>>> Geschäftsfeld Informatik
<DIV></DIV>>>
<DIV></DIV>>> Tel.: +43 1 797 50-231
<DIV></DIV>>> Fax: +43 1 797 50-8008
<DIV></DIV>>> Mobil: +43 676 765 66 31
<DIV></DIV>>> Email: peter-robert.fritsch@beko.at
<DIV></DIV>>>
<DIV></DIV>>> BEKO Ing. P. Kotauczek GmbH
<DIV></DIV>>> A-1030 Wien
<DIV></DIV>>> Modecenterstraße 22/A1/6
<DIV></DIV>>> www.beko-informatik.com
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>
<DIV></DIV>>_________________________________________________________________
<DIV></DIV>>MSN Premium: Up to 11 personalized e-mail addresses and 2 months
<DIV></DIV>>FREE*
<DIV></DIV>>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
<DIV></DIV>>
<DIV></DIV>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<DIV></DIV>>Mailing list: powerh-l@lists.sowder.com
<DIV></DIV>>Subscribe: "subscribe" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>Unsubscribe: "unsubscribe <password>" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>http://lists.sowder.com/mailman/listinfo/powerh-l
<DIV></DIV>>This list is closed, thus to post to the list you must be a
<DIV></DIV>>subscriber.
<DIV></DIV></div><br clear=all><hr>Have more fun with your phone - download ringtones, logos, screensavers, games & more. <a href="http://g.msn.com/8HMBENUK/2728??PS=">Click here to begin!</a> </html>