Suprtool/Open 6.1

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 


 

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

User Manual 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 16

Introduction. 16

Suprtool Components 16

STExport - Data Export Utility. 16

Suprlink - Multidataset Access 16

Documentation. 17

Notation. 17

Suprtool Version 6.1  19

Highlights in Suprtool 6.1. 19

Highlights in Suprtool 6.0. 19

Highlights in Suprtool 5.9. 20

Highlights in Suprtool 5.8. 20

Installing Suprtool 22

Overview. 22

Who Needs To Use These Instructions 22

Instructions for Installing. 22

Quick Start Guide for Suprtool 23

How to Run Suprtool 23

What is a Task? 23

Copying Files 23

Copying One File. 23

Appending to a File. 24

Fields in Data Files 24

What is a Self-Describing File? 24

Creating an SD File. 24

Define Fields in a Data File 24

Create an SD File from a Data File. 25

Repeating Commands 25

Repeating a Command. 25

Selecting Database Records 26

Select All Records 26

Look at the First Few Records 26

Selecting by Criteria 27

Simple Criteria. 27

Complex Criteria. 27

String of Digits 27

Selecting by Date 27

Select by Today's Date 28

Select by Particular Date. 28

Select by Year 28

Select Prior Month. 28

Selecting by Lists of Values 29

Finding Data Based on a List 29

Finding Data Based on a File 29

Finding Data Based on Another Table’s Criteria 30

Finding Data in a Data File 30

Sorting Database Records 30

Sort Records 30

Sort Records in Descending Order 31

Sort by Multiple Keys 31

Duplicate Records 31

Report without Duplicate Records 31

Report Only the Duplicate Records 32

Report Only the Unique Records 32

Report Only the Duplicates and Their Originals 33

Deleting Duplicate Data File Records 33

Decimal Places 34

Converting Numbers 34

Counts and Subtotals 35

Count and Subtotal on Sort Keys 35

Sort by Count or Subtotal 35

Total by Field. 36

Running Totals 36

Running SubTotals 36

Listing Records 37

Changing the Output Record Format 37

Producing a Condensed Table Listing. 38

Simple Reports 38

Your First Report 38

Column Headings 39

Printing Mailing Labels 39

Running Suprtool 41

Running Suprtool 41

Setting Up a PATH for Suprtool 41

Bourne and Korn Shells 41

C Shell 42

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

Sdlinux Utility. 45

Hardcoded File Names and ROBELLE Variable. 47

ROBELLE Variable. 47

/opt/robelle/suprmgr 47

Outcount File 47

Differences Between MPE and Open. 47

Record Length. 47

Line Feeds 48

Duplicate Output Files 48

Classic Reals 48

Input from Stdlist 49

Missing Features 49

Suprtool Issues and Solutions  51

A Suprtool Task. 51

Input Choices 51

Processing Selections 51

Output Choices 51

Suprtool and Oracle. 52

Data-Types 52

Number Data-Type 52

Order By vs. Sort 53

Restrictions 53

Suprtool and Self-Describing Files 53

Create an SD File from a Table. 53

Create an SD File from a Data File. 53

SD Files as Input 54

Listing SD Files 54

Decimal Places and Date Formats 54

Extended Field Names 54

Restrictions of SD Files 55

Suprtool and Sorting Files 55

Suprtool and Personal Computers 55

Downloading to the PC. 55

Decimal Places 55

Spreadsheets 56

Two-Digit Year Solutions 56

What If I Have Four-Digit Years? 56

What does Set Date Cutoff do?. 56

Stddate and Set Date Cutoff 57

What does Set Date ForceCentury do?. 57

What If I Have Two-Digit Years? 57

What Is Wrong with Two-Digit Years? 58

How Do $Today and $Date Work? 58

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

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

aammdd Date Format 59

Invalid Dates 60

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 61

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

Performance 64

Eloquence Performance 64

Sort Performance 64

Oracle Performance 65

Analyzing Performance Data. 65

Variable Substitution. 65

Suprtool Functions 66

UC4/Scripting and Functions 66

String/Byte Functions 66

$TRIM (Works on byte type fields) 67

If Usage: 67

Extract Usage (target: Byte type fields) 67

Example: 67

Data Examples Before and After: 67

$LTRIM (Works on Byte type fields) 67

If Usage: 67

Extract Usage (target: Byte type fields) 67

Example: 67

Data Examples before and after: 67

$RTRIM (Works on Byte type fields) 68

If Usage: 68

Extract Usage (target: Byte type fields) 68

Example: 68

Data Examples: 68

Data Result 68

$UPPER (Works on Byte-type fields) 68

If Usage: 69

Extract Usage (target: Byte type fields) 69

Example: 69

Data Examples: 69

$LOWER (Works on Byte-type fields) 69

If Usage: 69

Extract Usage: 69

Example: 69

Data Examples: 69

$PROPER (Works on Byte-type fields) 69

If Usage: 70

Extract Usage: 70

Example: 70

Data Examples: 70

$SPLIT (Works on Byte-type fields) 70

If Usage: 70

Extract Usage: 70

Data Examples: 70

Data Examples: 70

$FINDCLEAN (Works on Byte-type fields) 71

If Usage: 71

$CLEAN (Works on Byte-type fields) 71

If Usage: (Not commonly used) 71

Extract Usage: 71

Example: 71

Data Examples: 71

$TRANSLATE (Works on Byte-type fields) 71

If Usage: 72

Extract Usage: 72

Data Examples: (Using above code) 72

$JUSTIFYL (Works on Byte-type fields) 72

If Usage: 72

Extract Usage: 72

Data Examples: (Using above code) 72

$JUSTIFYR (Works on Byte-type fields) 72

If Usage: 72

Extract Usage: 72

Data Examples: (Using above code) 72

$LEADZEROB (Works on Byte-type fields) 73

If Usage: 73

Extract Usage: 73

Data Examples: (Using above code) 73

$RESPACE (Works on Byte-type fields) 73

If Usage: 73

Extract Usage: 73

Data Examples: (Using above code) 73

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

If Usage: 74

Extract Usage: 74

$ETOA.. 74

Extract Usage: 74

$ATOE. 74

Extract Usage: 74

String Addition. 74

Extract Usage: 75

Example: 75

Data Result: 75

Numeric Functions 75

$TRUNCATE. 75

If Usage: 75

Extract Usage: 75

$ABS. 75

IF Usage: 75

Extract Usage: 75

$TOTAL. 76

IF Usage: 76

Extract Usage: 76

$SUBTOTAL. 76

IF Usage: 76

Extract Usage: 77

Example of $TOTAL and $SUBTOTAL. 77

$COUNTER. 77

IF Usage: 77

Extract Usage: 78

$SUBCOUNT. 78

IF Usage: 78

Extract Usage: 78

Examples for $counter and $subcount: 78

$SIGNED.. 79

IF Usage: 79

Extract Usage: 79

$LEADZEROZ (Works on Display-type fields) 79

If Usage: 79

Extract Usage: 79

Data Examples: (Using above code) 79

Arithmetic Operations 79

+ - * / mod. 79

If Usage: 80

Extract Usage: 80

Conversion/Formatting. 80

$NUMBER. 80

If Usage: 80

Extract Usage: 80

Data Examples: 80

$EDIT. 80

If Usage: 81

Extract Usage: 81

Data Examples: 81

Other Functions 81

$LOOKUP. 81

If Usage: 81

Extract Usage: 81

$READ. 81

If Usage: 82

$INRECNUM.. 82

If Usage: 82

Extract Usage: 82

Date Functions 82

$TODAY. 82

If Usage: 82

Extract Usage: 82

$DATE. 82

If Usage: 83

Extract Usage: 83

$INVALID.. 83

If Usage: 83

Extract Usage: 83

$STDDATE. 83

If Usage: 83

Extract Usage: 83

$DAYS. 83

If Usage: 84

Extract Usage: 84

$MONTH.. 84

If Usage: 84

Extract Usage: 84

Suprtool Commands  85

General Notes 85

Abbreviating. 85

Uppercase or Lowercase 85

Multiple Commands per Line. 85

Continuation. 86

Comments on Command Lines 86

OS Commands 87

Calculator 87

Control-Y Interrupt 87

Add Command  [Add] 88

Notes 88

Examples 88

Base Command  [BA] 90

Before Command  [B] 92

Chain Command  [C] 94

Clean Command  [CL] 96

Removing Bad Characters 96

Define Command  [D] 97

Delete Command  [DEL] 102

Do Command  [DO] 104

Duplicate Command  [DU] 105

Edit Command  [ED] 110

Exit Command  [E] 111

Export Command  [EXP] 113

Extract Command  [EXT] 114

Constants 114

Dates 116

Range of Fields 118

Numeric Expressions 119

$SubTotal Function. 121

$Total Function. 121

$Counter Function. 121

String Expressions 122

Splitting Variable Length Strings 123

Cleaning your Data 124

Un-printables 125

Clean Command Syntax. 125

Setting the Clean Character 125

Cleaning a Field. 125

Cleaning your data 126

Extract from a Table 126

Data Conversion. 127

$Number Function. 128

Numeric to Byte Conversion. 129

$Edit Function. 130

Placeholders and Format Characters 130

Byte-Type Formatting. 130

Z-placeholder for byte-fields 131

Overflow and limits 131

Numeric field edit-masks 132

Signs 132

Decimal Places 133

Data and Edit mask: 133

Currency and Dollar signs 133

Overflow and floating dollar 134

Set CurrencySymbol 134

Overflow and limits 134

Restrictions 134

Form Command  [F] 137

Get Command  [G] 140

Help Command  [H] 142

If Command  [IF] 143

Expressions 143

Constants 146

Subscripts 147

Numeric Expressions 148

String Expressions 150

Date Selection. 153

Long Expressions 158

Input Command  [I] 161

Item Command  [IT] 163

Date Formats 163

Decimal Places 166

Notes 167

Key Command  [K] 169

Link Command  [LIN] 171

List Command  [L] 172

Format 172

LaserJet Listings 173

Headings in Listings 174

Simple Reports 175

List Device 176

List File. 176

Listredo Command  [LISTREDO] 179

Numrecs Command  [N] 180

Open Command  [OP] 181

Remote Databases and Oracle Issues 181

Output Command  [O] 182

Put Command  [P] 188

Q Command  [Q] 189

Redo Command  [REDO] 190

Reset Command  [R] 193

Select Command  [SEL] 194

Set Command  [S] 195

Allbase. 197

Arithmetic 197

Baseclose 197

Blocksize. 197

Buffer 197

CleanChar 198

CurrencySymbol 198

Date Cutoff 198

Date ForceCentury. 199

Date IfYY2000Error 199

Date MapToPHDate8. 200

DecimalSymbol 200

Defer 200

DumpOnError 201

EditSignNeutral 201

EditStopError 201

Eofread. 201

FastRead. 201

Filecode. 202

Filename 202

Firstrec. 202

Hints 202

HPUXCmdErr “<string>” 202

Ifcheck. 203

Ignore 203

InitExtents 203

ItemAbbreviateDate. 203

ItemLock. 204

Interactive. 204

LabelledTapeRewind. 204

Limits 205

Table Size. 205

Read Only. 205

List 205

List Date 205

List PCL. 206

List Time 207

List FormFeed. 207

Lock. 208

MakeAbsent 208

NLS. 208

NumBug. 208

Openmode. 209

Oracle Rows 209

Oracle Integer 209

Oracle OpenFix. 210

Oracle PassShift 210

Oracle SpaceNull 210

Oracle ZeroNull 210

Pattern. 211

Prefetch. 211

Privmode 211

Progress 211

Prompt 212

RealMap. 212