Doc-To-Help Standard Manual
by Robelle Solutions Technology Inc.
Program and
manual copyright © 1981-2018 Robelle Solutions Technology Inc.
Qedit and Suprtool are trademarks of Robelle Solutions Technology Inc. Oracle are trademarks of Oracle Corporation, Redwood City, California, USA. Other product and company names mentioned herein may be the trademarks of their respective owners.
Robelle Solutions Technology Inc.
Suite 372 - 7360 137 Street
Surrey, B.C. CanadaV3W 1A3
Support: 289.480.1060
E-mail: sales@robelle.com
E-mail: support@robelle.com
Web: www.robelle.com
Program and manual copyright © 1981-2018 Robelle
Solutions Technology Inc.
STExport - Data Export Utility
Suprlink - Multidataset Access
Who Needs To Use These Instructions
Suprtool for HP-UX, with Dynamic Image loading
Quick Start Guide for Suprtool
What is a Self-Describing File?
Create an SD File from a Data File
Finding Data Based on Another Table’s Criteria
Sort Records in Descending Order
Report without Duplicate Records
Report Only the Duplicate Records
Report Only the Unique Records
Report Only the Duplicates and Their Originals
Deleting Duplicate Data File Records
Count and Subtotal on Sort Keys
Changing the Output Record Format
Producing a Condensed Table Listing
Setting Up a PATH for Suprtool
Initial Command Line:
-ccmdstring
Default Outcount File Name: -oc
Hardcoded File Names and ROBELLE Variable
Differences Between MPE and HP-UX
Symbolic Links and
running Supramxw
Suprtool and Self-Describing Files
Create an SD File from a Table
Create an SD File from a Data File
Decimal Places and Date Formats
Suprtool and Personal Computers
Suprtool and PowerHouse Applications
Step 1: Create a Subfile with Quiz
Step 2: Output Erase in Suprtool
Creating Subfile with Script File
Quiz: Generating Suprtool Commands
Year 2000 Solutions with Suprtool
What If I Have Four-Digit Years?
What does Set Date ForceCentury do?
What If I Have Two-Digit Years?
What Is Wrong with Two-Digit Years?
Will Suprtool Generate an Error for Two-Digit Year
Dates?
How Do I Use $Today and $Date with yymmdd Dates?
Can Suprtool Convert Two-Digit Years to Four Digits?
Case 1:
Converting a J2 Date from yymmdd to ccyymmdd
Case 2: X6
yymmdd Data to X8 ccyymmdd
Case 3:
Different Date Formats X6 MMDDYY Data to X6 YYMMDD
$TRIM (Works on byte type fields)
Extract Usage (target: Byte type fields)
Data Examples Before and After:
$LTRIM (Works on Byte type fields)
Extract Usage (target: Byte type fields)
Data Examples before and after:
$RTRIM (Works on Byte type fields)
Extract Usage (target: Byte type fields)
$UPPER (Works on Byte-type fields)
Extract Usage (target: Byte type fields)
$LOWER (Works on Byte-type fields)
$PROPER (Works on Byte-type fields)
$SPLIT (Works on Byte-type fields)
$FINDCLEAN (Works on Byte-type fields)
$CLEAN (Works on Byte-type fields)
$TRANSLATE (Works on Byte-type fields)
Data Examples: (Using above code)
$JUSTIFYL (Works on Byte-type fields)
Data Examples: (Using above code)
$JUSTIFYR (Works on Byte-type fields)
Data Examples: (Using above code)
$LEADZEROB (Works on Byte-type fields)
Data Examples: (Using above code)
$RESPACE (Works on Byte-type fields)
Data Examples: (Using above code)
Example of $TOTAL and $SUBTOTAL
Examples for $counter and $subcount:
$LEADZEROZ (Works on Display-type fields)
Data Examples: (Using above code)
Splitting Variable
Length Strings
Placeholders and
Format Characters