Doc-To-Help Standard Manual
by Robelle Solutions Technology Inc.
Program and manual copyright © 1981-2023 Robelle Solutions
Technology Inc.
Permission is granted to reprint this document (but not for profit) if copyright notice is given.
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-2023 Robelle Solutions Technology Inc.
Permission
is granted to reprint this document (but not for profit) if copyright notice is
given.
STExport
- Data Export Utility
Rport -
Data Reporting Utility
Suprlink
- Multidataset Access
Who
Needs To Use These Instructions
Road
Map to Suprtool on HP-UX and Linux
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)
$CHANGE
(Works on Byte-type fields)
$LENGTH
(Works on Byte-type and numeric fields)
Example
of $TOTAL and $SUBTOTAL
Examples
for $counter and $subcount:
$LEADZEROZ
(Works on Display-type fields)