[Robelle-l] Mapping information on Suprtool(MPE) commands to Suprtool(HP-UX) commands.
Neil Harvey
neil@nha.co.za
Sat, 7 Feb 2004 07:42:31 +0200
This is a multi-part message in MIME format.
------_=_NextPart_001_01C3ED3D.2D9B934B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
It would be great if some of the HPUX ability to handle POSIX files was
retrofitted to the MPE version.
We use bytestream files to handle log and archive information for web
and other transactions, and have to turn these into MPE files for
extract tools.
=20
Maybe this has already been done, and I should just read the manual :)
=20
Regards
=20
Neil
=20
=20
=20
-----Original Message-----
From: robelle-l-admin@robelle.com
[mailto:robelle-l-admin@robelle.com] On Behalf Of Neil Armstrong
Sent: 06 February 2004 05:37
To: Rahul.Singh@Lntinfotech.com; robelle-l@robelle.com
Subject: RE: [Robelle-l] Mapping information on Suprtool(MPE)
commands to Suprtool(HP-UX) commands.
=09
=09
=20
Following is the excerpt from the manual on the differences
between MPE and HP-UX. These are the
main issues.
=20
I would still like to know what database you are going to port
to as we have many new developments
in these areas.
=20
Neil
=20
Differences Between MPE and HP-UX
We have tried to make the MPE and HP-UX versions of Suprtool as
compatible as possible. This section describes how Suprtool/UX is
different from Suprtool/MPE.
Record Length
On MPE, Suprtool can obtain the record length of a file. There
is no concept of record length on HP-UX because a file consists of a
string of bytes. In Suprtool/UX, there are two ways to determine the
record length.
1. Specify the record length with the Rec parameter of
the Input command.
2. Use self-describing files.
If the specified record size is incorrect, Suprtool/UX cannot
verify it. The most common symptom of an incorrect specification in size
is an offset of one or more characters in each field.
Line Feeds
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.
Suprtool and STExport allow control over whether or not line
feeds will be written to the output file or not. For details please see
the Output Commands for both Suprtool and STExport.
Duplicate Output Files
If the output file already exists (and you haven't requested the
Erase or Append option), Suprtool has to decide what to do. This is how
Suprtool/UX handles duplicate output files:
1. In Suprtool/UX, the duplicate output file processing
takes place at the beginning of a task (in Suprtool/MPE it occurs at the
end).
2. If Suprtool/UX is in batch, it purges any existing
file with the same file name (Suprtool/MPE chooses a new output file
name of the form OutputNN). If the Suprtool/UX task is on-line, it
prompts the user to purge the file.
3. When Suprtool/UX purges a data file, it always deletes
any associated .sd file, even if the output option is not Query or Link.
Classic Reals
Suprtool/UX does not support Classic real numbers (real or
long). If you are porting data files from MPE to HP-UX, you should first
convert any Classic floating point numbers to their IEEE floating point
equivalents. You can do this by using the Extract command on
Suprtool/MPE.
:run suprtool.pub.robelle
>base sample
>get customer
>define ieee-credit-rating,1,4,ieee
>extract cust-no
>extract name-first
>extract name-last
>extract ieee-credit-rating =3D credit-rating
>out mpefile
>xeq
The Classic and IEEE floating point formats are not identical.
Be sure to check the IEEE values after converting them from Classic
floating point.
Input from Stdlist
In Suprtool/MPE, "input *" means read the input data from the
stdin input device. This is usually a job stream, and data is terminated
by an !EOD symbol.
Suprtool/UX does not support reading data from stdin (via Input
* or any other method). If you need to create temporary data in the
middle of a script, it is easy to use a temporary file. For example, the
following script creates a temporary file, writes three lines of data to
it, then uses this file as input to Suprtool/UX. At the end of the
script we make sure that we remove the temporary file that we created.
#!/bin/sh
=20
datafile=3D`mktemp`
=20
echo "1234567 Line 1" >> $datafile
echo "2345678 Line 2" >> $datafile
echo "3456789 Line 3" >> $datafile
=20
suprtool << !EOD
input $datafile,rec 14,lf
define key ,1,7
define line ,8,7
extract key
extract line
list standard
exit
!EOD
=20
rm $datafile
Missing Features
The following Suprtool features on MPE are currently not
available in Suprtool/UX:
* Extracting a range of fields from an SQL database
* Export command (STExport exists as a separate program)
* Hints are not available
* Link command (Suprlink exists as a separate program)
* Table Command with the File option requires that the
file being loaded is self-describing.
* Out=3D option of the Listredo command
* Output Ask, Num,Key, and Num,Query
* Output Temp (There are no temporary files in HP-UX)
* Output =3DInput
Totals to a file
-----Original Message-----
From: robelle-l-admin@robelle.com
[mailto:robelle-l-admin@robelle.com]On Behalf Of
Rahul.Singh@Lntinfotech.com
Sent: Friday, February 06, 2004 9:03 AM
To: robelle-l@robelle.com
Subject: [Robelle-l] Mapping information on
Suprtool(MPE) commands to Suprtool(HP-UX) commands.
=09
=09
Hi Neil!=20
=09
I am involved in HP3000 migration and HP9000 is a target
platform under consideration.=20
=20
I appreciate your help to get the following information.
=09
Are there any diferences in operations,commands or
syntaxes between Suprtool on MPE and the same on HP-UX ?=20
=09
If yes then we would be grateful if you could kindly
provide us with the direct mapping of commands or syntaxes of Suprtool
mpe commands to hpux commands.=20
=09
Thanks.=20
=09
Rahul.
------_=_NextPart_001_01C3ED3D.2D9B934B
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office"><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2>It=20
would be great if some of the HPUX ability to handle POSIX files was =
retrofitted=20
to the MPE version.</FONT></SPAN></DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2>We use=20
bytestream files to handle log and archive information for web and other =
transactions, and have to turn these into MPE files for extract=20
tools.</FONT></SPAN></DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2>Maybe=20
this has already been done, and I should just read the manual=20
:)</FONT></SPAN></DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2>Neil</FONT></SPAN></DIV>
<DIV><SPAN class=3D236024005-07022004></SPAN> </DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D236024005-07022004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
robelle-l-admin@robelle.com [mailto:robelle-l-admin@robelle.com] <B>On =
Behalf=20
Of </B>Neil Armstrong<BR><B>Sent:</B> 06 February 2004 =
05:37<BR><B>To:</B>=20
Rahul.Singh@Lntinfotech.com; robelle-l@robelle.com<BR><B>Subject:</B> =
RE:=20
[Robelle-l] Mapping information on Suprtool(MPE) commands to =
Suprtool(HP-UX)=20
commands.<BR><BR></FONT></DIV>
<DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><FONT=20
face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff =
size=3D2>Following is=20
the excerpt from the manual on the differences between MPE and HP-UX. =
These=20
are the</FONT></SPAN></DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff =
size=3D2>main=20
issues.</FONT></SPAN></DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff =
size=3D2>I would still=20
like to know what database you are going to port to as we have many =
new=20
developments</FONT></SPAN></DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff =
size=3D2>in these=20
areas.</FONT></SPAN></DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004><FONT face=3DArial color=3D#0000ff=20
size=3D2>Neil</FONT></SPAN></DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium =
none"><SPAN=20
class=3D809403315-06022004></SPAN> </DIV>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0pt; BORDER-TOP: =
windowtext 0.75pt solid; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; =
BORDER-LEFT: medium none; PADDING-TOP: 1pt; BORDER-BOTTOM: medium none">
<H2 style=3D"MARGIN: 18.1pt 0pt 2.15pt"><FONT face=3DArial>Differences =
Between MPE=20
and HP-UX</FONT></H2></DIV>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>We have=20
tried to make the MPE and HP-UX versions of Suprtool as compatible as=20
possible. This section describes how Suprtool/UX is different from=20
Suprtool/MPE.</FONT></P>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Record=20
Length</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>On MPE,=20
Suprtool can obtain the record length of a file.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>There is no concept of =
record length=20
on HP-UX because a file consists of a string of bytes.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>In Suprtool/UX, there are =
two ways to=20
determine the record length.</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l105 level1 lfo161; =
tab-stops: list 198.0pt"><FONT=20
size=3D2>1.</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN><FONT size=3D2>Specify the record length with the Rec parameter =
of the=20
Input command.</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l105 level1 lfo161; =
tab-stops: list 198.0pt"><FONT=20
size=3D2>2.</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN><FONT size=3D2>Use self-describing files.</FONT></P>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>If the=20
specified record size is incorrect, Suprtool/UX cannot verify it. The =
most=20
common symptom of an incorrect specification in size is an offset of =
one or=20
more characters in each field.</FONT></P>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Line=20
Feeds</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>In MPE,=20
there is no separator between records in a file. In HP-UX, there may =
not be a=20
separator, or there may be a line feed between each record. For =
Suprtool to=20
correctly read a data file, it must know whether the line feeds are =
present.=20
You can specify whether or not a file has line feeds via the LF or =
NOLF=20
options in the Input command.</FONT></P>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT=20
size=3D2>Suprtool and STExport allow control over whether or not line =
feeds will=20
be written to the output file or not. For details please see the =
Output=20
Commands for both Suprtool and STExport.</FONT></P>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Duplicate=20
Output Files</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>If the=20
output file already exists (and you haven't requested the Erase or =
Append=20
option), Suprtool has to decide what to do. This is how Suprtool/UX =
handles=20
duplicate output files:</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l125 level1 lfo165; =
tab-stops: list 198.0pt"><FONT=20
size=3D2>1.</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN><FONT size=3D2>In Suprtool/UX, the duplicate output file =
processing takes=20
place at the beginning of a task (in Suprtool/MPE it occurs at the=20
end).</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l125 level1 lfo165; =
tab-stops: list 198.0pt"><FONT=20
size=3D2>2.</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN><FONT size=3D2>If Suprtool/UX is in batch, it purges any =
existing file=20
with the same file name (Suprtool/MPE chooses a new output file name =
of the=20
form OutputNN). If the Suprtool/UX task is on-line, it prompts the =
user to=20
purge the file.</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l125 level1 lfo165; =
tab-stops: list 198.0pt"><FONT=20
size=3D2>3.</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN><FONT size=3D2>When Suprtool/UX purges a data file, it always =
deletes any=20
associated .sd file, even if the output option is not Query or=20
Link.</FONT></P>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Classic=20
Reals</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT=20
size=3D2>Suprtool/UX does not support Classic real numbers (real or =
long). If=20
you are porting data files from MPE to HP-UX, you should first convert =
any=20
Classic floating point numbers to their IEEE floating point =
equivalents. You=20
can do this by using the Extract command on Suprtool/MPE.</FONT></P>
<DIV=20
style=3D"BORDER-RIGHT: windowtext 0.75pt solid; PADDING-RIGHT: 1pt; =
BORDER-TOP: windowtext 0.75pt solid; PADDING-LEFT: 1pt; PADDING-BOTTOM: =
1pt; BORDER-LEFT: windowtext 0.75pt solid; PADDING-TOP: 1pt; =
BORDER-BOTTOM: windowtext 0.75pt solid">
<P class=3DSourceTop style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT=20
face=3D"Courier New" size=3D2>:run suprtool.pub.robelle</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>base<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>sample</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>get<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>customer</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>define<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>ieee-credit-rating,1,4,ieee</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>extract<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>cust-no</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>extract<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>name-first</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>extract<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>name-last</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>extract<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>ieee-credit-rating =3D credit-rating</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>out<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>mpefile</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>>xeq</FONT></P></DIV>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>The=20
Classic and IEEE floating point formats are not identical. Be sure to =
check=20
the IEEE values after converting them from Classic floating =
point.</FONT></P>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Input from=20
Stdlist</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>In=20
Suprtool/MPE, "input *" means read the input data from the stdin input =
device.=20
This is usually a job stream, and data is terminated by an !EOD=20
symbol.</FONT></P>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT=20
size=3D2>Suprtool/UX does not support reading data from stdin (via =
Input * or=20
any other method). If you need to create temporary data in the middle =
of a=20
script, it is easy to use a temporary file. For example, the following =
script=20
creates a temporary file, writes three lines of data to it, then uses =
this=20
file as input to Suprtool/UX. At the end of the script we make sure =
that we=20
remove the temporary file that we created.</FONT></P>
<DIV=20
style=3D"BORDER-RIGHT: windowtext 0.75pt solid; PADDING-RIGHT: 1pt; =
BORDER-TOP: windowtext 0.75pt solid; PADDING-LEFT: 1pt; PADDING-BOTTOM: =
1pt; BORDER-LEFT: windowtext 0.75pt solid; PADDING-TOP: 1pt; =
BORDER-BOTTOM: windowtext 0.75pt solid">
<P class=3DSourceTop style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT=20
face=3D"Courier New" size=3D2>#!/bin/sh</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
size=3D2><FONT=20
face=3D"Courier New"> <o:p></o:p></FONT></FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>datafile=3D`mktemp`</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
size=3D2><FONT=20
face=3D"Courier New"> <o:p></o:p></FONT></FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>echo "1234567 Line 1" >> $datafile</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>echo "2345678 Line 2" >> $datafile</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>echo "3456789 Line 3" >> $datafile</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
size=3D2><FONT=20
face=3D"Courier New"> <o:p></o:p></FONT></FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>suprtool << !EOD</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>input<SPAN style=3D"mso-spacerun: yes"> =20
</SPAN>$datafile,rec 14,lf</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>define<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>key<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>,1,7</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>define<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>line<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>,8,7</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>extract<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>key</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>extract<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>line</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>list<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>standard</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>exit</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>!EOD</FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
size=3D2><FONT=20
face=3D"Courier New"> <o:p></o:p></FONT></FONT></P>
<P class=3DSource style=3D"MARGIN: 0pt 0pt 0pt 144pt"><FONT =
face=3D"Courier New"=20
size=3D2>rm $datafile</FONT></P></DIV>
<H3 style=3D"MARGIN: 17pt 0pt 0pt 144pt"><FONT face=3DArial =
size=3D5>Missing=20
Features</FONT></H3>
<P class=3DMsoBodyText style=3D"MARGIN: 5.75pt 0pt 0pt 144pt"><FONT =
size=3D2>The=20
following Suprtool features on MPE are currently not available in=20
Suprtool/UX:</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Extracting a range of fields from an SQL=20
database</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Export command (STExport exists as a =
separate=20
program)</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Hints are not available</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Link command (Suprlink exists as a =
separate=20
program)</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Table Command with the File option =
requires that=20
the file being loaded is self-describing.</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Out=3D option of the Listredo =
command</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Output Ask, Num,Key, and =
Num,Query</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Output Temp (There are no temporary files =
in=20
HP-UX)</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-FAMILY: Symbol"><FONT size=3D2>·</FONT><SPAN=20
style=3D"FONT: 7pt 'Times New =
Roman'"> =20
</SPAN></SPAN><FONT size=3D2>Output =3DInput</FONT></P>
<P class=3DMsoList=20
style=3D"MARGIN: 5.75pt 0pt 0pt 198pt; mso-list: l28 level1 lfo167; =
tab-stops: list 198.0pt"><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; =
mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN=20
class=3D809403315-06022004> =20
</SPAN>Totals to a file</SPAN></P></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
robelle-l-admin@robelle.com =
[mailto:robelle-l-admin@robelle.com]<B>On Behalf=20
Of </B>Rahul.Singh@Lntinfotech.com<BR><B>Sent:</B> Friday, February =
06, 2004=20
9:03 AM<BR><B>To:</B> robelle-l@robelle.com<BR><B>Subject:</B> =
[Robelle-l]=20
Mapping information on Suprtool(MPE) commands to Suprtool(HP-UX)=20
commands.<BR><BR></FONT></DIV><BR><FONT face=3Dsans-serif =
size=3D2>Hi=20
Neil!</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>I am involved =
in HP3000=20
migration and HP9000 is a target platform under =
consideration.</FONT>=20
<BR><FONT face=3Dsans-serif size=3D2> </FONT><BR><FONT =
face=3Dsans-serif=20
size=3D2>I appreciate your help to get the following =
information.</FONT>=20
<BR><BR><FONT face=3Dsans-serif size=3D2>Are there any diferences in =
operations,commands or syntaxes between Suprtool on MPE and the same =
on=20
HP-UX ?</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>If yes then =
we would be=20
grateful if you could kindly provide us with the direct mapping of =
commands=20
or syntaxes of Suprtool mpe commands to hpux commands. =
</FONT><BR><BR><FONT=20
face=3Dsans-serif size=3D2>Thanks.</FONT> <BR><BR><FONT =
face=3Dsans-serif=20
size=3D2>Rahul.</FONT></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
=00
------_=_NextPart_001_01C3ED3D.2D9B934B--