The current production version for Suprtool is version 5.2. (Released June 23, 2009)
Suprtool 5.2 MPE
STExport has a new feature to handle bad Zoned data. See Set ZonedFix On.
Various bugs in byte addressing and memory management have been uncovered
and addressed.
The $edit function now supports the colon as a delimeter character for
time edit masks.
Suprtools if command would not recognize a field starting with SPECIAL if
it was on the right side of the equation.
Suprtool 5.2 HP-UX
STExport has a new feature to handle bad Zoned data.
The $edit function now supports the colon as a delimeter character for time edit masks.
Suprtools if command would not recognize a field starting with SPECIAL if
it was on the right side of the equation.
Suprtool is now available is now native Itanium, in all flavours.
Suprtool for HP-UX, Suprtool with dynamic loading and Suprtool for AMXW.
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 5.2 AMXW
STExport has a new feature to handle bad Zoned data.
The $edit function now supports the colon as a delimeter character for time edit masks.
Suprtools if command would not recognize a field starting with SPECIAL if
it was on the right side of the equation.
Suprtool is now available is now native Itanium, in all flavours.
Suprtool for HP-UX, Suprtool with dynamic loading and Suprtool for AMXW.
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 can now execute the if and extract expression $stddate($days(a) + 10) in one task.
STExport did not handle files with 256 fields in an SD file.
Suprtool now Supports Indexes and Third-Party Indexes that have a type of Z.
Suprlink has had some internal changes, mainly in terms of some of it's data structures and information about the link file(s).
Set stat on did not look at the correct flag when being parsed.
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 now reads NM KSAM files with MR NOBUF if an IF command is specified. (MPE only)
STExport HTML command did not calculate the maximum record size properly in some cases. (MPE only)
Suprtool chain command now handles J2 TPI keys in Master datasets.
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 5.1.02 HP-UX (Released : October 2, 2008)
Suprtool can now execute the if and extract expression $stddate($days(a) + 10) in one task.
Support for extended names in Suprtool and Suprlink.
STExport did not handle files with 256 fields in an SD file.
Suprtool for HP-UX and AMXW would not close the previously opened database when a new base command was issued with database name. (HPUX/AMXW only)
Suprtool now Supports Indexes and Third-Party Indexes that have a type of Z.
Suprlink has had some internal changes, mainly in terms of some of it's data structures and information about the link file(s).
Set stat on did not look at the correct flag when being parsed.
Suprtool now allows you to specify the "lp" program by setting the variable ROBELLE_LP. (HP-UX)
Reset Output would not properly reset the output filename in HP-UX and AMXW versions of Suprtool. (HP-UX, AMXW)
Set VarsubCompat did not work in STExport and the default was set to on
incorrectly.
Set VarsubDebug has been added to look at the line after variable
substitution has occured.
Suprlink and STExport can now be run with -cv argument to turn on the
VarsubCompat flag. (HP-UX and AMXW)
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. (HP-UX only)
Suprtool2 would fail to detect the ROBSUPR variable even if set in some cases. (AMXW only)
Suprlink had trouble with linking two files with the new SD Extended information in some cases.
Open Oracle could not parse a machine name with a “.” in the name.
Suprtool chain command now handles J2 TPI keys in Master datasets.
Open Oracle now correctly parses three tokens in the Open command.
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 5.1.02 AMXW (Released : October 2, 2008)
Suprtool can now execute the if and extract expression $stddate($days(a) + 10) in one task.
Total $file did not work properly in Suprtool for AMXW. (AMXW)
KSAM input files were not opened with ;shr;lock. (AMXW)
Suprtool for HP-UX and AMXW would not close the previously opened database when a new base command was issued with database name. (HPUX/AMXW only)
Suprtool now Supports Indexes and Third-Party Indexes that have a type of Z.
Suprtool for AMXW would abort when trying to get file system error messages from AMXW intrinsics.
Suprlink has had some internal changes, mainly in terms of some of it's data structures and information about the link file(s).
Set stat on did not look at the correct flag when being parsed.
Reset Output would not properly reset the output filename in HP-UX and AMXW versions of Suprtool. (HP-UX, AMXW)
Suprtool for AMXW build version had a conflict with the Dateline intrinsic. (AMXW)
Suprlink and STExport had an issue detecting the AMXW shell with some versions of AMXW. (AMXW)
Suprtool, STExport and Suprlink all set the outcount variables by default just like they do on MPE. (AMXW)
Set UserLabels on now works in Suprtool for AMXW just like it does in the MPE version. (AMXW)
Set Filecode 0 will work if Set UserLabels is set to off. (AMXW)
Suprtool would fail with Fgetinfo failure when output is to stdlist (out *) and a sort is specified. (AMXW)
Suprtool for AMXW would use the file size stored in the SD label as opposed to the actual physical file size that AMXW uses. (AMXW)
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. (AMXW)
Error handling has been improved when creating or opening large files. (AMXW-only)
Set VarsubCompat did not work in STExport and the default was set to on
incorrectly.
Set VarsubDebug has been added to look at the line after variable
substitution has occured.
Suprlink and STExport can now be run with -cv argument to turn on the
VarsubCompat flag. (HP-UX and AMXW)
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. (AMXW only)
Suprlink had trouble with linking two files with the new SD Extended information in some cases.
Open Oracle could not parse a machine name with a “.” in the name.
Suprtool chain command now handles J2 TPI keys in Master datasets.
Open Oracle now correctly parses three tokens in the Open command.
Suprtools Table command would fail with Error: Sorted file is not in the correct sequence, in some cases. (AMXW only)
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 Version 5.0
MPE
Set InitExtents setting has been added to reduce the size of the extent
B-trees for some systems. Keep in mind that this will increase the size of the
chunks that it needs to have for large files. (4.9.05)
Suprtool had some internal messages printing out on stdlist when the Table command was used. (4.9.04)
Set Itemlock command has been added to support Item level locking. (4.9.04)
Update from a table would incorrectly update records with spaces if the record was not found. (4.9.04)
HP-UX
Suprtool for HP-UX now has a set command called Set HPUXCMDERR
that will allow you to configure which commands are not considered fatal
errors when running in batch.(4.9.06)
The $split function would abort on some systems if the $split character
was the last character in the string. (4.9.06)
Ground work has been done in Suprtool to support longer fieldnames in
self-describing files. This feature is being added to the next version of
Suprlink and then it will be released. (4.9.05)
Suprtool for HP-UX and AMXW had some timer call information disabled
which meant that progress messages have incorrect Wall time statistics. (4.9.05)
Suprtool for HP-UX would occasionally fail with mmap errors in some environments.(4.9.04)
The Base command on it’s own did not close the current database like it did on MPE.(4.9.04)
Suprtool for AMXW would fail with a dbstatus 17, No current record found when doing an update or delete operation with Set Fastread on and Set Lock 0.(4.9.04)
Set varsubcompat flag has been added to control how variable substitution behaves on HP-UX.(4.9.04)
STExport would fail if the input file did not have any line feeds and the XML command would in effect.(4.9.04)
Oracle load warning messages are no longer printed by default.(4.9.04)
Dynamic loading of Oracle and Eloquence libraries is improved.(4.9.04)
Suprtool would abort if an invalid password was specified in some cases.(4.9.04)
AMXW
The $split function would abort on some systems if the $split character
was the last character in the string. (4.9.06)
In Suprtool for AMXW the Base command would fail on the dynamic loading
version if Eloquence was not installed. (4.9.06 Build 1)
If the Eloquence and Oracle libraries are not loaded the Base and
Open commands will print an error saying that the appropriate libraries
were not loaded when the Base and Open commands are entered.
Previously, Suprtool would simply abort. (4.9.06 Build 2)
Suprtool for AMXW would not initialize the filecode to zero if the
input file was self-describing and the output option was ascii, prn or
display. (4.9.06 Build 2)
Suprtool, STExport and Suprlink for AMXW did not handle duplicate filenames
for permanent and/or temporary files in all cases.
Suprtool for AMXW dynamic loading version did not work for those sites that
did not have the Eloquence routines. (4.9.05)
Suprtool for AMXW did not support input filename(2/), where Suprtool starts to read at a particular record number until this version.(4.9.04)
Suprtool for AMXW now supports the Numrecs command to control the size of the output file.(4.9.04)
Suprtool for AMXW does variable substition in the same manner as the HP-UX version. Suprtool for AMXW first tries to resolve variables set on HP-UX and are available as an environment variable. Then any command that uses a “!” MPE variable, will be resolved next.(4.9.04)
Stexport Output command would fail as the byte size was assumed to be words, incorrectly.(4.9.04)
The latest AMXW version of Suprtool2 would interfere with some Cobol programs if they attempted to open a KSAM file.(4.9.04)
STExport did not support temp file creation in the AMXW version.(4.9.04)
STExport would core abort when trying to input a file did not exist.(4.9.04)
STExport did not produce Variable length files by default as it did on MPE.(4.9.04)
Suprtool would occasionally fail with mmap errors on HP-UX when using the Table command.(4.9.04)
Output, erase was not working properly in STExport and Suprlink.(4.9.04)
Files that had a size in words would not get linked properly in Suprlink and the Table file might assume an incorrect size.(4.9.04)
Suprtool for AMXW would behave poorly with set fastread on and if the dataset it was reading had no records in it.(4.9.04)
Suprtool for AMXW would fail with a dbstatus 17, No current record found when doing an update or delete operation with Set Fastread on and Set Lock 0.(4.9.04)
Suprtool for AMXW would not close the currently open database when the BASE command was entered by itself.(4.9.04)
Suprtool did not print out progress messages when run in batch in an AMXW job. This was solved by calling AMXW’s print intrinsic.(4.9.04)
Progress messages were intersperesed with List command output.(4.9.04)
Number of records are now being printed when doing a form of a self-describing file.(4.9.04)
Set AMXW Perfwrite ON increases performance of writing to an output file by up to 10 times.(4.9.04)
When numrecs is > number of records read, sometimes the file is padded with blank records.(4.9.04)
Output,erase on a file with a shorter record would write a series of nulls.(4.9.04)
Sort with output,erase on a smaller file did not erase all records.(4.9.04)
Suprtool now shows error when there is no room to append records, this is to be more “MPE” like.(4.9.04)
Suprtool now can use two methods when dynamically loading Oracle, Eloquence and Image routines in the respective versions of Suprtool.(4.9.04)
Suprtool for HP-UX now supports Item Level locking with the Set Itemlock command.(4.9.04)
Oracle load warning messages are no longer printed by default.(4.9.04)
The Base command on it’s own did not close the current database like it did on MPE.(4.9.04)
Suprtool Version 4.9.02 (HP-UX 4.9.03)
Suprtool for HP-UX would not set the return code variable $?, if it failed with some syntax errors. (HP-UX 4.9.03)
Suprtool had some debug messages were left over in the Table module.(HP-UX 4.9.03)
Suprtool would have a stack overflow when the input source was an Oracle table, the if command was used and no records were selected.(HP-UX 4.9.03)
Suprcall for AMXW would not build a tempfile even if the Build command was specified in the Suprtool task.(HP-UX 4.9.03)
Suprcall would not always print the stdlist if the print-state was set to ER.(HP-UX 4.9.03)
Suprcall now returns an error status if Suprtool run has an error, in both the AMXW version and the regular HP-UX version.(HP-UX 4.9.03)
A stack overflow error would occur when sorting with two sort keys and the input source was an Oracle Table. (HP-UX 4.9.02)
Suprtool would output 100 blank records when reading an empty Eloquence dataset with set fastread on. (HP-UX 4.9.02)
Suprtool2 fixed to work better with certain cobol compilers and compiler options. (HP-UX 4.9.02)
Command lines that were not terminated with a null are now handled correctly in Suprtool2. (HP-UX 4.9.02)
Print state and execution of print of stdout now works properly in all cases in Suprtool2. (HP-UX 4.9.02)
Tmpnam call would occasionally abort on Itanium due to ineffective space allocation in Suprtool2. (HP-UX 4.9.02)
Suprtool would incorrectly give an error with the Set Buffer command with some values. ( MPE 4.9.02)
Output=Input now writes out the sort information for self-describing files. (HP-UX 4.9.01)
The $file and $list options are now supported in the Total command. (HP-UX 4.9.01)
Suprtool would return Illegal constant error when Set Varsub was on and either the $Counter or $findclean functions were being used. (HP-UX only)
The List command would fail to initialize the output file if PCL was other than zero and the file option was being used and Stdlist was being re-directed. (HP-UX only)
Suprtool would report an error when closing a memory mapped file if two or more Tables are being used.
The $CLEAN function in Suprtool and Clean command in STExport can now remove a character that needs to be cleaned and it does not replace with a space, but rather shifts the text to the left and adds a space to the end.
Suprlink's Join command would not build the output file large enough if the input file flimit was significantly smaller than the Link file.
Suprtool 4.8.10 would abort on a duplicate none key operation on a file greater than 5,000 bytes (approx)
Suprtool would not select the correct records for Ksam64 files.
Suprlink's Join command would not build the output file large enough if the input file flimit was significantly smaller than the Link file.
Suprtool would incorrectly retrieve Oracle Null dates when with a real Date value, instead of Null values in certain versions of Oracle. (HP-UX only)
Suprtool would not be able to extract the last field of a table when the extracted record size was an uneven number of bytes and the set Ifouroutput option was being used with Oracle tables. (HP-UX only)
Suprtool would return Illegal constant error when Set Varsub was on and the $Counter function was being used. (HP-UX only)
Suprtool would return Bad Address or stack overflow on some sort operations. (HP-UX only)
The Table command would previously not release memory used for Tables in all cases. (HP-UX only)
Output=input is now supported in Suprtool for HP-UX. (HP-UX only)
The $number function would either add garbage onto the end of a conversion
or two zeroes if the field did not have a decimal point.
Suprtool has all new code to connect to Oracle databases which fixes a
number of issues with connecting to recently released Oracle patches. (HP-UX, specific)
Suprtool now dynamically loads all Oracle calls that it requires which also
helps with several issues with connecting to recently release Oracle patches. (HP-UX, specific)
The FILE option of the List command did not handle absolute file names
properly. (HP-UX, specific)
The Table command now can read files greater than 4 Gbs. (HP-UX specific, MPE version already does this)
The information about the data loaded in a Table would be lost if the table
being referenced was the second held table and the previous task involved a chain
command.
The Get command would not get correct end of file signal if the
dataset was empty and being accessed with Set FastRead On. HP-UX Only
Suprtool now allows up to 255 $split functions per task.
Suprtool's Open command can now connect to a remote Oracle database. (HP-UX specific)
Highlights in Version 4.7.02
MPE Version
Suprtool now has a $Number function which will allow
Suprtool to use a freeform ascii number with signs, decimal
places and currency symbol as a display field.
Suprtool and STExport now support features to Clean your data.
STExport now supports an Escape command which will escape
out certain characters.
Suprtool now supports a $counter function which will increment
a field by one for every record selected.
Suprtool now supports a $total function which will total a specified field.
Suprtool would incorrectly report an error on a second set tablesize
command for a given task.
STExport would in some cases attempt to format data in XML and HTML
format at the same time.
The Clean command in STExport and Suprtool has improved syntax to
define a range of characters to replace.
Suprtool now has a $SubTotal function.
Suprtool can now split byte strings into multiple fields
via the $split function.
Suprlink can now do many-to-many links via the Join command.
Suprlink and STExport now report the number of output
records in a manner similar to Suprtool.
The $counter function was not reset in between tasks.
Extract from a table would incorrectly report an error in some cases.
The Table command now supports filenames up to 80 characters.
The Table command truncated filenames at the limit of 36 characters.
The number of defines allowed in Suprtool has been increased to 768.
Suprtool would report an incorrect record number when encountering
an Illegal ascii digit, if the Suprtool task involved the Duplicate command.
HP-UX Version 4.7.02
Suprtool $number function required a small fix as Suprtool would incorrectly
report the error, Error: Space found in between numerics. Cannot convert.
Suprtool would fail on a Dbupdate of a critical item in some cases. This was fixed in the
Eloquence library.
HP-UX Version 4.7.01
Suprtool would fail on the base command for some Eloquence databases, due to a bug in
the Eloquence Image library.
HP-UX Version 4.7
Suprtool now has a $Number function which will allow
Suprtool to read a freeform ascii number with signs,
decimal places and currency symbol as a display field.
Suprtool now has a $SubTotal function.
Suprtool can now split byte strings into
multiple fields via the $split function.
Suprlink can now do many-to-many links via the Join command.
Suprtool and STExport now support features to Clean your data.
STExport now supports an Escape command, which will
escape out certain characters when used with certain import programs.
Suprtool now supports a $counter function which will increment a
field by one for every record selected.
Suprtool now supports a $total function which
will keep a running total for a specified field.
Suprtool, STExport and Suprlink now support environment variables.
Suprtool has been enhanced to support Eloquence 7.0 features.
The Base and Put commands have been changed to support new features in Eloquence 7.0.
Suprtool now supports the expanded database limits in Eloquence 7.0.
Suprlink and STExport now report the number of output
records in a manner similar to Suprtool.
Suprtool now supports Extract from a table on HP-UX.
Suprtool now supports larger tables and a significant performance improvement
in loading and looking up tables.
The Table command now supports filenames up to 80 characters.
The Table command truncated filenames at the limit of 36 characters.
The number of defines allowed in Suprtool has been increased to 768.
Suprtool would report an incorrect record number when encountering an
Illegal ascii digit, if the Suprtool task involved the Duplicate command.
STExport would in some cases attempt to format data in XML and
HTML format at the same time.
Extract from a table would incorrectly report an error in some cases.
Suprtool 4.6.01
Suprtool would incorrectly coerce large negative numbers from a
Packed field to another Packed or Display field.
Suprtool would fail with prefetch point failure if the file had
an uneven record size and an uneven blocking facter.
STExport now properly converts the Roman 8 universal monetary
symbol to the Euro-Symbol in the HTML and XML commands.
The Item command would fail if a definition or Item command was
already issued for a field, if the input source was a
self-describing file and and extract range was used or all
items from a dataset were extracted.
The XML command would fail to convert ">" to ">"
and "<" to "<".
The XML and HTML commands failed to convert "&" to
"&".
Highlights in Suprtool 4.6
Support for HP Eloquence databases has been added. (HP-UX only)
Suprtool incorrectly rounded Real and Long target data in
arithmetic expressions
The Table command incorrectly gave an error message in some
cases when data was loaded with key values. (MPE only)
Highlights in Suprtool 4.5
Support for "well-formed" XML in STExport.
Suprtool, STExport and Suprlink can now have warnings turned off
when run from batch with the set warnings off command.
CM to NM switches in Suprtool have been decreased significantly.
Suprtool now has the ability to load and extract data from a Table.
Loading a Table is now up to 28% faster than previous versions.
Table lookup operations are now up to 33% faster than previous versions.
You can read about the new features in this version at the
Change Notice Page.
Go back to ...
