Suprtool 6.1 for MPE:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2019 Robelle Solutions Technology Inc.

Permission is granted to reprint this document (but not for profit), provided that copyright notice is given.

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

Robelle Solutions Technology Inc.

Suite 372, 13711 – 72^nd Avenue,

Surrey, B.C. Canada V3W 2P2

Phone: 604.501.2001

Support: 289.480.1060

E-mail: sales@robelle.com

E-mail: support@robelle.com

Web: www.robelle.com

Table of Contents

Suprtool 6.1 for MPE: 1

Program and manual copyright © 1981-2019 Robelle Solutions Technology Inc. 2

Permission is granted to reprint this document (but not for profit), provided that copyright notice is given. 2

Phone: 604.501.2001 2

Table of Contents 3

Welcome to Suprtool 20

Introduction. 20

Suprtool Components 20

Database Editing. 20

Speed Demon - Replacing DBGET Mode-2. 21

STExport - Data Export Utility. 21

Suprlink - Multidataset Access 21

Suprtool2 - Interface Routine. 22

Documentation. 22

Suprtool Version 6.1 24

Highlights in Suprtool 6.1. 24

Highlights in Suprtool 6.0. 24

Highlights in Suprtool 5.9. 24

Installing Suprtool 26

Ecometry Users 26

Instructions 26

Getting a Quick Start with Suprtool 27

How to Run Suprtool 27

What is a Task? 27

Copying Files 28

Copying One File. 28

Appending to a File. 28

Concatenating Two Files 28

Fields in Data Files 28

What is a Self-Describing File? 28

Creating an SD File. 28

Define Fields in a Data File 29

Create an SD File from a Data File. 29

Repeating Commands 30

Repeating a Command. 30

How to Save On-line Commands to a File 30

Selecting Database Records 30

Select All Records 31

Select a Random Sample 31

Look at the First Few Records 31

Selecting by Criteria 31

Simple Criteria. 31

Complex Criteria. 31

String of Digits 32

Selecting by Date 32

Select by Today's Date 32

Select by Particular Date. 32

Select by Year 33

Select Prior Month. 33

Selecting by Lists of Values 33

Finding Data Based on a List 33

Finding Data Based on a File 34

Finding Data Based on Another Dataset's Criteria. 34

Finding Data in a Data File 35

Comparing against a Key and Data 35

Sorting Database Records 36

Sort Records 36

Sort Records in Descending Order 36

Sort by Multiple Keys 36

Deleting Records 36

Updating Records 37

Duplicate Records 37

Report without Duplicate Records 37

Report Only the Duplicate Records 38

Report Only the Unique Records 38

Report Only the Duplicates and Their Originals 39

Deleting Duplicate Database Records 39

Deleting Non-Unique Duplicate Database Records 40

Deleting Duplicate Data File Records 41

Sorting IMAGE to KSAM.. 42

Loading a Dataset 42

Decimal Places 42

Converting Numbers 43

Counts and Subtotals 43

Count and Subtotal on Sort Keys 43

Sort by Count or Subtotal 44

Total by Field. 44

Running Totals 44

Running SubTotals 44

Listing Records 45

Changing the Output Record Format 45

Producing a Condensed Dataset Listing. 46

Simple Reports 46

Your First Report 46

Printing a Report 47

Specifying Your Own Title. 47

Column Headings 47

Printing Mailing Labels 48

Running Suprtool under MPE 49

How to Run Suprtool 49

How to Xeq a Suprtool Task. 49

Info= for Commands 49

Combining Info= and Son Process 50

Exit with Verify. 50

Preventing Suprtool from Suspending. 51

Stdin and Stdlist Files 51

Input and Output Files 51

Using CREATEPROCESS. 52

Duplicating Files 52

Job Control Word. 52

Suprmgr Configuration File. 52

Using Suprtool in Batch. 53

SuprtoolOutCount JCW.. 53

SuprtoolFullCount Variable 54

Summary of Parm= Values 54

Suprtool Issues and Solutions 55

A Suprtool Task. 55

Input Choices 55

Processing Selections 55

Output Choices 55

Suprtool and Allbase. 56

Date and Time Types 57

Restrictions 57

Suprtool and IMAGE. 57

Reading Datasets 57

Serial vs. Keyed Access 58

When to Use Suprtool with IMAGE. 58

TurboIMAGE Compatibility. 59

Locking of IMAGE Datasets 59

Database Maintenance (Delete, Put) 60

Master Dataset Expansion (MDX) 61

Jumbo Datasets and Large Datasets 61

Suprtool and KSAM Files 62

Locking Output KSAM Files 62

Locking Input KSAM Files 62

Compatibility Mode KSAM/V Files 63

Reorganizing KSAM/V Files 63

KSAM/XL Files 64

Loading KSAM/XL Files 64

How Do I Convert CM Ksam to NM KSAM? 64

Reuse option and KSAM/XL Files 65

Suprtool and MPE Files 65

Buffered and NOBUF File Access 65

Message Files 66

Circular Files 66

Temporary Files 67

Copying User Labels 67

SDUnix Utility. 68

SDUnix Parameters 68

LF vs. NOLF. 68

Link vs. Query. 69

Suprtool and Self-Describing Files 69

Create an SD File from a Dataset 69

Create an SD File from a Data File. 69

SD Files as Input 70

Listing SD Files 70

Decimal Places and Date Formats 70

Restrictions of SD Files 70

Creating KSAM SD Files 71

HowMessy Loadfile 72

Notes on SD Files 72

Convert an SD File to a Disc File. 72

Suprtool and Sorting Files 72

Fast Sorting. 73

Native Language Support 73

With Reduced Disc Space. 73

Suprtool and Tape Files 74

Labelled Tapes 74

Multiple Files 75

File User Labels 75

Suprtool and Remote File Access 76

Network Services (NS) 76

Suprtool and MPE/iX. 76

Calling Suprtool in Native Mode. 76

User XL Files 76

When Errors Occur 77

Sorting with Suprtool/iX.. 77

Suprtool and CI Variable Substitution. 77

Batch Requires Indent 78

Avoiding Double Resolution. 78

Suprlink and STExport 79

Suprtool and User Prompting. 79

Resolving Variables 80

Suprtool and Personal Computers 80

Downloading to the PC. 81

Decimal Places 81

Spreadsheets 81

Suprtool and PowerHouse Applications 81

Suprtool with Quiz/QTP. 81

Step 1: Create a Subfile with Quiz. 82

Step 2: Output Erase in Suprtool 82

Step 3: Report with Quiz. 82

Using QTP to Create Subfiles 83

Creating Subfile with Command File. 83

Suprtool and PowerHouse Data-Types 85

Suprtool Definitions - QSCHEMA. 87

Notes on QSHOW Output 88

The Quiz Report 89

Quiz: Generating Suprtool Commands 90

Generating Suprtool Commands from Quick. 90

Suprtool and Application Systems 91

Third-Party Indexing. 91

Z-type TPI-keys 91

Omnidex without TPI 92

Suprtool with TRANSACT. 93

XSORT and RPG.. 94

QUERY Program. 94

SRN Chronos Dates 95

Year 2000 Solutions with Suprtool 95

What If I Have Four-Digit Years? 95

What does Set Date Cutoff do?. 96

Stddate and Set Date Cutoff 96

What does Set Date ForceCentury do?. 96

What If I Have Two-Digit Years? 96

What Is Wrong with Two-Digit Years? 97

How Do $Today and $Date Work? 97

Will Suprtool Generate an Error for Two-Digit Year Dates?. 98

How Do I Use $Today and $Date with yymmdd Dates?. 98

aammdd Date Format 98

Invalid Dates 99

Can Suprtool Convert Two-Digit Years to Four Digits?. 99

Case 1: Converting a J2 Date from yymmdd to ccyymmdd. 99

Case 2: X6 yymmdd Data to X8 ccyymmdd. 101

Case 3: Different Date Formats X6 MMDDYY Data to X6 YYMMDD.. 102

Year 2000 Testing. 103

Performance Issues 104

Native Mode and Compatibility Mode 104

CPU-Bound?. 104

Sort Speed. 105

Analyzing Performance Data. 105

Suprtool Performance Hints 106

Obtaining Accurate Measurements 106

Performance Summary. 107

Suprtool Functions 107

UC4/Scripting and Functions 107

String/Byte Functions 108

$TRIM (Works on byte type fields) 108

Extract Usage (target: Byte type fields) 108

Data Examples Before and After: 108

$LTRIM (Works on Byte type fields) 108

Extract Usage (target: Byte type fields) 109

Data Examples before and after: 109

$RTRIM (Works on Byte type fields) 109

Extract Usage (target: Byte type fields) 109

Data Examples: 109

Data Result 109

$UPPER (Works on Byte-type fields) 110

Extract Usage (target: Byte type fields) 110

Data Examples: 110

$LOWER (Works on Byte-type fields) 110

Extract Usage: 110

Data Examples: 110

$PROPER (Works on Byte-type fields) 110

Extract Usage: 111

Data Examples: 111

$SPLIT (Works on Byte-type fields) 111

Extract Usage: 111

Data Examples: 111

Data Examples: 111

$FINDCLEAN (Works on Byte-type fields) 112

$CLEAN (Works on Byte-type fields) 112

If Usage: (Not commonly used) 112

Extract Usage: 112

Data Examples: 112

$TRANSLATE (Works on Byte-type fields) 112

Extract Usage: 113

Data Examples: (Using above code) 113

$JUSTIFYL (Works on Byte-type fields) 113

Extract Usage: 113

Data Examples: (Using above code) 113

$JUSTIFYR (Works on Byte-type fields) 113

Extract Usage: 113

Data Examples: (Using above code) 113

$LEADZEROB (Works on Byte-type fields) 114

Extract Usage: 114

Data Examples: (Using above code) 114

$RESPACE (Works on Byte-type fields) 114

Extract Usage: 114

Data Examples: (Using above code) 114

$LENGTH (Works on Byte-type and numeric fields) 114

Extract Usage: 115

Extract Usage: 115

Extract Usage: 115

String Addition. 115

Extract Usage: 115

Data Result: 115

Numeric Functions 116

Extract Usage: 116

Extract Usage: 116

Extract Usage: 116

Extract Usage: 117

Example of $TOTAL and $SUBTOTAL. 117

Extract Usage: 118

Extract Usage: 119

Examples for $counter and $subcount: 119

Extract Usage: 119

$LEADZEROZ (Works on Display-type fields) 119

Extract Usage: 120

Data Examples: (Using above code) 120

$LENGTH (Works on Byte-type and numeric fields) 120

Extract Usage: 120

Arithmetic Operations 120

+ - * / mod. 120

Extract Usage: 120

Conversion/Formatting. 121

Extract Usage: 121

Data Examples: 121

Extract Usage: 121

Data Examples: 121

Other Functions 122

Extract Usage: 122

$INRECNUM.. 122

Extract Usage: 122

Date Functions 123

Extract Usage: 123

Extract Usage: 123

Extract Usage: 123

Extract Usage: 124

Extract Usage: 124

Extract Usage: 125

Suprtool Commands 127

General Notes 127

Abbreviating. 127

Uppercase or Lowercase 127

Multiple Commands per Line. 127

Continuation. 128

Comments on Command Lines 128

MPE Commands 129

MPE/iX Commands 129

Control-Y Interrupt 129

Error Recovery. 130

Add Command [AD] 131

Base Command [BA] 132

Before Command [B] 135

Chain Command [C] 137

Clean Command [CL] 140

Removing Bad Characters 140

Define Command [D] 141

Delete Command [DEL] 146

Do Command [DO] 148

Duplicate Command [DU] 149

Edit Command [ED] 154

Exit Command [E] 155

Export Command [EXP] 157

Extract Command [EXT] 158

Range of Fields 162

Numeric Expressions 164

$SubTotal Function. 166

$Total Function. 166

$Counter Function. 166

String Expressions 167

Splitting Variable Length Strings 168

Cleaning your Data 170

Clean Command Syntax. 170

Setting the Clean Character