July 2016 Newsletter

The latest Robelle Newsletter is now available.

06/27/2016

Suprtool/Open with MYSQL Access

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.

We are looking for anyone who has MYSQL data and knows a little about Suprtool. We are looking at what to do with certain fields and how to handle some data types and the most common data types using in MYSQL.

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

The Computer History Simulation Project

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

Follow us On Twitter
Robelle now has three Twitter accounts for you to follow:
@Qedit
@suprtool
@Robelle1
You can find links on the right hand side of the main page.

04/04/2016

New Code Generation Forms Need Testing
The Code Generation forms on our website have been grouped together and three new forms have been added.

02/02/2016

Code Generation
The Code Generation forms on our website have been grouped together and will be expanded over the coming months.

01/25/2016

How Do I Now on Youtube
The HowDoI? section on our website now has some tutorials on Youtube.

01/19/2016

December 2015 News
The December 2015 Newsletter has been sent out and is available online.

12/15/2015

HP 3000 Evolution Book Now Available Online
The HP3000 Evolution book, edited by Bob Green is now available Online! Click on the book cover to download your copy!

11/24/2015

When Your 3000 Gives you One-Liners

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

Form to Code for Oracle Form

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

Adding a Line Before and a Line After a String

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

Amisys Customers Looking for Suprtool 5.7 Production Version

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

Suprtool Code Generation ~ CSV file

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

Suprtool Code Generation

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 Compatibility

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

Obfuscating Test Data (Follow-up)

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 Available

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

Suprtool $-Function Definitions
We've grown the list of Suprtool if and extract functions so much over the years we are adding the Suprtool Funtions List and Examples to the manual for Suprtool 5.7. Follow the link for the first stab at documenting and providing examples of the various functions inside Suprtool.

10/07//2014

June 2014 Newsletter
Read the latest newsletter for June 2014

06/20//2014

Obfuscating Test Data
New HowDoI Article on Obfuscation Test Data in byte Containers.

04/11//2014

Normalizing Data
New HowDoI Article on Normalizing Phone numbers in byte Containers.

04/08//2014

Qedit for Windows 6.0 Available
Read What's New in Qedit for Windows 6.0 which is available for download and has been available for sometime. Lot's of key bug fixes.

01/08//2014

The Emulator Chronicles
Read about our initial experiences with the Freeware edition of the Charon HP/3000 emulator and the meeting at the Computer History Museum put on by Stromasys.

05/15//2013

Scripting Service
  • Lost your Suprtool expert?
  • No expertise in house?
  • Can't remember what the script was supposed to do?
  • Too busy putting out fires?
Contact Robelle for Our NEW Scripting Service.

10//27//2012




we support the 3000 Newswire blog

Holiday Schedule:

Closed
July 1st Canada Day
Aug 1st BC Day
Sep 5th Labour Day
Oct 10th Thanksgiving
Nov 11th Remembrance Day
Dec 26th Boxing Day

Tel: 604-501-2001
Support: 289-480-1060

Hours: 7am-3pm PST

Robelle Twitter Accounts

Suprtool Twitter

Qedit Twitter

Robelle Twitter