Production Version of Suprtool

The current production version for Suprtool is version 6.6.

Suprtool 6.6

• STExport/UX/Open/Itanium now supports Extended SD information.
• STexport has improved buffer handling, and the amount of overhead has beenimproved by over 50%.
• Stexport has new features in the Json command. Namely, Indent and Header andTrailer options to add data to the output file.
• The Oracle Add command parsing has been improved. It would fail if there were more than 62000 tables in the given database/ownername.
• The $CHANGE function has been improved to update data directly in the case of an UPDATE.
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice
• Suprtool/Open Change Notice

Suprtool 6.5

• A new function in Suprtool called $change, can change one string to another,in a given byte type field. (All Platforms)
• Help files are new supported in suprtool/Open. (Linux only)
• Set SDOUTENDBE On, and output,query, would create and unreadable file. Now if output,query option is specified the SDOUTENDBE setting is ignored for that task.
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice
• Suprtool/Open Change Notice

Suprtool 6.4

• Rport spacing and alignment has been improved for subtotal and total lines. (All Platforms)
• Rport spacing of detail lines has been improved to allow for a space after each byte field. (All Platforms)
• Suprtool has a new command called set sdinbypass on, allows the reclen, lf syntax on an input file if it is self-describing. This was done to allow some customers to not have to change scripts. (Linux Only)
• Input files with Bigendian data are converted to Little endian about three times faster in all cases. (Linux Only)
• Suprtool when running with set ffisbe on and set endianint BE on a sort operation with extract commands would see suprtool incorrectly convert the data from LE to BE twice. (Linux Only Fixed in 6.3.50 Build 6)
• Suprtool when there was an input source of an SQL table and sorting a field with an extract of fields, and set ffisbe on and set endianint, log and Ieee to BE would incorrectly convert the data to Big Endian on the Input side. (Linux Only. Fixed in 6.3.50 Build 6)
• An input of a non-sd file with defines and extracts would assume for BigEndian to Little Endian as a Self-Describing File. (Linux Only. 6.3.50 Build 2)
• A subsequent Suprtool task with large key sorts would fail when the previous step was a step that accessed an Oracle database and the Oracle database was still open. (Linux Only. Suprtool 6.3.01 Build 2)
• Suprtool no longer requires that you need to extract a field from a Flat file (ffisbe on) or Self-Describing file in order for comands like if, sort, dup none keys total field, and total, to correctly convert the data from Big Endian to Little Endian. (Linux Only. 6.3.01 Build 14)
• Suprtool / Open didn’t handle double logical numbers over 2 billion when converting to ascii in the list command. (Linux Only. Fixed in 6.3 Build 2)
• Sorting with certain files would not allocate enough memory space to complete the sort. (Linux Only. Fixed in 6.3 Build 5)
• An if $lookup would not work all times with certain data fields if the data field was Big Endian. (Linux Only. Fixed in 6.3 Build 5)
• A Chain with multiple values specified with in line with byte or logical field types would fail. (Linux Only)
• Output,ascii and Stexport, conversion of double integers with decimal places would incorrectly convert, numbers where the value was less than the number of decimal places. (Linux Only.)
• Output, ascii and Stexport would incorrectly handle single logical conversions for some values. (Linux Only)
• Output,ascii would incorrectly pad uneven byte output files with a null on the first record. (Build 14)
• Output,ascii of a packed field would default to outputting a sign on all fields, when the MPE and HP-UX versions would default to no sign unless negative. (Fixed in 6.3.50 Build 4)
• Request a download.
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice
• Suprtool/Open Change Notice

Suprtool 6.3

• STExport Heading fieldnames limit has been increased to14336 bytes.
• The Suprtool suite of products has had more 2027 mitigation work done to prepare for the end of 20271231.
• Suprtool would incorrectly do a conversion on input of a file with Big Endian data if there was an extract of a constant into an integer field (Linux Only)
• Non-MPE versions of Suprtool didnt update the Item information, decimals and date like the MPE version. When an extract command wasnt entered but an Item command referenced a specific field. You can turn this on with set sditemnoext on, but the default is off to have it be compatible with all versions of Suprtool/Open and HP-UX. You can put it in your suprmgr file, to enable it globally.
• Suprtool would incorrectly think it could sort a file in memory, as opposed to using sort scratch files in an extremely rare case. (Linux)
• Suprtool / Open didnt handle double logical numbers over 2 billion when converting to ascii in the list command. (Linux Only Fixed in Build 2)
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 6.2

• Sdlinux version is available for Linux to convert the .sd file for use on Linux is now available on Linux. You can now directly copy a data file and sdfile from HP-UX and convert it for use on Linux.
• Two new sub-functions of $BOM and $ EOM are now available in the $stddate and $month functions. The $BOM function returns the starting day of the month and the $EOM returns the last date of the month for a given month.
• String functions in Suprtool now have better length and bounds checking of the 4095-byte string limit.
• Rport a new simple report writer has been added to the Suprtool suite of products.
• Rport has a new command called Hide which is intended to not report on a field in an SD file.
• Rport has a new command called Comma, which will place appropriate commas in an ascii field that was converted from a numeric field.
• There is a new setting in RPORT that is called set maxlen on, which calculates the maximum size that a field can be, including commas and dollar signs.
• Suprtool/Open now defaults to /bin/bash when a users shell is notfound in the user information.
• The $eom/$bom function wouldnt work properly when $stddate was nested in a $month function and the to month had 31 days.
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 6.1

• Suprtool has a new function called $length that will return a double integer value of the length of a byte and/or numeric field.
• The $ROBELLE variable has been expanded to 58 characters.
• Suprtool has a new option called Set EditSignNeutral which tells the $edit function to treat Neutral zoned and packed fields to be positive and treated as such by the $edit function.
• Suprlink now supports 8192 bytes on both the input file and the link file.
• Suprlink now supports 16384 bytes on the output file in Suprlink
• Stexport now supports 8192 bytes on both the input file and output files.
• Suprtool now supports Eloquence B.08.30, and the following options for BYTEORDER are also supported, NATIVE,COBOL,BE,BE2,BEDATA, BEDATA2.
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 6.0

• STExport has a new set command called Set Excel Leadzero On which tells the Excel command to add leading zeroes to the fields specified in the Excel Preserve command.
• Suprtool has a new function available to the if/extract commands called $inrecnum, which expects a double integer result.
• Suprtool has a new function called $leadzeroz, which will add leading zeroes to a display field and will optionally justify the field.
• Suprtool has a four new string handling functions, specifically, $justifyl, $justifyr, $leadzerob and $respace.
• Set BackwardChain On tells Suprtools chain command to do a backward chained read.
• The List command now has a NOSAMETO option to turn off the SAMETO feature.
• The Add Command to add data to an Oracle table would fail on some tables with an abort if there were a large number of tables in the database.
• Set AMXW Perfwrite would cause Suprtool for AMXW to fail with fserr 40 incorrectly when using output file,append.
• Set SDEXTNAME on now prints a warning in Suprtool for AMXW, since it is not supported in that version.
• Suprtool for AMXW will test for both long fieldnames and short fieldnames when parsing the $lookup function.
• Suprtool/Open now has the ability to read Self-Describing files from HP-UX natively on Linux. Suprtool / Open can also create Self-Describing files for use on HP-UX with Set SDOutIsBe On.
• Suprtool/Open now has the ability to read Flat files from HP-UX and natively handle Big Endian Integer and Logical fields with Set FFISBE On.
• Suprtool/Open can handle and create BigEndian Logical fields with Set EndianLog On.
• A new utility to convert the version number and field information for HP-UX Self-Describing files to be used on Linux natively called sdlinux.
• The Output,num option in Suprtool / Open, would not work if the input source was a self-describing or a flat file.
• On Suprtool/Open an Output file would have a null written in the last byte incorrectly if the output file was an uneven byte length aSuprtool / Open now has the ability to read Self-Describing files from HP-UX natively on Linux. Suprtool / Open can also create Self-Describing files for use on HP-UX with Set SDOutIsBe On.
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.9

• A new $month function in the if / extract option allows you to add or subtract a number of months from a given date.
• STExport has a new command called Excel command which allows you to format a field in a format that allows leading zeroes or spaces to be preserved.
• A new option called JSON will output SD data in Java Script Object Notation.
• Suprtools new banner would show the incorrect day and day of week in certain circumstances. This was cosmetic only.
• The Add command would fail if a Table in an Oracle database accessible by a given username had more than 2.1 billion entries on Oracle 11 and higher.
• Suprtool/Open now has the option to read MySQL databases. We are looking for feedback on where to take this feature.
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.8


• Set CleanChar to a single character, after a Set CleanChar  would not come into effect due to the special null flag not being reset. This was in both Suprtool and STExport. 
• The input command now accepts the keywords ($first/$last) when inputting a range of records. 
• The list command Reclen verb will now impact the Record size for stdout, where previously it was ignored unless a FILE was specified.
• Suprtool would lose track of Table data field information, on tables held with the hold option in subsequent tasks.
• The Suprtool suite of products has less dependency on the Calendar intrinsic whichwill help products run beyond 2028.
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.7

• STExport now has a suprmgr file similar to Suprtool. STExport will process all the commands found in STEXPMGR.PUB.SYS on MPE and /opt/robelle/stexpmgr on all other platforms.
• Suprlink now has a suprmgr file similar to Suprtool. Suprlink will process all the commands found in LINKMGR.PUB.SYS on MPE and /opt/robelle/linkmgr on all other platforms.
• Set Comlog On has been added to Suprtool, Suprlink and STExport to log all commands entered in Suprtool, Suprlink or STExport are logged in its own file. (HP-UX and Open Platforms)
• Suprtool would potentially have problems with system commands in variable-length scripts if the command ended in a number that had a length of eight numbers. (Open Platforms)
• Suprtool now has a function called $proper which will try and upshift "proper" names in byte strings. (5.6.12)
• Suprtool now has a function called $translate which will scramble data so it will become unreadable. You can invoke your own translate table or use one provided. (5.6.12)
• Suprtool for HP-UX (PA_RISC and Itanium) can now obtain the proper number of records if the file was >2GB in size. (Build 4)
• Suprtool for AMXW would not stop Suprtool when using the list command and the target file filled up. (AMXW only 5.6.12)
• Suprtool/Open would not parse a negative number into a quad integer container. (5.6.11)
• Suprtool for Itanium and Suprtool/Open would not properly convert negative, single and double integers when output,display is invoked. (5.6.11)
• Suprtool for Itanium and Suprtool/Open incorrectly reallocated if/extract code space on subsequent tasks, which would eventually cause Suprtool to fail with the error, Unable to allocate heap space. (5.6.10)
• Request a download.
• Suprtool/Open Change Notice
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.6 (HP-UX) 5.6.01 (MPE)

• Suprtool, Suprlink and STExport now handle 512 fields on HP-UX and Open platforms.
• Suprtools' extract command now has three special keywords to help with extract using a range, which is designed to make your Suprtool scripts more easily maintained. Suprtool now has $all, $first and $last which respectively means all fields, the first field or the last field. Note that $first and $last may only be used in a range extract.
• $Subcount has been added to keep a running count for a given sort break.
• Suprtool for Itanium and Suprtool/Open had problems sorting display type keys with Overpunch characters.
• Suprtool would use the wrong definition for a field with a duplicate field name on a straight copy of a given SD file.
• Suprtool would not load data from a table when $lookup was used in an if command and if the value did not need to be coerced to another type, Suprtool would sometimes not use the correct register location to do the compare.
• Set Ifouroutput on extracts would fail at xeq time with an "Unknown if execute phase" error in the PA_RISC version, when an alignment issue would occur in some circumstances.
• Suprtool would fail or give incorrect result when doing an arithmetic expression when dealing with multiple sets of brackets and the data types involved were either Packed Decimal or Display. (Itanium Only)
• Suprtool and STExport would incorrectly assume a positive sign for a packed-decimal field that had an invalid sign value, when converting from Decimal to Ascii. (Itanium only)
• Suprtool for AMXW did not allocate enough space to support the same number of defined fields and items as previous versions.
• Suprtool for AMXW had a conflict with the AMXW copy command when copying a C/ISAM or emulated KSAM file.
• Suprtool for AMXW could not append to an empty KSAM file.
• Suprtool for AMXW will now detect if the output file has CCTL and will use the correct controlcode on the FWRITE to the Output file.
• Suprtool for AMXW Itanium version now supports more defined fields.
• Suprtool for AMXW would fail to open a "KSAM" file in AMXW when the implementation was done via CISAM.
• Suprtool would fail at the end of a second chain with update task, if the previous chain with update task was against a master dataset. This issue was introduced in 5.5 with the fix to BTree updates due to an Image issue. (MPE only 5.6.01)
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.5

• The $edit function did not work well with alpha based edit masks and if the target was greater than 32 characters. (5.4.16)
• Ksam64 files were not assumed to be Self-describing like CM KSAM and KSAMXL files when it was the input file and had labels.(5.4.16 MPE only)
• A warning will print if a non-regular SD file is loaded into a Table with the data option. The data is not loaded into the table. (5.4.16 MPE only)
• An error will print if an extract command attempts to reference data when loaded from table that in turn was loaded when using a non-regular SD file, such as KSAM/XL, KSAM64 and CM KSAM. (5.4.16 MPE only)
• Set Oracle DataBug On | Off has been added to mimic the incorrect behaviour of writing double the number of bytes in versions 5.1 thru 5.4 and if no extract commands were in place and either set ifouroutput or set oracle integer were on. (5.4.16 HP-UX only)
• Due to an issue with Btrees, Suprtool would incorrectly select records when doing an update or delete, and if using chain with a btree index on a master dataset. (5.4.15)
• Suprtool would write out double the calculated record size when set oracle integer was on or set ifouroutput was on, and output,data option was used and no extract commands were specified.(5.4.15)
• Small change to the Encryption version of Suprtool for MPE, this is not in the normal version of Suprtool, but is a custom version available for testing. (5.4.14)
• Suprtool for HP-UX now supports 268 fields in both an Eloquence database and SD files.(5.4.13)
• STExport for HP-UX now supports 268 fields in an SD file. (5.4.13)
• Suprlink for HP-UX now supports 268 fields in an SD file. (5.4.13)
• Set Fastread now has a default value of off. (5.4.12)
• Suprtool would abort in the middle of an fwrite to the sort scratch file. (5.4.12)
• Suprlink for AMXW would fail on a JOIN command suddenly after applying a patch to libc. (5.4.12)
• Set XLTRIM On now tells Suprtool to close a file and release the disc space between EOF and the Flimit.(5.4.12)
• STExport's Escape command has been re-engineered to fix some corner cases that didn't work previously. (5.4.12)
• The PA_Risc version of Suprtool, Suprlink and STExport now prints out the Build version number. (5.4.10)
• Request a download.
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice
• Suprtool for AMXW Change Notice

Suprtool 5.4.01

• Suprtool now supports output ,else which writes out records to a temporary file on MPE and a ".else" file on HP-UX that did not qualify for the given if condition.
• Suprtool did not properly clear the data field information from a table at the end of a task.
• Suprtool did not properly zero out a packed field target when an table entry was not found when extracting data from a table.
• Bradmark's DbGeneral can produce Jumbo datasets that are a single chunk, Suprtool did not handle these single chunk master jumbo datasets properly as the last block calculation was done only after opening the last chunk itself. We have adjusted the logic in making sure the calculation is done for this case earlier. Adager does not create these single chunk jumbo datasets. There is an un-documented $control directive in dbschema called $forcejumbo, which will produce one of these single chunk jumbos so we are supporting it in Suprtool 5.3.11.
• Suprtool for AMXW would fail when appending to a KSAM file in some instances.
• Suprtool for HP-UX on Itanium now properly supports $atoe and $etoa. (Itanium Version Only)
• Suprtool would encounter problems when reading record sizes greater than 13700 bytes. (Itanium Version Only)
• Suprtool for HP-UX on Itanium would incorrectly coerce the number negative 65536 from Binary to Decimal and Decimal to Binary. (Itanium only)
• Suprtool for HP-UX on Itanium would fail with an HPPAC error if the field had spaces when reading a display field. (Itanium only)
• The Eloquence loading algorithm has been changed to make another attempt at loading the routines. (HP-UX and AMXW)
• Suprtool for AMXW would not run an external program from inside Suprtool due to a naming conflict with some routines in the AMXW libraries, this is the Itanium version only.
• Request a download.
• Suprtool for MPE Change Notice
• Suprtool for HP-UX Change Notice

Suprtool 5.3

• Suprtool now supports output ,append access to vision file system KSAM. (AMXW only)
• Extract with arithmetic divide operation would not round properly if the target was single, double or quad integers or single-logical or double-logicals. (Itanium only)
• Suprtool would not properly store the number of bits to store on a bitwise operation in the if command or extract. (Itanium only)
• The chain command would not work if a data set entry length was evenly divisable by 128. (Itanium only)
• Suprtool would produce an error on input of a link file equated to a dataset. (AMXW only)
• Extract to a Logical target would produce a zero result. (Itanium only)
• 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)
• Suprtool did not properly erase the output file when using out=in, dup none key on HP-UX.
• 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.
• A Select operation on an empty table or if the select would result in zero records it would fail if Set Ifouroutput was on. (Itanium only)

Past Versions

Suprtool 5.2 MPE (Released June 23, 2009)

• 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 (Released June 23, 2009)

• 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 (Released June 23, 2009)

• 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.1.02 MPE (Released : October 2, 2008)

• 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)

Suprtool Version 4.8.02

• 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 Version 4.8.01

• The chain command would either fail or return incorrect records when used with Set FastRead On.

Suprtool Version 4.8

• The $subtotal function has been re-written in order to use less resources and fix some bugs.
• Suprtool now reads Eloquence databases up to five times faster. (HP-UX specific)
• Eloquence routines are now dynamically loaded, using the libraries on your system. (HP-UX specific)
• Suprtool now has a $findclean function to identify records with specific characters in it.
• Dbedit for HP-UX now works on Eloquence databases and on Oracle databses in the ImaxSoft version of Suprtool. (HP-UX specific)
• The List command now has new options for listing to a file on HP-UX. (HP-UX specific)
• Suprtool now has a $edit function for formatting data.
• 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 ...

• Summary of What's New at Robelle
• Suprtool Product Page
• Summary of What's New in Suprtool
• Production Release
• Pre-Release
• In Development