The current production version for Suprtool is version 5.0.
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 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 ...
