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

Next Public Holidays:

May 18, 2015 ~ Victoria Day

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

Hours: 7am-3pm Pacific