Suprtool 6.0 for MPE:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2018 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.0 for MPE: 1

Program and manual copyright © 1981-2018 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.0 24

Highlights in Suprtool 6.0. 24

Highlights in Suprtool 5.9. 24

Highlights in Suprtool 5.8. 24

Highlights in Suprtool 5.7. 25

Highlights in Suprtool 5.6. 25

Highlights in Suprtool 5.5. 25

Highlights in Suprtool 5.4. 25

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. 51

Preventing Suprtool from Suspending. 51

Stdin and Stdlist Files 51

Input and Output Files 52

Using CREATEPROCESS. 52

Duplicating Files 52

Job Control Word. 52

Suprmgr Configuration File 53

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

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

Extract Usage: 114

Extract Usage: 115

String Addition. 115

Extract Usage: 115

Data Result: 115

Numeric Functions 115

Extract Usage: 115

Extract Usage: 116

Extract Usage: 116

Extract Usage: 117

Example of $TOTAL and $SUBTOTAL. 117

Extract Usage: 118

Extract Usage: 118

Examples for $counter and $subcount: 118

Extract Usage: 119

$LEADZEROZ (Works on Display-type fields) 119

Extract Usage: 119

Data Examples: (Using above code) 119

Arithmetic Operations 119

+ - * / mod. 119

Extract Usage: 119

Conversion/Formatting. 120

Extract Usage: 120

Data Examples: 120

Extract Usage: 120

Data Examples: 120

Other Functions 121

Extract Usage: 121

$INRECNUM.. 121

Extract Usage: 121

Date Functions 122

Extract Usage: 122

Extract Usage: 122

Extract Usage: 122

Extract Usage: 123

Extract Usage: 123

Extract Usage: 124

Suprtool Commands 125

General Notes 125

Abbreviating. 125

Uppercase or Lowercase 125

Multiple Commands per Line 125

Continuation. 126

Comments on Command Lines 126

MPE Commands 127

MPE/iX Commands 127

Control-Y Interrupt 127

Error Recovery. 128

Add Command [AD] 129

Base Command [BA] 130

Before Command [B] 133

Chain Command [C] 135

Clean Command [CL] 138

Removing Bad Characters 138

Define Command [D] 139

Delete Command [DEL] 144

Do Command [DO] 146

Duplicate Command [DU] 147

Edit Command [ED] 152

Exit Command [E] 153

Export Command [EXP] 155

Extract Command [EXT] 156

Range of Fields 160

Numeric Expressions 162

$SubTotal Function. 164

$Total Function. 164

$Counter Function. 164

String Expressions 165

Splitting Variable Length Strings 166

Cleaning your Data 168

Clean Command Syntax. 168

Setting the Clean Character 168

Cleaning a Field. 168

Cleaning your data 169

Extract from a Table 169

Data Conversion. 170

$Number Function. 172

Numeric to Byte Conversion. 173

$Edit Function. 173

Placeholders and Format Characters 173

Byte-Type Formatting. 173

Z-placeholder for byte-fields 174

Overflow and limits 174

Numeric field edit-masks 175

Decimal Places 176

Data and Edit mask: 176

Currency and Dollar signs 176

Overflow and floating dollar 177

Set CurrencySymbol 177

Overflow and limits 177

Form Command [F] 180

Get Command [G] 185

Help Command [H] 188

If Command [IF] 189

Expressions 189