Suprtool 6.0 for HP-UX:

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 are trademarks 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 6.0 for HP-UX: 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 18

Introduction. 18

Suprtool Components 18

STExport - Data Export Utility. 18

Suprlink - Multidataset Access 19

Documentation. 19

Suprtool Version 6.0 21

Highlights in Suprtool 6.0. 21

Highlights in Suprtool 5.9. 21

Highlights in Suprtool 5.8. 21

Highlights in Suprtool 5.7. 22

Highlights in Suprtool 5.6. 22

Installing Suprtool 24

Who Needs To Use These Instructions 24

Instructions for HP-UX. 24

Instructions for AMXW.. 24

Suprtool Roadmap for HP-UX 25

Road Map to Suprtool on HP-UX. 25

Suprtool for HP-UX. 25

Suprtool for HP-UX, with Dynamic Image loading. 25

Suprtool for AMXW.. 25

Quick Start Guide for Suprtool 26

How to Run Suprtool 26

What is a Task? 26

Copying Files 27

Copying One File 27

Appending to a File 27

Fields in Data Files 27

What is a Self-Describing File? 27

Creating an SD File 27

Define Fields in a Data File 27

Create an SD File from a Data File 28

Repeating Commands 28

Repeating a Command. 28

Selecting Database Records 29

Select All Records 29

Look at the First Few Records 29

Selecting by Criteria 30

Simple Criteria 30

Complex Criteria 30

String of Digits 30

Selecting by Date 30

Select by Today's Date 31

Select by Particular Date 31

Select by Year 31

Select Prior Month. 31

Selecting by Lists of Values 32

Finding Data Based on a List 32

Finding Data Based on a File 32

Finding Data Based on Another Table’s Criteria 33

Finding Data in a Data File 33

Sorting Database Records 33

Sort Records 33

Sort Records in Descending Order 34

Sort by Multiple Keys 34

Duplicate Records 34

Report without Duplicate Records 34

Report Only the Duplicate Records 35

Report Only the Unique Records 35

Report Only the Duplicates and Their Originals 36

Deleting Duplicate Data File Records 36

Decimal Places 37

Converting Numbers 37

Counts and Subtotals 38

Count and Subtotal on Sort Keys 38

Sort by Count or Subtotal 38

Total by Field. 39

Running Totals 39

Running SubTotals 39

Listing Records 40

Changing the Output Record Format 40

Producing a Condensed Table Listing. 41

Simple Reports 41

Your First Report 41

Column Headings 42

Printing Mailing Labels 42

Running Suprtool under HP-UX 45

Running Suprtool 45

Configuring Different Shells 45

Bourne and Korn Shells 45

Setting Up a PATH for Suprtool 46

Bourne and Korn Shells 46

Dynamic Loading. 46

Control Characters and stty. 48

Suprmgr Configuration Files 48

On-Line vs. Batch Access 49

Command Line Options 49

Initial Command Line: -ccmdstring. 49

Default Outcount File Name: -oc 49

Exit with Verify: -v. 50

Combining -c and -v. 50

Loader Warnings 50

Shell Commands 50

Hardcoded File Names and ROBELLE Variable 51

ROBELLE Variable 51

/opt/robelle/suprmgr 51

/opt/robelle/help/suprtool 51

Outcount File 51

Differences Between MPE and HP-UX. 52

Record Length. 52

Duplicate Output Files 52

Classic Reals 52

Input from Stdlist 53

Missing Features 53

Suprtool and AMXW 55

What is AMXW.. 55

What is Suprtool for AMXW.. 55

Running Suprtool 55

Symbolic Links and running Supramxw. 55

Suprtool/AMXW.. 56

Form Command. 56

Numrecs Command. 56

Output Command. 56

Temporary Files 57

Appending Records 57

Table operations 57

Variable Substitution. 57

Set Commands 57

Command Details for AMXW 58

Numrecs Command [N] 59

Set Commands 60

AMXW Externalsd. 60

AMXW PerfWrite 60

Suprtool Issues and Solutions 62

A Suprtool Task. 62

Input Choices 62

Processing Selections 62

Output Choices 62

Large File Support 63

Suprtool and Allbase 63

Date and Time Types 64

Restrictions 64

Suprtool and Oracle 64

Number Data-Type 65

Order By vs. Sort 65

Restrictions 65

SDUnix Utility. 66

Installation. 66

SDUnix Parameters 67

LF vs. NOLF. 67

Link vs. Query. 68

Suprtool and Self-Describing Files 68

Create an SD File from a Table 68

Create an SD File from a Data File 68

SD Files as Input 69

Listing SD Files 69

Decimal Places and Date Formats 69

Extended Field Names 69

Restrictions of SD Files 70

Suprtool and Sorting Files 70

Suprtool and Personal Computers 70

Downloading to the PC. 70

Decimal Places 71

Spreadsheets 71

Suprtool and PowerHouse Applications 71

Suprtool with Quiz/QTP. 71

Step 1: Create a Subfile with Quiz 72

Step 2: Output Erase in Suprtool 72

Step 3: Report with Quiz 72

Using QTP to Create Subfiles 72

Creating Subfile with Script File 72

Quiz: Generating Suprtool Commands 73

Year 2000 Solutions with Suprtool 73

What If I Have Four-Digit Years? 73

What does Set Date Cutoff do? 74

Stddate and Set Date Cutoff 74

What does Set Date ForceCentury do? 74

What If I Have Two-Digit Years? 75

What Is Wrong with Two-Digit Years? 75

How Do $Today and $Date Work? 76

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

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

aammdd Date Format 77

Invalid Dates 77

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

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

Case 2: X6 yymmdd Data to X8 ccyymmdd. 79

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

Year 2000 Testing. 81

Performance Issues 82

Eloquence Performance 82

Sort Performance 82

Oracle Performance 82

Analyzing Performance Data 83

Variable Substitution. 83

Suprtool Functions 84

UC4/Scripting and Functions 84

String/Byte Functions 84

$TRIM (Works on byte type fields) 84

Extract Usage (target: Byte type fields) 85

Data Examples Before and After: 85

$LTRIM (Works on Byte type fields) 85

Extract Usage (target: Byte type fields) 85

Data Examples before and after: 85

$RTRIM (Works on Byte type fields) 85

Extract Usage (target: Byte type fields) 86

Data Examples: 86

$UPPER (Works on Byte-type fields) 86

Extract Usage (target: Byte type fields) 86

Data Examples: 86

$LOWER (Works on Byte-type fields) 87

Extract Usage: 87

Data Examples: 87

$PROPER (Works on Byte-type fields) 87

Extract Usage: 87

Data Examples: 87

$SPLIT (Works on Byte-type fields) 88

Extract Usage: 88

Data Examples: 88

Data Examples: 88

$FINDCLEAN (Works on Byte-type fields) 88

$CLEAN (Works on Byte-type fields) 88

If Usage: (Not commonly used) 89

Extract Usage: 89

Data Examples: 89

$TRANSLATE (Works on Byte-type fields) 89

Extract Usage: 89

Data Examples: (Using above code) 89

$JUSTIFYL (Works on Byte-type fields) 89

Extract Usage: 90

Data Examples: (Using above code) 90

$JUSTIFYR (Works on Byte-type fields) 90

Extract Usage: 90

Data Examples: (Using above code) 90

$LEADZEROB (Works on Byte-type fields) 90

Extract Usage: 90

Data Examples: (Using above code) 90

$RESPACE (Works on Byte-type fields) 91

Extract Usage: 91

Data Examples: (Using above code) 91

Extract Usage: 91

Extract Usage: 91

String Addition. 91

Extract Usage: 92

Data Result: 92

Numeric Functions 92

Extract Usage: 92

Extract Usage: 92

Extract Usage: 93

Extract Usage: 94

Example of $TOTAL and $SUBTOTAL. 94

Extract Usage: 95

Extract Usage: 95

Examples for $counter and $subcount: 95

Extract Usage: 96

$LEADZEROZ (Works on Display-type fields) 96

Extract Usage: 96

Data Examples: (Using above code) 96

Arithmetic Operations 96

+ - * / mod. 96

Extract Usage: 96

Conversion/Formatting. 97

Extract Usage: 97

Data Examples: 97

Extract Usage: 98

Data Examples: 98

Other Functions 98

Extract Usage: 98

Extract Usage: 99

Date Functions 99

Extract Usage: 99

Extract Usage: 100

Extract Usage: 100

Extract Usage: 100

Extract Usage: 101

Extract Usage: 101

Suprtool Commands 103

General Notes 103

Abbreviating. 103

Uppercase or Lowercase 103

Multiple Commands per Line 103

Continuation. 104

Comments on Command Lines 104

HP-UX Commands 105

Control-Y Interrupt 105

Add Command [Add] 106

Base Command [BA] 108

Before Command [B] 110

Chain Command [C] 112

Clean Command [CL] 114

Removing Bad Characters 114

Define Command [D] 115

Delete Command [DEL] 120

Do Command [DO] 122

Duplicate Command [DU] 123

Edit Command [ED] 128

Exit Command [E] 129

Export Command [EXP] 131

Extract Command [EXT] 132

Range of Fields 136

Numeric Expressions 138

$SubTotal Function. 139

$Total Function. 140

$Counter Function. 140

String Expressions 141

Splitting Variable Length Strings 142

Cleaning your Data 143

Un-printables 143

Clean Command Syntax. 144

Setting the Clean Character 144

Cleaning a Field. 144

Cleaning your data 144

Extract from a Table 145

Data Conversion. 146

$Number Function. 147

Numeric to Byte Conversion. 148

$Edit Function. 149

Placeholders and Format Characters 149

Byte-Type Formatting. 149

Z-placeholder for byte-fields 150

Overflow and limits 150

Numeric field edit-masks 150

Decimal Places 151

Data and Edit mask: 152

Currency and Dollar signs 152

Overflow and floating dollar 152

Set CurrencySymbol 153

Overflow and limits 153

Restrictions 153

Form Command [F] 155

Get Command [G] 158

Help Command [H] 160

If Command [IF] 161

Expressions 161

Numeric Expressions 166

String Expressions 168

Date Selection. 171

Long Expressions 176

Input Command [I] 179

Item Command [IT] 181

Date Formats 181

Decimal Places 184

Key Command [K] 187

Link Command [LIN] 189

List Command [L] 190

LaserJet Listings 191

Headings in Listings 192

Simple Reports 193

List Device 194

Listredo Command [LISTREDO] 197

Numrecs Command [N] 198

Open Command [OP] 199

Remote Databases and Oracle Issues 199

Output Command [O] 200

Put Command [P] 206

Q Command [Q] 207

Redo Command [REDO] 208

Reset Command [R] 211

Select Command [SEL] 212

Set Command [S] 213

CurrencySymbol 216

Date Cutoff 217

Date ForceCentury. 218

Date IfYY2000Error 218

Date MapToPHDate8. 219

DecimalSymbol 219

DumpOnError 219

EditStopError 219

HPUXCmdErr “<string>” 221