Doc-To-Help Standard Manual
by Robelle Solutions Technology Inc.
Program
and manual copyright © 1981-2016 Robelle Solutions Technology Inc.
Qedit and Suprtool are trademarks of Robelle Solutions Technology Inc. Oracle is a trademark 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, 13711 – 72nd Avenue,
Surrey, B.C. Canada V3W 2P2
Support: 289.480.1060
E-mail: sales@robelle.com
E-mail: support@robelle.com
Web: www.robelle.com
Program and manual copyright © 1981-2016 Robelle
Solutions Technology Inc.
Speed Demon - Replacing DBGET Mode-2
STExport - Data Export Utility
Suprlink - Multidataset Access
Getting a Quick Start with Suprtool
What is a Self-Describing File?
Create an SD File from a Data File
How to Save On-line Commands to a File
Finding Data Based on Another Dataset's Criteria
Comparing against a Key and Data
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 Database Records
Deleting Non-Unique Duplicate Database Records
Deleting Duplicate Data File Records
Count and Subtotal on Sort Keys
Changing the Output Record Format
Producing a Condensed Dataset Listing
Combining Info= and Son Process
Preventing Suprtool from Suspending
When to Use Suprtool with IMAGE
Database Maintenance (Delete, Put)
Master Dataset Expansion (MDX)
Jumbo Datasets and Large Datasets
Compatibility Mode KSAM/V Files
How Do I Convert CM Ksam to NM KSAM?
Reuse option and KSAM/XL Files
Buffered and NOBUF File Access
Suprtool and Self-Describing Files
Create an SD File from a Dataset
Create an SD File from a Data File
Decimal Places and Date Formats
Convert an SD File to a Disc File
Suprtool and Remote File Access
Calling Suprtool in Native Mode
Suprtool and CI Variable Substitution
Suprtool and Personal Computers
Suprtool and PowerHouse Applications
Step 1: Create
a Subfile with Quiz
Step 2: Output
Erase in Suprtool
Creating Subfile with Command File
Suprtool and PowerHouse Data-Types
Suprtool Definitions - QSCHEMA
Quiz: Generating Suprtool Commands
Generating Suprtool Commands from Quick
Suprtool and Application Systems
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
Native Mode and Compatibility
Mode
Obtaining Accurate Measurements
$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)
Example of $TOTAL and $SUBTOTAL
Examples for $counter and $subcount:
Splitting Variable
Length Strings