Suprtool and Qedit: still enhancing, always backwards compatible
Suprtool/Open: our latest product offering, can go wherever you want to go:
With other products, migration may involve recoding and retesting with only a subset of functionality. But our new Suprtool/Open is a complete migration of Suprtool. See the latest information at: Suprtool/Open.
Occasionally we get requests to summarize data or manipulate reports to be re-organized. One common manipulation is to stick the contents of one line onto the end of another based on the a value in the first line. The commands to do this are fairly simple :
Append "~" "Transaction"
Glue "~"
ch "~" " @
qux/lq all
Transaction Date: 20160908
Balance: 1245.85
Transaction Date: 20151213
Balance: 908.54
Transaction Date: 20121221
Balance 125.44
qux/append "~" "Transaction"
1 Transaction Date: 20160908~
3 Transaction Date: 20151213~
5 Transaction Date: 20121221~
3 lines appended to
qux/glue "~"
1 Transaction Date: 20160908~Balance: 1245.85
3 Transaction Date: 20151213~Balance: 908.54
5 Transaction Date: 20121221~Balance 125.44
3 lines Glue-updated
qux/ch "~" " @
1 Transaction Date: 20160908 Balance: 1245.85
3 Transaction Date: 20151213 Balance: 908.54
5 Transaction Date: 20121221 Balance 125.44
3 lines changed
The Append command sticks a Tilde on the end of the line, and the glue command, glues the line after the Transaction line onto the end. Tilde is used since it isn't often in normal files, you can look to insure that the tilde is not in the file with a simple: ch "~"~" @, to see if there are any occurences.
09/08/2016
Occasionally we get updates to customers e-mail addresses and often these e-mails have bad data in them. Over the past years I have tracked the bad data to be, Tab, Carriage Return or Line Feed. Luckily we have Suprtool to fix the data in very few commands:
base custdb,1,;
get d-custdata
clean "^9:^13"
if $findclean(e-mail-address)
update
ext e-mail-address=$clean(e-mail-address)
xeq
We specify Decimal Nine thru to Decimal 13, which is Tab thru to Line Feed, we use $findclean to find the entries and we update and run the extract of the e-mail address thru the $clean function and the data gets fixed and updated in one easy step.
09/07/2016
Have our website generate your Suprtool code for you. We three new forms to help generate code, Standard Suprlink Task, Select using a table, and Update using a Table. See our Code Generation Page.
09/06/2016
Suprtool 5.8.11 is now available as a pre-release. You can read a summary of What is New, in What's New.
08/25/2016
The Robelle Web Site has been updated using Bootstrap 4, to provide a more Mobile friendly look and feel. As always please send feedback to neil@robelle.com.
08/01/2016
The latest Robelle Newsletter is now available.
06/27/2016
We've been busy adding new features to the Suprtool Suite of products, namely with the JSON option in STExport and more recently we've added access to MYSQL databases in Suprtool/Open.
>OPEN MYSQL robelle_4 Jz2xrwX tream_robelle dbserver.robelle.com
>SELECT * FROM ALL_TYPES
>FORM
Column Len Offset Type
TINYINT 4 0 Tiny
SMALLINT 6 3 Short
MEDIUMINT 9 9 INT24
INT 11 18 Long
BIGINT 20 29 LONGLONG
FLOAT 6 49 FLOAT
DOUBLE 8 55 Double
DECIMAL 10 63 NEWDECIMAL
CHAR 20 73 String
DATE 10 93 Date
DATETIME 19 103 DateTime
TIMESTAMP 19 122 TimeStamp
TIME 10 141 Time
YEAR 4 151 Year
>LIST
>XEQ
>SQL (1) >OUT $NULL (0)
TINYINT = 1 SMALLINT = 2
MEDIUMINT = 3 INT = 4
BIGINT = 5
FLOAT = 6.01 DOUBLE = 7.02
DECIMAL = 8.03 CHAR = MYCHAR
DATE = 2016-02-26 DATETIME = 2016-02-29 02:15:22
TIMESTAMP = 2016-02-26 15:06:39
TIME = 15:06:39 YEAR = 2016
>SQL (2) >OUT $NULL (1)
TINYINT = 1 SMALLINT = 2
MEDIUMINT = 3 INT = 4
BIGINT = 5
FLOAT = 6.01 DOUBLE = 7.02
DECIMAL = 8.03 CHAR = MYCHAR
DATE = 2016-02-26 DATETIME = 2016-02-29 02:15:22
TIMESTAMP = 2016-02-26 15:06:50
TIME = 15:06:50 YEAR = 2016
IN=2, OUT=2. CPU-Sec=1. Wall-Sec=1.
If you're interested in trying this new feature out or have any questions, let me know by e-mailing Neil@robelle.com.
Keep in mind that this products is currently just in our little wind tunnel, but it does extract data, list to the terminal and output to link/SD files. We are interested in getting feedback to look at the direction of how to handle some data types.
05/02/2016
You may have read on HP3000-L about the Computer History Simulation Project and the Emulated HP3000 that you compile and build yourself.
Read the details at the top of the page about the SIMH Emulator.
04/05/2016
04/04/2016
02/02/2016
01/25/2016
01/19/2016
12/15/2015
11/24/2015
What do you do when you try downloading a file to your HP 3000 and you always get a single line file?
Read some suggested tips about One Line files.
9/17/2015
I'm looking for people to test the code generation for for input from Oracle Form Output. This form will take in the output from a form command after the Open / Select commands have an active Oracle table.
You can try this new form out at Oracle Form to Code. Any feedback can be addressed to neil at robelle.com.
7/17/2015
Recently I was asked how to find a line and add a line before the line and how to add a line after. This is always fairly easy using host based commands, but since this customer did not have the host-based version of Qedit, but rather the Server only version and Qedit for Windows. Therefore my other option was to Add Lines Before and After a Line using Qedit for Windows Scripting Language.
You can refer to the Qedit For Windows Scripting Language manual for details.
5/21/2015
A number of customers have been requesting where to download Suprtool from for Amisys 6.7. The summary of what changes have been made to Suprtool under What's New in Suprtool Section.
You can click on the link "Request a Download" at the end of the list of enhancements etc. You can also go directly to the form to Request a Download and please note that at the end of the form you need to scroll down and enter the captcha information in the box provided at the bottom of the page.
5/13/2015
A second form has been added to help generate Suprtool code. The purpose of this form is to generate code where it would take in a CSV file make it fixed length and split the various fields into their intended native type. A form of a dataset or SD file can be used to generate the code.
This is currently just an experiment but we plan on expanding and already have a few ideas for some other code generation. You can try it out by going to this form: Form To Code
You enter a start position and paste in the form of the dataset you want define and extract commands for and you are taken to a page with then generated code on it.
4/24/2015
A new form has been added to help generate Suprtool code. The purpose of this form was to help a customer with some code generation where files would have some fields at the beginning and then an entire dataset in the file. So the dataset would start at a position that was not the first position and was not in a self-describing file.
So the code generator form will take in a form from a dataset and a start position and generate all the coded defines and extracts.
This is currently just an experiment but we plan on expanding and already have a few ideas for some other code generation. You can try it out by going to this form: Form To Code
You enter a start position and paste in the form of the dataset you want define and extract commands for and you are taken to a page with then generated code on it.
More refinements will be done but at this time this is just a test project.
4/22/2015
Oracle 12 has some changes in it that doesn't allow for older versions of Suprtool to connect to databases using the Oracle 12 client. Suprtool 5.7 Build 6 and higher now properly connects to Oracle databases using the Oracle 12 client.
This impacts Itanium and Open versions of Suprtool.
1/27/2015
In 2014, Robelle support was asked for a method to Obfiscate or make unreadable some test data. We came up with a method and documented it in this HowDoI article.
Taking this article and the need for many of our customers needing to do this, we enhanced Suprtool to have a function that would translate characters in such a way as to make such fields as the Company Name, First/Last name of people etc to be unreadable in a quick and easy manner. This is intended for when you make copies of test data and want to make some of these fields unreadable.
So instead of using the Table and having define each field, you can now do the following:
run suprtool.pub.robelle BASE macord.macsdata.test,1,DOALL GET customers TRANSLATE TOUNREAD UPDATE EXTRACT name=$translate(name) EXIT
1/13//2015
Suprtool 5.7 is available as the production release, you can read about the various enhancements and bug fixes in the various change notices.
12/31//2014
Tel: 604-501-2001
Support: 289-480-1060
sales@robelle.com
support@robelle.com
Hours: 7am-3pm PST
Closed
Sep 5th Labour Day
Oct 10th Thanksgiving
Nov 11th Remembrance Day
Dec 26th Boxing Day
