Contents
Introducing
Suprtool Version 5.2.12 5
Overview......................................................................................................................... 5
Highlights in
Suprtool 5.2.12........................................................................................ 5
Highlights in
Suprtool 5.2.11........................................................................................ 5
Highlights in
Suprtool 5.2.10........................................................................................ 6
Highlights in
Suprtool 5.2............................................................................................. 6
Highlights in
Suprtool 5.1.02........................................................................................ 6
Known Problems............................................................................................................ 8
Itanium vs PA_RISC....................................................................................................... 8
Compatibility................................................................................................................ 10
Itanium
Compatibility................................................................................................. 11
CPU Serial Number (uname)...................................................................................... 12
Documentation............................................................................................................. 12
Installation 13
Overview....................................................................................................................... 13
Installation Instructions.............................................................................................. 13
Installation Assistance................................................................................................ 13
Enhancements in
Version 5.2.12 14
Introduction.................................................................................................................. 14
Add Command.............................................................................................................. 14
Enhancements in
Version 5.2.10 15
Introduction.................................................................................................................. 15
SpaceNull...................................................................................................................... 15
PassShift........................................................................................................................ 15
Enhancements in
Version 5.2 16
Introduction.................................................................................................................. 16
ZonedFix....................................................................................................................... 16
PassShift........................................................................................................................ 16
Itanium........................................................................................................................... 16
Enhancements in
Version 5.1.01 17
Introduction.................................................................................................................. 17
Debug Information....................................................................................................... 17
$stddate($days(a))....................................................................................................... 17
Z type TPI-keys............................................................................................................ 17
J type TPI-keys............................................................................................................. 18
Userlabels...................................................................................................................... 18
Outcounts...................................................................................................................... 18
VarsubDebug................................................................................................................ 18
VarsubCompat.............................................................................................................. 19
IF $lookup..................................................................................................................... 19
Multiple Literal
Compares.......................................................................................... 20
Bugs Fixed 21
Bugs Fixed In
Suprtool 5.2.11.................................................................................... 21
Bugs Fixed In
Suprtool 5.2......................................................................................... 21
Bugs Fixed In
Suprtool 5.1.02.................................................................................... 21
Bugs Fixed In
Suprtool 5.1.01.................................................................................... 21
Bugs Fixed In
Suprtool 5.1......................................................................................... 22
Bugs Fixed In
Suprtool 5.0.15.................................................................................... 22
Bugs Fixed In
Suprtool 5.0.14.................................................................................... 22
Bugs Fixed In
Suprtool 5.0.13.................................................................................... 22
Bugs Fixed In
Suprtool 5.0.12.................................................................................... 22
Bugs Fixed In
Suprtool 5.0.11.................................................................................... 23
Bugs Fixed In
Suprtool 5.0.10.................................................................................... 23
Use Suprtool/AMXW to read, select, and
sort data from Oracle, Allbase and Eloquence databases and data files with
fixed-length records. Suprtool/AMXW is designed to be similar to Suprtool for
MPE while providing necessary HP-UX features.
Suprlink/AMXW provides high-speed
data-file linking based on a sort key. Use STExport to convert fields in a
self-describing input file into an output file that can be imported into
different applications.
Suprtool 5.1.03 and Suprtool 5.1.04 were
internally released only as part of our Alpha version and Beta versions of the
new Native Itanium versions of our products.
·
The Add command which adds an
input file to an Oracle table now allows for the syntax of ownername.tablename.
·
Suprtool would fail with Stack
Overflow message or simply fail when loading a table with the sorted option if
the key data type was a double-integer, small integer or small logical.
(Itanium only)
·
An extract operation where the
target was a single integer and the source was a double integer would not work
properly. (Itanium only)
·
Set Oracle SpaceNull On has
been added to control if byte, char and date fields which if Null will have
nulls as data or spaces. If SpaceNull is
on, then spaces will be placed in the fields. If SpaceNull is off then the
field will contain nulls.
·
Suprtool did not properly
coerce data from Packed to Quad integer when using Set Ifouroutput on and Set
Oracle Integer on. (Itanium only)
·
Set Oracle Passshift Off now
turns off password upshift for the oneline syntax method when you are including
the service name.
·
STExport now has Set ZonedFix
On, this setting can be used to zero out any zoned fields that were unable to
be converted from zoned to byte and typically have a "?" in the
result. This is often caused by hidden characters or bad data.
·
Suprtool now has Set Oracle
PassShift On (default) or Off to turn off the upshift of a password. This is to
accomodate Oracle 11 which will allow for case-sensitive passwords.
·
The Add command in Suprtool for
HP-UX would cause a subsequent task to fail in some cases.
·
The Add command in Suprtool for
HP-UX would fail if the target was a small record.
·
Suprtool, STExport, Suprlink
and Suprcall are all available as a Native Itanium binaries
·
The Base command would not pass
the database name to be parsed if it was preceded by a command without any
parameters. (Itanium Build 2)
.
·
The $edit function would
replace a numeric with a colon if the edit mask had a different number of
decimal places than the item had and the last number to be rounded was a nine..
·
Suprtool chain command now
handles J2 TPI keys in Master datasets.
·
Suprtools Table command would
fail with Error: Sorted file is not in the correct sequence, in some cases.
·
Open Oracle could not parse a
machine name with a “.” in the name.
·
Open Oracle now correctly
parses three tokens in the Open command.
·
Total $file did not work
properly in Suprtool for AMXW.
·
KSAM input files were not
opened with ;shr;lock.
·
STExport did not handle files
with 256 fields in an SD file.
·
Suprtool for AMXW would not
close the previously opened database when a new base command was issued with
database name.
·
Suprtool can now execute the if
and extract expression $stddate($days(a) + 10) in one task.
·
Suprtool for AMXW would abort
when trying to get file system error messages from AMXW intrinsics.
·
Suprtool now supports stand
alone zoned decimal TPI-keys.
·
Suprtool for AMXW build version
had a conflict with the Dateline
intrinsic.
·
Suprlink and STExport had an
issue detecting the AMXW shell with some versions of AMXW.
·
Suprtool, STExport and Suprlink
all set the outcount variables by default just like they do on MPE.
·
Set UserLabels on now works in
Suprtool for AMXW just like it does in the MPE version.
·
Set Filecode 0 will work if Set
UserLabels is set to off.
·
Reset Output would not properly
reset the output filename in HP-UX and AMXW versions of Suprtool.
·
Set stat on did not look at the
correct flag when being parsed.
·
Suprtool would fail with
Fgetinfo failure when output is to stdlist (out *) and a sort is specified.
·
Suprtool for AMXW would use the
file size stored in the SD label as opposed to the actual physical file size
that AMXW uses.
·
Suprtool would not abort nor
return an error message when the AMXW FPOINT intrinsic would fail when trying
to append to an output file greater than 2Gb. Suprtool now aborts with an error
message and Speedware has fixed FPOINT to work with files > 2Gb.
·
If the data item used in data
portion of a $lookup function was 8
bytes or greater in length, type display or byte, the if command would fail
with an arithmetic stack error.
·
Set VarsubCompat did not work
in STExport and the default was set to on.
·
Set VarsubDebug has been added
to print the line after variable substitution has occurred.
·
Suprlink and STExport can now
be run with –cv argument to turn on the VarsubCompat Flag.
·
Error handling has been
improved when creating or opening large files in STExport and Suprlink. (AMXW
only)
·
STExport XML command did not
convert compound items (2)..(n) properly.
·
Multiple literal compares now
work in the if command.
·
If $lookup can now return the
data portion loaded into a table to use in a comparison.
·
Suprtool for HP-UX would
fail with a DBGET failure on a directed
read if fastread was on and if the record number specified did not have a
record in the slot previous to the start record number.
·
Suprtool2 would fail to detect
the ROBSUPR variable even if set in some cases.
·
Suprtool would not get the
proper records size and foptions from FOPEN/FGETINFO of SUPRLIST under AMXW.
If you have any questions or concerns or
feedback on this or any other issue, please feel free to e-mail me at: neil@robelle.com
There are two types of machines that HP
has that run HP-UX, the older machines are based on the PA_RISC chip and the
new machines that use the Itanium (and Itanium 2 chips). There are also program
files that are specific to each chip. PA_RISC programs can run on both PA_RISC
and Itanium machines, however, Itanium programs can only run on Itanium
machines.
Any program that runs on Itanium must
utilize libraries that match its own program type. Therefore if a PA_RISC
program runs on Itanium and looks for a library, it must find/load the PA_RISC
version of the libraries that it needs and conversely an Itanium program must
load the libraries specific to its type.
How
to Tell what Machine I am on?
There are many ways to tell what kind of
machine you are on, here are a couple:
uname -m
getconf MACHINE_MODEL
In each case the Itanium machine will
typically say ia64 somewhere in the result of the above two commands. PA_RISC
machines typically say "9000" somewhere in the string.
What
is the Program File Type?
Since there are two types of machines
there are also at least two types of program files. Suprtool is primarily either
PA_RISC 1.1 or ELF-32 / IA64 which is also known as Itanium. To determine the
type of program file you can use the file command:
Itanium
file suprtool
suprtool: ELF-32 executable object file - IA64
PA_RISC
file suprtool
suprtool: PA-RISC1.1 executable dynamically linked
-not stripped
The PA_RISC binary can run on both
platforms but you need to have PA_RISC libraries for Eloquence or Oracle if you
are using the Oracle module. An Itanium binary will not run on a PA_RISC
machine and will fail with "cannot execute".
Of
course we've made provision to identify if you are running the ia
version of Suprtool in the banner and verify command with the ia after the UX :
SUPRTOOL/UXia/Copyright
Robelle Solutions Technology Inc. 1981-2009.
(Version 5.2 Internal) MON, JUN
8, 2009, 11:26 AM Type H for
help.
PA_RISC
Loading
Suprtool by default looks in the
libraries in any of the directories named in SHLIB_PATH. For example to insure that Suprtool resolves
the library loads you can set the SHLIB_PATH
system wide in your /etc/profile file in the following manner:
export
SHLIB_PATH=/opt/eloquence6/lib/pa11_32:/opt/oracle/lib
If you do not have the SHLIB_PATH
variable set to a value where the libraries can be found, Suprtool will then
try to load from their default names locations.
For Eloquence the default location is :/opt/eloquence6/lib/pa11_32.
The Oracle interface will first try to
load libclntsh.so and then attempt to load libclntsh.sl from
$ORACLE_HOME/lib32/libclntsh.sl.
Itanium
Loading
You can change Suprtool to pay attention
to LD_LIBRARY_PATH and use dlopen to load libraries, you can set the
environment variable:
export ROBELLE_DYN_LOAD
=Y.
It is generally advisable to use DLOPEN
or the ROBELLE_DYN_LOAD option when using the Itanium version. The PA_RISC
version of Suprtool can use either type
of loading, the default or the dlopen method invoked with ROBELLE_DYN_LOAD.
Running
the PA_RISC version on Itanium:
You can of course run the PA_RISC version
of Suprtool, however, given that the PA_RISC version requires SHLIB_PATH to
point to PA_RISC libraries may go against the configuration necessary for other
programs that may need SHLIB_PATH to point to Native Itanium libraries.
The solution to this is fairly simple,
you can create a command file that runs suprtool for you let's say
/opt/robelle/cmd/suprtool, you of course need to insure your path variable has
/opt/robelle/cmd before /opt/robelle/bin:
You can then have the following commands
in the /opt/robelle/cmd/suprtool command file:
export SAVED_SHLIB_PATH=$SHLIB_PATH
export
SHLIB_PATH=/opt/oracle/pa_risc/lib:/opt/eloquence/lib/pa11_32
/opt/robelle/bin/suprtool
$@
export
SHLIB_PATH=$SAVED_SHLIB
Essentially all it does save the current
SHLIB_PATH setting, sets it to point to PA_RISC libraries, runs suprtool and
then resets the library back.
Suprtool
for Itanium
Now that you know all about PA_RISC and
Itanium you do need to be aware of what Suprtool forItanium is in terms of new
code and risk for potential issues. Suprtool for Itanium is completelyin C code.
This does not mean that it is all new C code however, the majority of the
Suprtool code is still based on SPL, but is converted to C, using Allegros
SPLASH compiler.
So while the C code is new it is based on
the original SPLash code, however, given differences betweenC and SPLash not
all code can be automatically converted in some cases. We worked closely with
Allegro to find ways to have the source code work and address the various
issues that came up, the entire time Allegro improved the SPLash to C converter.
So while we are based on the original
Suprtool we do have new code paths in the Native Itanium version and other
potential issues where the C code might not work in exactly the same manner as
the SPLash code.
Having said that we have tested this against
our test suites, and improved and added a large number of tests to our HP-UX
test suites. We also began Alpha testing 18 months ago and have been beta
testing for the last six months with our two best VAR customers.
Suprtool for AMXW would use the file
size stored in the SD label as opposed to the actual physical file size that
AMXW uses.
::FILE
FILE80;REC=-80,,F,ASCII
::supramxw
SUPRTOOL/AMXW/Copyright Robelle Solutions Technology Inc.1981-2007.
(Version 5.0) TUE, JAN
08, 2008, 2:42 PM
Type H for help.
>I STFILE
>DEF ABCXYZ,1,11
>EXT ABCXYZ
>O FILE80,LINK
>X
IN=26, OUT=26. CPU-Sec=1. Wall-Sec=1.
>FO FILE80
File: FILE80 (SD Version B.00.00) No linefeeds
Entry:
Offset
ABCXYZ
X11 1
Limit: 1023 EOF: 26 Entry Length: 11 Blocking: 1
>E
::LISTF FILE80,2
ACCOUNT=
AMXWQA GROUP= FDE
FILENAME
CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP
EOF LIMIT R/B SECTORS #X MX
FILE80
1084 82B
FA
26 1023
1 9 1 *
So what happens is if an output link
file is created with a file equation making the file bigger, any subsequent
files that are created from the resulting output file are actually made smaller
as you can see below.
::supramxw
SUPRTOOL/AMXW/Copyright Robelle Solutions Technology Inc.1981-2007.
(Version 5.0) TUE, JAN
08, 2008, 2:42 PM
Type H for help.
>i FILE80
>O FILE80A
>X
Warning: Using Output FILE80A,Link
IN=26, OUT=26. CPU-Sec=1. Wall-Sec=1.
>E
::LISTF FILE80A,2
ACCOUNT=
AMXWQA GROUP= FDE
FILENAME
CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP
EOF LIMIT R/B SECTORS #X MX
FILE80A
1084 11B
FA
26 1023
1 2 1 *
Suprtool for AMXW now honours
the physical record size and the FILE80A file will now have a record size of
80.
The HP-UX and AMXW versions of AMXW no
longer have Set varsubcompat on as the default.
The default is now off and can be turned on with the set command or the
–cv option.
Previously, Suprtool would treat an “R”
type field in an Eloquence database as an R type while the data inside
Eloquence is stored and treated as IEEE
therefore incorrect results would occur with coercions and arithmetic
operations. Suprtool now by default maps all Real and Long fields to their
respective IEEE fields. You can change Suprtool back to the previous
behaviour with Set RealMap Off.
A form command will still show the fields
as being “R2” or “R4”, but internally Suprtool will treat as IEEE, which is how
Eloquence stores and treats the numbers.
Consequently STExport will now support
items in SD files that are condidered R type, however it correctly will map
them to IEEE.
Suprtool/UX 5.0 is now compatible
with,all versions of HP-UX 11.2x, as well as Oracle version 8 and higher.
Suprtool/UX version 4.8.02 and lower is
compatible with HP-UX 9.0 and higher and Oracle 7.
Fastread option is now set to On for
Suprtool for HP-UX the regular version. The Dynamic loading version of Suprtool
has a default value of off to start.
Suprtool 5.2 is necessary for use with
Oracle 11 and case sensitive passwords.
There are a couple of differences in the
Itanium version of Suprtool, which you need to be aware of.
The
DBEdit module is not available in the Itanium versions of Suprtool. This module
is invoked by the EDIT command.
The
layout for the Verify command is slightly different then the PA-RISC versions
of Suprtool.
This program runs only on CPUs whose
serial numbers have been encoded (the "uname" on HP-UX). If it fails
to run and you get an "invalid HPSUSAN" error message, contact
Robelle for assistance, via support@robelle.com
or the support number at 1-800-453-8970.
The
user manual contains the full description of all the Suprtool suite of products
including Dbedit, Suprlink, STExport, and Suprtool2, as well as usage tips and
commands for each. The manuals are up-to-date with all the latest changes. To
see only the changes in the latest version, see the "What's New"
section of the manual.
You
can download our manuals and Change Notices in various formats and order
printed (hardcopy) manuals from our web site at:
http://www.robelle.com/library/manuals/.
The following instructions describe the
installation process of a new Suprtool release. The new version overwrites an
existing version of Suprtool on your HP-UX system.
There are typically two main types of
installations. You can find the Suprtool for AMXW regular install instructions
here:
http://www.robelle.com/downloads/install-amxwpre.html
You can find the Suprtool for AMXW build
on your system instructions on the link below. You will need this install if
you are going to require the KSAM option, Dynamic Image loading or Omnidex
support, or intend to run on Itanium:
http://www.robelle.com/downloads/install-amxwbuildpre.html
If you have any questions or run into any
problems, please call us. Technical support is available on weekdays from 8 a.m. to 4 p.m. Pacific time at 1.800.453.8970. Technical
support can also be obtained via e-mail at: support@robelle.com If your new version of software will not run,
you can page someone from technical support by calling the 1.800 number, or you
can typically easily run extend with the disaster option to tide you over until
business hours. Instructions for this are available at:
http://www.robelle.com/disaster/
by calling the 1.800 number, or you can
typically easily run extend with the disaster option to tide you over until
business hours. Instructions for this are available at:
http://www.robelle.com/disaster/
Suprtool
is constantly being updated with new features. The following section describes
the new enhancements to Suprtool since Suprtool 5.2.10
The Add command which allows for adding
data to an Oracle table now allows for the syntax of Ownername.Tablename. The
single syntax of just giving the table name will work as it always has.
Suprtool
is constantly being updated with new features. The following section describes
the new enhancements to Suprtool since Suprtool 5.2
Suprtool has a new setting called Set
Oracle SpaceNull, which when on puts spaces in any byte, Char or Date (Oracle
Date) fields instead of the nulls. The default behaviour is off.
Suprtool now has the command Set Oracle
PassShift Off which turns off the default behaviour of upshifting Oracle
passwords. This is to accomodate Oracle 11 which allows case sensitive
passwords. The first pass on this was to allow the syntax of:
open oracle suprtest
suprpass
We
now honour Set Oracle PassShift for the syntax that includes the service name:
open oracle
suprtest/suprpass@servname
Suprtool
is constantly being updated with new features. The following section describes
the new enhancements to Suprtool since Suprtool 5.0.
STExport now has Set ZonedFix On, this
setting can be used to zero out any zoned fields that were unable to be
converted from zoned to byte and typically have a "?" in the result.
This is often caused by hidden characters or bad data.
Suprtool now has the command Set Oracle
PassShift Off which turns off the default behaviour of upshifting Oracle
passwords. This is to accomodate Oracle 11 which allows case sensitive
passwords.
Suprtool, STExport and Suprlink are now
available as Native Itanium. This represents a complete conversion of all
Suprtool code to the C language. This version has many of the same components,
with the exception of Dbedit. This conversion allows us to port to other
platforms such as AIX and other big endian platforms. If you are interested in
a particular platform please contact neil@robelle.com.
Suprtool
is constantly being updated with new features. The following section describes
the new enhancements to Suprtool since Suprtool 5.0.
Suprtool
will now print out the entire table data structure information if a failure
occurs when trying to close the mapped table space.
Suprtool
now allows for the $days function to be nested in the $stddate function.
ext a=$stddate($days(a) + 1)
list
xeq
>IN TEST.GROUP.ACCOUNT (0) >OUT $NULL (0)
A = 20080319
Suprtool
now supports stand-alone Zoned-decimal TPI-keys, for Omnidex, Superdex and
Eloquence. Previously Suprtool only supported byte type keys. Suprtool now
supports stand-alone “Z” type keys, Suprtools form command will show the keys
that it can support via the chain command.
setjcw sicognos 1
form d-inventory
Database:
STORE.SUPRTPIS.GREEN TPI: SUPERDEX
(010566) 4.2.11.2
D-INVENTORY Detail Set# 4
Entry: Offset
BIN-NO J1 1
LAST-SHIP-DATE J2
3
ON-HAND-QTY J2 7
PRODUCT-NO Z8 11
(M-PRODUCT)
<<TPI>>
SUPPLIER-NO Z8
19 (!M-SUPPLIER)
UNIT-COST P8 27
ITEM-DESC1 X20 31
<<TPI>>
ITEM-DESC2 X20 51
ITEM-DESC3 X20 71
ITEM-DESC4 X20 91
Capacity: 464 (8) Entries: 13
Highwater: 13 Bytes: 110
Additional Third-Party Indexes:
SI-PRODUCT-NO Z8
B
SI-ITEM-DESC1 X20
B
SI-ITEM-DESC1234 X80
B
SHAD X10 B
Suprtool
now supports J-type TPI-keys, for Omnidex, Superdex and Eloquence. Previously
Suprtool only supported byte type keys. Suprtool now supports stand-alone “J”
type keys, Suprtools form command will show the keys that it can support via
the chain command.
Set
UserLabels On | Off had no effect in Suprtool for AMXW. It now works just like
it does on MPE.
Suprtool,
STExport and Suprlink set their respective outcount variables on AMXW just as
they do in MPE, in addition if the products are run with the –oc option, the
traditional files of .stoutcount, .sxoutcount and .sloutcount are updated with
the number of records written to the output file.
Suprtool,
STExport and Suprlink now have a setting called Set VarsubDebug on which will
print out the line after the variable substitution has occurred. This setting
only works if Set Varsub is on and Set varsubdebug is on.
setvar outfile &
:"/GREEN/SUPRTEST/filename90123456789012345678901234567890123456789012345678901"
:run
suprtool.pub.robelle
SUPRTOOL/iX/Copyright
Robelle Solutions Technology Inc. 1981-2007.
(Version 5.0.11
Internal) TUE, OCT 30, 2007, 2:58
PM Type H for he
>set varsub on
>set varsubdebug on
>in
file1sd.suprtest
vd:in file1sd.suprtest
>output
!outfile,link,temp
vd:output
/GREEN/SUPRTEST/filename90123456789012345678901234567890123
vd:2345678901,link,temp
The
output is formatted into 74 byte chunks and printed with a preceding “vd:” so
the “substituted” line is clear.
STExport
and Suprlink can now be run with the –cv option which will turn on the
varsubcompat flag without having to use the set command.
Suprtools
IF command is now able to use the “data” loaded into a Table. The $lookup
function will return the data value from the table to compare against another
field or literal.
In file1sd
Table
mytable,char-field,data,tabfile,data(id-field)
If
$lookup(mytable,char-field,id-field) = int-field
So
what Suprtool will do in this case is read a record, lookup the record in the
table and retrieve the data item in the table. If Suprtool does NOT find an
entry in the table, a zero will be returned if the data type is numeric and
spaces will be returned if it is a byte type.
So
using the case above, if no entry is found in the table, zero is returned, and
if int-field is equal to zero, then the record will qualify.
If you don’t want to have any values
returned from the table lookup, you just preface the if with a standard lookup.
>get ord-details
>table cust-table, cust-no, file,
custlist,data(state-code)
>if $lookup(cust-table,cust-no) and &
$lookup(cust-table, cust-no,
state-code) = state-code
>output orders
>xeq
When using $lookup to return data, the
$lookup must always be on then left side of the expression. If not Suprtool
will stop with an error:
>if id-field=$lookup(mytable,char-field,id-field)
Error:
$lookup in this context (data comparison) must be on left side
Suprtool
can now do multiple literal comparisons, previously Suprtool was only able to
compare two sets of literals.
If “a” = “a” and “b” =
“b”
If “a” <> “b”
and “b” <> “c”
Extract. Suprtool did not
properly coerce a double integer into a single integer.
Table Sorted. Suprtool
would fail with a Stack Overflow or simply fail when using the Table command
with the sorted option if the key value was a double integer, single integer or
a single logical.
SPECIAL. The if command
would fail with and error if a field started with the SPECIAL keyword and if
the field was on the right side of the equation.
BASE Command. The Base
command would not parse the database name if it was preceded by a command that
did not have any parameters and a previous database was open. (Itanium Build 2)
Edit
Function. The $edit function would replace a
numeric with a colon if the edit mask
had a different number of decimal places than the item had and the last
number to be rounded was a nine..
Table
Command. Suprtools Table command would fail with
Error: Sorted file is not in the correct sequence, in some cases.
Chain command. Suprtool
chain command now handles J2 TPI keys in Master datasets.
Open Command. Open Oracle
could not parse a dbname@machine name with a “.” in the name.
Open Command. Open Oracle
did not correctly parses three tokens in the Open command when each token was
separated by spaces.
List
Command. Suprtool would not get the proper records
size and foptions from FOPEN/FGETINFO of SUPRLIST under AMXW. This would cause
the List command to fold lines at column 80.
Total
Command. Total $file did not work properly in
Suprtool for AMXW.
Input Command. KSAM input files were not opened with
;shr;lock.
STExport. STExport did not
handle files with 256 fields in an SD file.
Base Command. Suprtool for AMXW would not close the previously open database if
a database name was specified on the base command.
File System errors. Suprtool for AMXW would fail when attempting to get a file system
error message from AMXW.
Dateline Intrinsic. Suprtool for AMXW build version had a conflict with Dateline
intrinsic in a future version of AMXW.
AMXW Shell.
Suprlink and STExport had an issue detecting the AMXW shell in some versions of
AMXW.
Set Filecode. Set Filecode 0 will work if Set UserLabels is set to off.
Reset Output. Reset Output would not properly reset the output filename in HP-UX
and AMXW versions of Suprtool.
Set Stat on. Set stat on did not look at the correct flag when being parsed.
Output to Stdlist. Suprtool would fail with Fgetinfo failure when output is to stdlist
(out *) and sort is being utilized.
Record Size. Suprtool for AMXW would use the file size stored in the SD label as
opposed to the actual physical file size that AMXW uses. See the compatibility
section for more information.
Fpoint. Suprtool
for AMXW did not properly error check on the FPOINT call when appending to an
output file.
$lookup with data. If the data item used in data portion of a $lookup function was 8 bytes or greater in
length, type display or byte, the if command would fail with an arithmetic
stack error.
VarsubCompat. Set VarsubCompat did not work in STExport and the default was set to
on.
Error handling. Error handling has been improved when creating or reading large
files in STExport and Suprlink.
Fastread.
Suprtool for HP-UX would fail with a DBGET failure on a directed read if
fastread was on and if the record number specified did not have a record in the
slot previous to the start record number.
XML. STExport did not
properly convert compound items other than the first occurrence.
Suprtool2. Suprtool2 would fail to detect the ROBSUPR variable even if set in
some cases.
