Contents

Introducing Suprtool Version 5.1 5

Overview.................................................................................................................................................... 5

Highlights in Suprtool 5.1........................................................................................................................ 5

Highlights in Suprtool 5.0........................................................................................................................ 6

Known Problems....................................................................................................................................... 7

Compatibility............................................................................................................................................. 8

CPU Serial Number (uname).................................................................................................................... 8

Documentation.......................................................................................................................................... 8

Installation 9

Overview.................................................................................................................................................... 9

Installation Instructions.......................................................................................................................... 9

Installation Assistance............................................................................................................................ 9

Enhancements in Version 5.1 10

Introduction............................................................................................................................................. 10

Extended Names...................................................................................................................................... 10

Set SDEXtname On | Off........................................................................................................................ 10

Debug Information................................................................................................................................. 10

$stddate($days(a)).................................................................................................................................. 11

TPI-keys................................................................................................................................................... 11

ROBELLE_LP.......................................................................................................................................... 12

VarsubDebug.......................................................................................................................................... 12

VarsubCompat......................................................................................................................................... 13

If $lookup................................................................................................................................................. 13

Multiple Literal Compares..................................................................................................................... 13

Enhancements in Version 5.0 14

Base and Open Commands................................................................................................................... 14

Set HPUXCmdErr “<string>”................................................................................................................ 14

Set SDEXtname On | Off........................................................................................................................ 15

Set VarsubCompat On | Off................................................................................................................... 15

Dynamic Loading.................................................................................................................................... 15

Set ItemLock <fieldname>..................................................................................................................... 15

Dynamic Load Warnings....................................................................................................................... 16

Set RealMap On | Off.............................................................................................................................. 16

Bugs Fixed 17

Bugs Fixed In Suprtool 5.0.15............................................................................................................... 17

Bugs Fixed In Suprtool 5.0.14............................................................................................................... 17

Bugs Fixed In Suprtool 5.0.12............................................................................................................... 17

Bugs Fixed In Suprtool 5.0.11............................................................................................................... 17

Bugs Fixed In Suprtool 5.0.10............................................................................................................... 17

Bugs Fixed In Suprtool 5.0.................................................................................................................... 18

Bugs Fixed In Suprtool 4.9.06............................................................................................................... 18

Bugs Fixed In Suprtool 4.9.05............................................................................................................... 18

Bugs Fixed In Suprtool 4.9.04............................................................................................................... 18

Bugs Fixed In Suprtool 4.9.03............................................................................................................... 18

Bugs Fixed In Suprtool 4.9.02............................................................................................................... 19

Introducing Suprtool Version 5.1

Overview

Use Suprtool/UX to read, select, and sort data from Oracle, Allbase and Eloquence databases and data files with fixed-length records. Suprtool/UX is designed to be similar to Suprtool for MPE while providing necessary HP-UX features.

Suprlink/UX 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.

Highlights in Suprtool 5.1

· Support for extended names in Suprtool and Suprlink.

· STExport did not handle files with 256 fields in an SD file.

· Suprtool would not close the previous database when a base command is issued with a database name specified.

· Suprtool can now execute the if and extract expression $stddate($days(a) + 10) in one task.

· Suprtool now supports stand-alone Z type TPI keys or Eloquence indexes.

· Reset Output did not correctly re-initialize the Output file name.

· Set Stat on did not look at the current value properly when parsing.

· Suprtool now allows you to specify the “lp” program by setting the variable ROBELLE_LP.

· 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.

· 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.

Highlights in Suprtool 5.0

· Suprtool2 for HP-UX would abort with Signal 11 if the ROBSUPR variable was not set and thousands of invocations of Suprtool, thru the Suprtool2 interface. (5.0)

· Suprtool2 would write line feeds to the stdin file at 128 bytes if the command line write exceeded 128 bytes. (5.0)

· Suprtool would use the incorrect record size when writing out records directly from an Oracle table and with Set Oracle integer on or Set ifouroutput on.

· Set RealMap has been added to control if Suprtool for HP-UX maps Real Numbers to Ieee. The default is to do the mapping.

· STExport now supports SD file items that are considered R type. It will map them to IEEE automatically. Previously STExport would fail when trying to support R type items.

· Set HPUXCMDERR allows user 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)

· Suprtool now checks that the respective libraries have been loaded for the Open command for Oracle, and the Base command for Eloquence. (4.9.06)

· Suprtool has had some groundwork done for a new enhancement for fieldnames up to 32 characters to be supported in SD files. (4.9.05)

· Suprtool for HP-UX version 4.9.04 had calls to it’s internal timer call information disabled which made progress messages display inaccurate wall time statistics. (4.9.05)

· Suprtool for HP-UX, dynamic Image loading version did not properly startup in some cases, specifically when trying to detect if it could use the Fastread option or not. (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)

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

· Suprtool would abort if an invalid password was specified in some configurations of Eloquence and if used with other Image replacement libraries. (4.9.04)

· Suprtool for HP-UX would not set the return code variable $?, if it failed with some syntax errors. (4.9.03)

· Suprtool had some debug messages were left over in the Table module. (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. (4.9.03)

· Suprcall would not always print the stdlist if the print-state was set to ER. (4.9.03)

· Suprcall now returns an error status if Suprtool run has an error. (4.9.03)

· A stack overflow error would occur when sorting with two sort keys and the input source was an Oracle Table. (4.9.02)

· Suprtool would output 100 blank records when reading an empty Eloquence dataset with set fastread on. (4.9.02)

· Suprtool2 fixed to work better with certain cobol compilers and compiler options. (4.9.02)

· Command lines that were not terminated with a null are now handled correctly in Suprtool2. (4.9.02)

· Print state and execution of print of stdout now works properly in all cases in Suprtool2. (4.9.02)

· Tmpnam call would occasionally abort on Itanium due to ineffective space allocation in Suprtool2. (4.9.02)

· The Total command now supports the $file and $list options. (4.9.01)

· Output=input now writes out the sort information if the file involved is self-describing. (4.9.01)

Known Problems

Occasionally and Add to an Oracle Table aborts, typically after multiple large adds. Currently the work around is to just start a fresh copy of Suprtool for the particular Add task that the abort occurs on.

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

Compatibility

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 4.9 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 Dynamic loading version of Suprtool

CPU Serial Number (uname)

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.

Documentation

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: