Doc-To-Help Standard Manual
by Robelle Solutions Technology Inc.
Program and manual copyright © 1981-2019 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
Table of Contents
Program and manual
copyright © 1981-2019 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)
$LENGTH (Works on
Byte-type and numeric fields)
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