Suprtool/Open 6.0

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 - 7360 137 Street

Surrey, B.C. CanadaV3W 1A3

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/Open 6.0 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 16

Introduction. 16

Suprtool Components 16

STExport - Data Export Utility. 16

Suprlink - Multidataset Access 16

Documentation. 17

Suprtool Version 6.0 19

Highlights in Suprtool 6.0. 19

Highlights in Suprtool 5.9. 19

Highlights in Suprtool 5.8. 19

Highlights in Suprtool 5.7. 20

Installing Suprtool 21

Who Needs To Use These Instructions 21

Instructions for Installing. 21

Quick Start Guide for Suprtool 22

How to Run Suprtool 22

What is a Task?. 22

Copying Files 22

Copying One File 22

Appending to a File 23

Fields in Data Files 23

What is a Self-Describing File?. 23

Creating an SD File 23

Define Fields in a Data File 23

Create an SD File from a Data File 24

Repeating Commands 24

Repeating a Command. 24

Selecting Database Records 25

Select All Records 25

Look at the First Few Records 25

Selecting by Criteria 26

Simple Criteria 26

Complex Criteria 26

String of Digits 26

Selecting by Date 26

Select by Today's Date 27

Select by Particular Date 27

Select by Year 27

Select Prior Month. 27

Selecting by Lists of Values 28

Finding Data Based on a List 28

Finding Data Based on a File 28

Finding Data Based on Another Table’s Criteria 29

Finding Data in a Data File 29

Sorting Database Records 29

Sort Records 29

Sort Records in Descending Order 30

Sort by Multiple Keys 30

Duplicate Records 30

Report without Duplicate Records 30

Report Only the Duplicate Records 31

Report Only the Unique Records 31

Report Only the Duplicates and Their Originals 32

Deleting Duplicate Data File Records 32

Decimal Places 33

Converting Numbers 33

Counts and Subtotals 34

Count and Subtotal on Sort Keys 34

Sort by Count or Subtotal 34

Total by Field. 35

Running Totals 35

Running SubTotals 35

Listing Records 36

Changing the Output Record Format 36

Producing a Condensed Table Listing. 37

Simple Reports 37

Your First Report 37

Column Headings 38

Printing Mailing Labels 38

Running Suprtool 41

Running Suprtool 41

Setting Up a PATH for Suprtool 41

Bourne and Korn Shells 41

Dynamic Loading. 42

Control Characters and stty. 42

Suprmgr Configuration Files 43

On-Line vs. Batch Access 43

Command Line Options 43

Initial Command Line: -ccmdstring. 43

Default Outcount File Name: -oc 43

Exit with Verify: -v. 44

Combining -c and -v. 44

Loader Warnings 44

Unix/Linux Notes 44

Shell Commands 44

Hardcoded File Names and ROBELLE Variable 45

ROBELLE Variable 45

/opt/robelle/suprmgr 45

Outcount File 45

Differences Between MPE and Open. 45

Record Length. 46

Duplicate Output Files 46

Classic Reals 46

Input from Stdlist 47

Missing Features 47

Suprtool Issues and Solutions 49

A Suprtool Task. 49

Input Choices 49

Processing Selections 49

Output Choices 49

Suprtool and Oracle 50

Number Data-Type 50

Order By vs. Sort 51

Restrictions 51

Suprtool and Self-Describing Files 51

Create an SD File from a Table 51

Create an SD File from a Data File 51

SD Files as Input 52

Listing SD Files 52

Decimal Places and Date Formats 52

Extended Field Names 52

Restrictions of SD Files 53

Suprtool and Sorting Files 53

Suprtool and Personal Computers 53

Downloading to the PC. 53

Decimal Places 53

Spreadsheets 54

Two-Digit Year Solutions 54

What If I Have Four-Digit Years?. 54

What does Set Date Cutoff do?. 54

Stddate and Set Date Cutoff 55

What does Set Date ForceCentury do?. 55

What If I Have Two-Digit Years?. 55

What Is Wrong with Two-Digit Years?. 56

How Do $Today and $Date Work?. 56

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

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

aammdd Date Format 57

Invalid Dates 58

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

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

Case 2: X6 yymmdd Data to X8 ccyymmdd. 59

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

Eloquence Performance 62

Sort Performance 62

Oracle Performance 63

Analyzing Performance Data 63

Variable Substitution. 63

Suprtool Functions 64

UC4/Scripting and Functions 64

String/Byte Functions 64

$TRIM (Works on byte type fields) 65

Extract Usage (target: Byte type fields) 65

Data Examples Before and After: 65

$LTRIM (Works on Byte type fields) 65

Extract Usage (target: Byte type fields) 65

Data Examples before and after: 65

$RTRIM (Works on Byte type fields) 66

Extract Usage (target: Byte type fields) 66

Data Examples: 66

$UPPER (Works on Byte-type fields) 66

Extract Usage (target: Byte type fields) 67

Data Examples: 67

$LOWER (Works on Byte-type fields) 67

Extract Usage: 67

Data Examples: 67

$PROPER (Works on Byte-type fields) 67

Extract Usage: 68

Data Examples: 68

$SPLIT (Works on Byte-type fields) 68

Extract Usage: 68

Data Examples: 68

Data Examples: 68

$FINDCLEAN (Works on Byte-type fields) 69

$CLEAN (Works on Byte-type fields) 69

If Usage: (Not commonly used) 69

Extract Usage: 69

Data Examples: 69

$TRANSLATE (Works on Byte-type fields) 69

Extract Usage: 70

Data Examples: (Using above code) 70

$JUSTIFYL (Works on Byte-type fields) 70

Extract Usage: 70

Data Examples: (Using above code) 70

$JUSTIFYR (Works on Byte-type fields) 70

Extract Usage: 70

Data Examples: (Using above code) 70

$LEADZEROB (Works on Byte-type fields) 71

Extract Usage: 71

Data Examples: (Using above code) 71

$RESPACE (Works on Byte-type fields) 71

Extract Usage: 71

Data Examples: (Using above code) 71

Extract Usage: 71

Extract Usage: 72

String Addition. 72

Extract Usage: 72

Data Result: 72

Numeric Functions 72

Extract Usage: 73

Extract Usage: 73

Extract Usage: 73

Extract Usage: 74

Example of $TOTAL and $SUBTOTAL. 74

Extract Usage: 75

Extract Usage: 75

Examples for $counter and $subcount: 75

Extract Usage: 76

$LEADZEROZ (Works on Display-type fields) 76

Extract Usage: 76

Data Examples: (Using above code) 76

Arithmetic Operations 76

+ - * / mod. 76

Extract Usage: 77

Conversion/Formatting. 77

Extract Usage: 77

Data Examples: 77

Extract Usage: 78

Data Examples: 78

Other Functions 78

Extract Usage: 78

Extract Usage: 79

Date Functions 79

Extract Usage: 79

Extract Usage: 80

Extract Usage: 80

Extract Usage: 80

Extract Usage: 81

Extract Usage: 81

Suprtool Commands 83

General Notes 83

Abbreviating. 83

Uppercase or Lowercase 83

Multiple Commands per Line 83

Continuation. 84

Comments on Command Lines 84

Control-Y Interrupt 85

Add Command [Add] 86

Base Command [BA] 88

Before Command [B] 90

Chain Command [C] 92

Clean Command [CL] 94

Removing Bad Characters 94

Define Command [D] 95

Delete Command [DEL] 100

Do Command [DO] 102

Duplicate Command [DU] 103

Edit Command [ED] 108

Exit Command [E] 109

Export Command [EXP] 111

Extract Command [EXT] 112

Range of Fields 116

Numeric Expressions 117

$SubTotal Function. 119

$Total Function. 119

$Counter Function. 119

String Expressions 120

Splitting Variable Length Strings 121

Cleaning your Data 122

Un-printables 123

Clean Command Syntax. 123

Setting the Clean Character 123

Cleaning a Field. 123

Cleaning your data 124

Extract from a Table 124

Data Conversion. 125

$Number Function. 126

Numeric to Byte Conversion. 127

$Edit Function. 128

Placeholders and Format Characters 128

Byte-Type Formatting. 128

Z-placeholder for byte-fields 129

Overflow and limits 129

Numeric field edit-masks 130

Decimal Places 131

Data and Edit mask: 131

Currency and Dollar signs 131

Overflow and floating dollar 132

Set CurrencySymbol 132

Overflow and limits 132

Restrictions 132

Form Command [F] 135

Get Command [G] 138

Help Command [H] 140

If Command [IF] 141

Expressions 141

Numeric Expressions 146

String Expressions 148

Date Selection. 151

Long Expressions 156

Input Command [I] 159

Item Command [IT] 161

Date Formats 161

Decimal Places 164

Key Command [K] 167

Link Command [LIN] 169

List Command [L] 170

LaserJet Listings 171

Headings in Listings 172

Simple Reports 173

List Device 174

Listredo Command [LISTREDO] 177

Numrecs Command [N] 178

Open Command [OP] 179

Remote Databases and Oracle Issues 179

Output Command [O] 180

Put Command [P] 186

Q Command [Q] 187

Redo Command [REDO] 188

Reset Command [R] 191

Select Command [SEL] 192

Set Command [S] 193

CurrencySymbol 196

Date Cutoff 196

Date ForceCentury. 197

Date IfYY2000Error 197

Date MapToPHDate8. 198

DecimalSymbol 198

DumpOnError 199

EditStopError 199

HPUXCmdErr “<string>” 200

InitExtents 201

ItemAbbreviateDate 201

Interactive 202

LabelledTapeRewind. 202

List FormFeed. 205

Oracle Rows 207

Oracle Integer 207

Oracle OpenFix. 207

Oracle PassShift 208

Oracle SpaceNull 208

Oracle ZeroNull 208

Subsystem.. 212

ThousandSymbol 212