New: Support for AMXW!
What's New in Suprtool?
Suprtool is constantly being improved and enhanced.
Also: Suprtool for MPE with the same commands.
Suprtool for HP-UX with the same commands.
Message from Bob Green, Robelle Founder:
"Although Suprtool is over 20 years old, it continues to evolve and grow, because Robelle responds quickly to change. We had the fastest data extract tool on the HP 3000, but we didn't stop. We wrote our own proprietary sort routines to make Suprtool the fastest sort engine too. Then customers complained that although they loved Suprtool for single file extracts, they really missed it when linking multiple data sources. This led to Suprlink - our unique and high performance method of merging many data sources into one. With the PC revolution, customers needed to disperse their data to Excel, Access, etc. Robelle heard them and added STExport to Suprtool for exporting data with precise import specifications."
"Now, the move is toward migration. On the day after HP's obsolescence notice, Robelle identified the Eloquence database as a valuable option for HP 3000 sites moving to HP-UX. In a few short weeks we produced a new Eloquence version of Suprtool and had it in user hands for testing. By March 2002 the product was tested, documented, packaged and released into production. But we didn't stop for a rest. We immediately started working with Marxmeier, the firm in charge of Eloquence, on producing an even better Suprtool for an even better Eloquence, with virtually complete TurboIMAGE compatibility. Hand in hand, each new R&D version of Eloquence is carefully integrated into Suprtool and tested, allowing us to give Marxmeier instant feedback on where they fine-tune the database software. "
"It isn't as if we have forgotten our TurboIMAGE and Oracle users - we also added XML output to Suprtool for everyone and the ability to load and extract data from custom tables that are built with Suprtool. With these constant improvements, Robelle remains on the cutting edge to meet customers current needs."
Suprtool now runs on x86 Linux, AIX and many other platforms with a new version of your favourite data manipulator.
About three years ago we began porting all of our Robelle code to C in order to have our products be more portable. The first fruit from this endeavour was a fully Native Itanium version of Suprtool.
Shortly after that we ported to AIX and some other test ports to Sun, however, the majority of our customer interest has been to get Suprtool running on Linux on x86 platform. This involved handling the slightly larger issue of Endianess.
We dealt with the issue by re-writing some internal areas of Suprtool creating Suprtool/Open a less OS dependent version of Suprtool, but with same high performance, regardless of the hardware platform.
We've ported to AIX, Sun, Linux (Red Hat, Ubuntu and SUSE), with the main dependency being your version of GCC not your OS.
One of the goals of this project is to be available on whatever platform Eloquence works on and more for those who use Oracle.
[neil@localhost test]$ ../suprtool/suprtool SUPRTOOL/Open/Copyright Robelle Solutions Technology Inc. 1981-2011. (Version 5.4.14 Internal) FRI, DEC 16, 2011, 6:51 PM Type H for help. Build 2 >base sample Database password [;]? >form sets Database: sample TPI: Eloquence B.08.10 B.08.10.03 Set Item Entry Load Entry Sets: Num Type Count Capacity Count Factor Length B/F CUSTOMERS 1 MDX 10 1355 1177 87 % 112 0 PARTS 2 MDX 10 524 182 35 % 53 0 ID 3 ADX 1 2259 47 2 % 2 0 ORDERS 4 DDX 7 1008 47 5 % 21 0 LINEITEMS 5 DDX 7 1008 136 13 % 22 0 >get customers >out custs,link >exit IN=1177, OUT=1177. CPU-Sec=1. Wall-Sec=1. [neil@localhost test]$ ../stexport/stexport STExport/Open/Copyright Robelle Solutions Technology Inc. 1995-2011 (Version 5.4.14 Internal) FRI, DEC 16, 2011, 6:54 PM Type H for Help. Build 2 $in custs $out myprn $xeq In=1177. Out=1177. CPU-Sec=1. Wall-Sec=1.Please contact Neil Armstrong at Neil@robelle.com for more information. Eloquence into its product, opening up migration options for TurboIMAGE users. We are committed to staying current with the latest version of HP Eloquence and keeping Suprtool for HP-UX the leader in Eloquence data access.
Eloquence is a TurboIMAGE lookalike for HP-UX (see below for details) With Suprtool and Eloquence combined, you will have the same Suprtool commands that you are familiar with on MPE now working on HP-UX. And, At the April 2002 Solutions Symposium, Dave Wilde (CSY R&D manager at HP) endorsed using Eloquence to migrate applications from MPE to HP-UX.
As far as IMAGE/SQL alternatives go for customers who would benefit from keeping their “Image-calls” and do a “one-step at-a-time” approach, he said that he is committed to promoting Eloquence to fill that need. He said that it’s “likely the best approach,” and that “the product is very solid and very strong …”
Eloquence has fully integrated indexing capabilities, using indexed sequential instead of hashing. So there are no "migrating secondaries" and set locking is not required in order to add or delete an entry from a master set. Capacity is not relevant, since the database grows dynamically when required (including master data sets).
Locking capabilities: Also available are new locking capabilities, new database utilities, and multi-platform support (HP-UX, Windows NT/2000, Linux). Eloquence supports dynamic, nested transactions, transaction isolation (uncommitted changes are not visible to other processes), deadlock detection and recovery, on-line backup, and a new, more flexible security subsystem.
Version 8 of Eloquence also comes with a TurboIMAGE interface library that provides virtually complete compatibility with the HP 3000 database.
Eloquence is a product of Marxmeier Software.
The key to this ease of data transfer is Suprtool's Self Describing File format which maintains the field names, data-types and formating options along with the data. You don't have to do the entire migration at once: phase it in gradually, giving yourself time to test each part thoroughly and reduce your risk of a catastrophic, career-ending mistake.Suprlink for combining data from several sources in a flexible and lightning fast manner and STExport for exporting data into whatever format the importing program requires.
Click the link above to visit the Robelle migration web resource.Suprlink and STExport modules.
input order_details link product_master_info output orders_with_descriptions xeq
open oracle mike mypass select * from customer_table if state_code='CA' sort zip_code output customers_california xeq
Suprtool/UX supports connecting to multiple Eloquence services on a single machine through the new Base command syntax. And it supports the new expanded database limits for Eloquence and is compatible with the latest versions of Eloquence.
The Clean Command in Suprtool and STExport to clean your byte type fields of bad characters such as Linefeeds.
The Escape Command in STExport to "escape" out certain key characters for safe Import into your SQL databases.
The $Counter Function inserts a unique record id into each output record, making it easy to return data to its original order.
The $Total Function provides a running total on a field in all output records.
And much more.