Suprtool 5.9 for MPE:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2016 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 5.9 for MPE: 1

Program and manual copyright © 1981-2016 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 5.9 24

Highlights in Suprtool 5.9. 24

Highlights in Suprtool 5.8. 24

Highlights in Suprtool 5.7. 24

Highlights in Suprtool 5.6. 25

Highlights in Suprtool 5.5. 25

Highlights in Suprtool 5.4. 25

Highlights in Suprtool 5.3. 25

Highlights in Suprtool 5.2. 25

Highlights in Suprtool 5.1.02. 26

Installing Suprtool 27

Ecometry Users 27

Instructions 27

Getting a Quick Start with Suprtool 28

How to Run Suprtool 28

What is a Task? 28

Copying Files 29

Copying One File 29

Appending to a File 29

Concatenating Two Files 29

Fields in Data Files 29

What is a Self-Describing File? 29

Creating an SD File 29

Define Fields in a Data File 30

Create an SD File from a Data File 30

Repeating Commands 31

Repeating a Command. 31

How to Save On-line Commands to a File 31

Selecting Database Records 31

Select All Records 32

Select a Random Sample 32

Look at the First Few Records 32

Selecting by Criteria 32

Simple Criteria 32

Complex Criteria 32

String of Digits 33

Selecting by Date 33

Select by Today's Date 33

Select by Particular Date 33

Select by Year 34

Select Prior Month. 34

Selecting by Lists of Values 34

Finding Data Based on a List 34

Finding Data Based on a File 35

Finding Data Based on Another Dataset's Criteria 35

Finding Data in a Data File 36

Comparing against a Key and Data 36

Sorting Database Records 37

Sort Records 37

Sort Records in Descending Order 37

Sort by Multiple Keys 37

Deleting Records 37

Updating Records 38

Duplicate Records 38

Report without Duplicate Records 38

Report Only the Duplicate Records 39

Report Only the Unique Records 39

Report Only the Duplicates and Their Originals 40

Deleting Duplicate Database Records 40

Deleting Non-Unique Duplicate Database Records 41

Deleting Duplicate Data File Records 42

Sorting IMAGE to KSAM.. 43

Loading a Dataset 43

Decimal Places 43

Converting Numbers 44

Counts and Subtotals 44

Count and Subtotal on Sort Keys 44

Sort by Count or Subtotal 45

Total by Field. 45

Running Totals 45

Running SubTotals 45

Listing Records 46

Changing the Output Record Format 46

Producing a Condensed Dataset Listing. 47

Simple Reports 47

Your First Report 47

Printing a Report 48

Specifying Your Own Title 48

Column Headings 48

Printing Mailing Labels 49

Running Suprtool under MPE 50

How to Run Suprtool 50

How to Xeq a Suprtool Task. 50

Info= for Commands 50

Combining Info= and Son Process 51

Exit with Verify. 52

Preventing Suprtool from Suspending. 52

Stdin and Stdlist Files 52

Input and Output Files 53

Using CREATEPROCESS. 53

Duplicating Files 53

Job Control Word. 53

Suprmgr Configuration File 54

Using Suprtool in Batch. 54

SuprtoolOutCount JCW.. 54

SuprtoolFullCount Variable 55

Summary of Parm= Values 55

Suprtool Issues and Solutions 57

A Suprtool Task. 57

Input Choices 57

Processing Selections 57

Output Choices 57

Suprtool and Allbase 58

Date and Time Types 59

Restrictions 59

Suprtool and IMAGE. 59

Reading Datasets 59

Serial vs. Keyed Access 60

When to Use Suprtool with IMAGE. 60

TurboIMAGE Compatibility. 61

Locking of IMAGE Datasets 61

Database Maintenance (Delete, Put) 62

Master Dataset Expansion (MDX) 63

Jumbo Datasets and Large Datasets 63

Suprtool and KSAM Files 64

Locking Output KSAM Files 64

Locking Input KSAM Files 64

Compatibility Mode KSAM/V Files 65

Reorganizing KSAM/V Files 65

KSAM/XL Files 66

Loading KSAM/XL Files 66

How Do I Convert CM Ksam to NM KSAM? 66

Reuse option and KSAM/XL Files 67

Suprtool and MPE Files 67

Buffered and NOBUF File Access 67

Message Files 68

Circular Files 68

Temporary Files 69

Copying User Labels 69

SDUnix Utility. 70

SDUnix Parameters 70

LF vs. NOLF. 70

Link vs. Query. 71

Suprtool and Self-Describing Files 71

Create an SD File from a Dataset 71

Create an SD File from a Data File 71

SD Files as Input 72

Listing SD Files 72

Decimal Places and Date Formats 72

Restrictions of SD Files 72

Creating KSAM SD Files 73

HowMessy Loadfile 74

Notes on SD Files 74

Convert an SD File to a Disc File 74

Suprtool and Sorting Files 74

Fast Sorting. 75

Native Language Support 75

With Reduced Disc Space 75

Suprtool and Tape Files 76

Labelled Tapes 76

Multiple Files 77

File User Labels 77

Suprtool and Remote File Access 78

Network Services (NS) 78

Suprtool and MPE/iX. 78

Calling Suprtool in Native Mode 78

User XL Files 78

When Errors Occur 79

Sorting with Suprtool/iX. 79

Suprtool and CI Variable Substitution. 79

Batch Requires Indent 80

Avoiding Double Resolution. 80

Suprlink and STExport 81

Suprtool and User Prompting. 81

Resolving Variables 82

Suprtool and Personal Computers 82

Downloading to the PC. 83

Decimal Places 83

Spreadsheets 83

Suprtool and PowerHouse Applications 83

Suprtool with Quiz/QTP. 83

Step 1: Create a Subfile with Quiz 84

Step 2: Output Erase in Suprtool 84

Step 3: Report with Quiz 84

Using QTP to Create Subfiles 85

Creating Subfile with Command File 85

Suprtool and PowerHouse Data-Types 87

Suprtool Definitions - QSCHEMA. 89

Notes on QSHOW Output 90

The Quiz Report 91

Quiz: Generating Suprtool Commands 92

Generating Suprtool Commands from Quick. 92

Suprtool and Application Systems 93

Third-Party Indexing. 93

Z-type TPI-keys 93

Omnidex without TPI 94

Suprtool with TRANSACT. 95

XSORT and RPG. 96

QUERY Program.. 96

SRN Chronos Dates 97

Year 2000 Solutions with Suprtool 97

What If I Have Four-Digit Years? 97

What does Set Date Cutoff do? 98

Stddate and Set Date Cutoff 98

What does Set Date ForceCentury do? 98

What If I Have Two-Digit Years? 98

What Is Wrong with Two-Digit Years? 99

How Do $Today and $Date Work? 99

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

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

aammdd Date Format 100

Invalid Dates 101

Can Suprtool Convert Two-Digit Years to Four Digits? 101

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

Case 2: X6 yymmdd Data to X8 ccyymmdd. 103

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

Year 2000 Testing. 105

Performance Issues 106

Native Mode and Compatibility Mode 106

Sort Speed. 107

Analyzing Performance Data 107

Suprtool Performance Hints 108

Obtaining Accurate Measurements 108

Performance Summary. 109

Suprtool Functions 109

UC4/Scripting and Functions 109

String/Byte Functions 110

$TRIM (Works on byte type fields) 110

Extract Usage (target: Byte type fields) 110

Data Examples Before and After: 111

$LTRIM (Works on Byte type fields) 111

Extract Usage (target: Byte type fields) 111

Data Examples before and after: 111

$RTRIM (Works on Byte type fields) 111

Extract Usage (target: Byte type fields) 112

Data Examples: 112

Data Result 112

$UPPER (Works on Byte-type fields) 112

Extract Usage (target: Byte type fields) 112

Data Examples: 112

$LOWER (Works on Byte-type fields) 113

Extract Usage: 113

Data Examples: 113

$PROPER (Works on Byte-type fields) 113

Extract Usage: 113

Data Examples: 113

$SPLIT (Works on Byte-type fields) 114

Extract Usage: 114

Data Examples: 114

Data Examples: 114

$FINDCLEAN (Works on Byte-type fields) 114

$CLEAN (Works on Byte-type fields) 114

If Usage: (Not commonly used) 115

Extract Usage: 115

Data Examples: 115

$TRANSLATE (Works on Byte-type fields) 115

Extract Usage: 115

Data Examples: (Using above code) 115

Extract Usage: 116

Extract Usage: 116

String Addition. 116

Extract Usage: 116

Data Result: 116

Numeric Functions 116

Extract Usage: 117

Extract Usage: 117

Extract Usage: 117

Extract Usage: 118

Example of $TOTAL and $SUBTOTAL. 118

Extract Usage: 119

Extract Usage: 119

Examples for $counter and $subcount: 119

Extract Usage: 120

Arithmetic Operations 120

+ - * / mod. 120

Extract Usage: 120

Conversion/Formatting. 120

Extract Usage: 121

Data Examples: 121

Extract Usage: 121

Data Examples: 121

Other Functions 121

Extract Usage: 122

Date Functions 122

Extract Usage: 122

Extract Usage: 123

Extract Usage: 123

Extract Usage: 123

Extract Usage: 124

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

Numeric Expressions 194

String Expressions 196

Date Selection. 200

Long Expressions 206

Input Command [I] 209

Item Command [IT] 212

Date Formats 212

Decimal Places 215

Key Command [K] 218

Link Command [LIN] 220

List Command [L] 221

LaserJet Listings 222

Headings in Listings 223

Simple Reports 224

List Device 225

Listredo Command [LISTREDO] 227

Numrecs Command [N] 228

Open Command [OP] 230

Output Command [O] 231

Put Command [P] 238

Q Command [Q] 240

Redo Command [REDO] 241