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.

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

Next Public Holidays:

August 3, 2015 ~ BC Day

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

Hours: 7am-3pm Pacific