Suprtool 5.9 for HP-UX:

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 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 5.9 for HP-UX: 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 18

Introduction. 18

Suprtool Components 18

STExport - Data Export Utility. 18

Suprlink - Multidataset Access 19

Documentation. 19

Suprtool Version 5.9 21

Highlights in Suprtool 5.9. 21

Highlights in Suprtool 5.8. 21

Highlights in Suprtool 5.7. 21

Highlights in Suprtool 5.6. 22

Highlights in Suprtool 5.5. 22

Highlights in HP-UX version 5.4.01. 23

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) 86

Extract Usage (target: Byte type fields) 86

Data Examples: 86

$UPPER (Works on Byte-type fields) 86

Extract Usage (target: Byte type fields) 87

Data Examples: 87

$LOWER (Works on Byte-type fields) 87

Extract Usage: 87

Data Examples: 87

$PROPER (Works on Byte-type fields) 87

Extract Usage: 88

Data Examples: 88

$SPLIT (Works on Byte-type fields) 88

Extract Usage: 88

Data Examples: 88

Data Examples: 88

$FINDCLEAN (Works on Byte-type fields) 89

$CLEAN (Works on Byte-type fields) 89

If Usage: (Not commonly used) 89

Extract Usage: 89

Data Examples: 89

$TRANSLATE (Works on Byte-type fields) 89

Extract Usage: 90

Data Examples: (Using above code) 90

Extract Usage: 90

Extract Usage: 90

String Addition. 90

Extract Usage: 91

Data Result: 91

Numeric Functions 91

Extract Usage: 91

Extract Usage: 91

Extract Usage: 92

Extract Usage: 93

Example of $TOTAL and $SUBTOTAL. 93

Extract Usage: 94

Extract Usage: 94

Examples for $counter and $subcount: 94

Extract Usage: 95

Arithmetic Operations 95

+ - * / mod. 95

Extract Usage: 95

Conversion/Formatting. 95

Extract Usage: 96

Data Examples: 96

Extract Usage: 96

Data Examples: 96

Other Functions 97

Extract Usage: 97

Date Functions 98

Extract Usage: 98

Extract Usage: 98

Extract Usage: 98

Extract Usage: 99

Extract Usage: 99

Extract Usage: 100

Suprtool Commands 102

General Notes 102

Abbreviating. 102

Uppercase or Lowercase 102

Multiple Commands per Line 102

Continuation. 103

Comments on Command Lines 103

HP-UX Commands 104

Control-Y Interrupt 104

Add Command [Add] 105

Base Command [BA] 107

Before Command [B] 109

Chain Command [C] 111

Clean Command [CL] 113

Removing Bad Characters 113

Define Command [D] 114

Delete Command [DEL] 119

Do Command [DO] 121

Duplicate Command [DU] 122

Edit Command [ED] 127

Exit Command [E] 128

Export Command [EXP] 130

Extract Command [EXT] 131

Range of Fields 135

Numeric Expressions 137

$SubTotal Function. 138

$Total Function. 139

$Counter Function. 139

String Expressions 140

Splitting Variable Length Strings 141

Cleaning your Data 142

Un-printables 142

Clean Command Syntax. 143

Setting the Clean Character 143

Cleaning a Field. 143

Cleaning your data 143

Extract from a Table 144

Data Conversion. 145

$Number Function. 146

Numeric to Byte Conversion. 147

$Edit Function. 148

Placeholders and Format Characters 148

Byte-Type Formatting. 148

Z-placeholder for byte-fields 149

Overflow and limits 149

Numeric field edit-masks 150

Decimal Places 151

Data and Edit mask: 151

Currency and Dollar signs 151

Overflow and floating dollar 152

Set CurrencySymbol 152

Overflow and limits 152

Restrictions 152

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

InitExtents 222

ItemAbbreviateDate 222

Interactive 223

LabelledTapeRewind. 223

List FormFeed. 226