Get the most out of
your Robelle Tools
Migrating Suprtool to HP-UX
By Neil Armstrong,
Suprtool Software Architect
One of the frequent questions recently is what are the differences between MPE and HP-UX? It is evident that many customers recognize the investment that they have in their Suprtool code and want to know the types of changes they need to make in order for it to work on HP-UX.
Differences Between MPE and HP-UX
We have tried to make the
MPE and HP-UX versions of Suprtool as compatible as possible. I will
describe here how Suprtool/UX is different from Suprtool/MPE.
Suprtool for HP-UX currently works with three databases; these are Eloquence, Oracle and Allbase.
Currently, by default you can use the standard Image commands against Eloquence. The standard Image commands in Suprtool are: Base, Get, Delete, Put, Update and any of the Dbedit commands.
We have the option to use these same commands against Oracle databases using Suprtool with the IMAXSoft option.
This means that you can port your scripts directly over from MPE to HP-UX with very few changes. Of course you must acquire the OpenTurbo product from IMAXSoft (but their call conversion libraries are also handy for converting an IMAGE database and associated programs to Oracle quite painlessly). Here is the Web link: www.imaxsoft.com/OpenTURBO.htm
We are also working with another vendor to utilize their libraries, which will give us another option for migration. The goal here is to open even more database options for Suprtool/UX, such as DB2 support.
If you have your own call conversion library, please email me at email@example.com and we would be glad to look at supporting it in Suprtool/UX.
And, we are working on a generic option that should work for anyone who has their your own libraries that convert Image calls to Oracle (or any other database); providing instant Suprtool support instead of having to contact Robelle and wait a month for a new R&D pre-release.
All of these options are slated for the production version of Suprtool 4.8 and are available starting with the pre-release version 4.7.12.
If you do not want to
use the IMAXSoft option or another call conversion library, you can
still access Oracle using Suprtools Open and Select commands.
These commands correspond to the Base and Get commands, so the script
conversion from MPE to HP-UX can be mostly mechanical.
On MPE, Suprtool can obtain the record length of a file. On HP-UX, there is no concept of an official record length, because a file consists of a string of bytes. In Suprtool/UX there are two ways to determine the record length, if a data file actually consists of a regular repeated pattern of record length data bytes:
1. Specify the record
length with the Rec parameter of the Input command.
If the specified
record size is incorrect, Suprtool/UX cannot detect the mismatch. The
most common symptom of an incorrect specification in size is an
offset of one or more characters in each field.
In MPE, there is no
separator between records in a file. In HP-UX, there may not be a
separator, or there may be a line feed between each record. For
Suprtool to correctly read a data file, it must know whether the line
feeds are present. You can specify whether or not a file has line
feeds via the LF or NOLF options in the Input command.
If the output file
already exists (and you havent requested the Erase or Append
option), Suprtool has to decide what to do. This is how Suprtool/UX
handles duplicate output files:
The following Suprtool features on MPE are currently not available in Suprtool/UX:
Extracting a range
of fields from an SQL database
Copyright The 3000 NewsWire. All rights reserved.