Suprtool 6.2 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 

 

Program and manual copyright © 1981-2020 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.2 for HP-UX: 1

User Manual 1

Program and manual copyright © 1981-2020 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

STExport - Data Export Utility. 20

Rport - Data Reporting Utility. 20

Suprlink - Multidataset Access 21

Documentation. 21

Notation. 21

Highlights in Suprtool 23

Highlights in Suprtool 6.2. 23

Highlights in Suprtool 6.1. 23

Highlights in Suprtool 6.0. 24

Highlights in Suprtool 5.9. 24

Installing Suprtool 25

Overview. 25

Who Needs To Use These Instructions 25

Instructions for HP-UX.. 25

Instructions for AMXW.. 25

Suprtool Roadmap for HP-UX   26

Road Map to Suprtool on HP-UX. 26

Suprtool for HP-UX. 26

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

Suprtool for AMXW.. 26

Quick Start Guide for Suprtool 27

How to Run Suprtool 27

What is a Task? 27

Copying Files 27

Copying One File. 27

Appending to a File. 28

Fields in Data Files 28

What is a Self-Describing File? 28

Creating an SD File. 28

Define Fields in a Data File 28

Create an SD File from a Data File. 29

Repeating Commands 29

Repeating a Command. 29

Selecting Database Records 30

Select All Records 30

Look at the First Few Records 30

Selecting by Criteria 31

Simple Criteria. 31

Complex Criteria. 31

String of Digits 31

Selecting by Date 31

Select by Today's Date 32

Select by Particular Date. 32

Select by Year 32

Select Prior Month. 32

Selecting by Lists of Values 33

Finding Data Based on a List 33

Finding Data Based on a File 33

Finding Data Based on Another Table’s Criteria 34

Finding Data in a Data File 34

Sorting Database Records 34

Sort Records 34

Sort Records in Descending Order 35

Sort by Multiple Keys 35

Duplicate Records 35

Report without Duplicate Records 35

Report Only the Duplicate Records 36

Report Only the Unique Records 36

Report Only the Duplicates and Their Originals 37

Deleting Duplicate Data File Records 37

Decimal Places 38

Converting Numbers 38

Counts and Subtotals 39

Count and Subtotal on Sort Keys 39

Sort by Count or Subtotal 39

Total by Field. 40

Running Totals 40

Running SubTotals 40

Listing Records 41

Changing the Output Record Format 41

Producing a Condensed Table Listing. 42

Simple Reports 42

Your First Report 42

Column Headings 43

Printing Mailing Labels 43

Running Suprtool under HP-UX   45

Running Suprtool 45

Configuring Different Shells 45

Bourne and Korn Shells 45

C Shell 45

Setting Up a PATH for Suprtool 46

Bourne and Korn Shells 46

C Shell 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

HP-UX Notes 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

Line Feeds 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

AMXW.. 58

Numrecs Command  [N] 59

Set Commands 60

AMXW Externalsd. 60

AMXW PerfWrite. 60

Filecode. 60

Squeeze 61

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

Data-Types 63

Date and Time Types 63

Restrictions 64

Suprtool and Oracle. 64

Data-Types 64

Number Data-Type 65

Order By vs. Sort 65

Restrictions 65

SDUnix Utility. 65

Installation. 66

SDUnix Parameters 67

LF vs. NOLF. 67

Examples 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. 78

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

If Usage: 84

Extract Usage (target: Byte type fields) 85

Example: 85

Data Examples Before and After: 85

$LTRIM (Works on Byte type fields) 85

If Usage: 85

Extract Usage (target: Byte type fields) 85

Example: 85

Data Examples before and after: 85

$RTRIM (Works on Byte type fields) 85

If Usage: 86

Extract Usage (target: Byte type fields) 86

Example: 86

Data Examples: 86

Data Result 86

$UPPER (Works on Byte-type fields) 86

If Usage: 86

Extract Usage (target: Byte type fields) 86

Example: 86

Data Examples: 86

$LOWER (Works on Byte-type fields) 87

If Usage: 87

Extract Usage: 87

Example: 87

Data Examples: 87

$PROPER (Works on Byte-type fields) 87

If Usage: 87

Extract Usage: 87

Example: 87

Data Examples: 87

$SPLIT (Works on Byte-type fields) 88

If Usage: 88

Extract Usage: 88

Data Examples: 88

Data Examples: 88

$FINDCLEAN (Works on Byte-type fields) 88

If Usage: 88

$CLEAN (Works on Byte-type fields) 88

If Usage: (Not commonly used) 89

Extract Usage: 89

Example: 89

Data Examples: 89

$TRANSLATE (Works on Byte-type fields) 89

If Usage: 89

Extract Usage: 89

Data Examples: (Using above code) 89

$JUSTIFYL (Works on Byte-type fields) 89

If Usage: 90

Extract Usage: 90

Data Examples: (Using above code) 90

$JUSTIFYR (Works on Byte-type fields) 90

If Usage: 90

Extract Usage: 90

Data Examples: (Using above code) 90

$LEADZEROB (Works on Byte-type fields) 90

If Usage: 90

Extract Usage: 90

Data Examples: (Using above code) 90

$RESPACE (Works on Byte-type fields) 91

If Usage: 91

Extract Usage: 91

Data Examples: (Using above code) 91

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

If Usage: 91

Extract Usage: 91

$ETOA.. 91

Extract Usage: 91

$ATOE. 91

Extract Usage: 92

String Addition. 92

Extract Usage: 92

Example: 92

Data Result: 92

Numeric Functions 92

$TRUNCATE. 92

If Usage: 92

Extract Usage: 92

$ABS. 93

IF Usage: 93

Extract Usage: 93

$TOTAL. 93

IF Usage: 93

Extract Usage: 93

$SUBTOTAL. 93

IF Usage: 93

Extract Usage: 94

Example of $TOTAL and $SUBTOTAL. 94

$COUNTER. 94

IF Usage: 94

Extract Usage: 95

$SUBCOUNT. 95

IF Usage: 95

Extract Usage: 95

Examples for $counter and $subcount: 95

$SIGNED.. 96

IF Usage: 96

Extract Usage: 96

$LEADZEROZ (Works on Display-type fields) 96

If Usage: 96

Extract Usage: 96

Data Examples: (Using above code) 96

Arithmetic Operations 96

+ - * / mod. 96

If Usage: 96

Extract Usage: 96

Conversion/Formatting. 97

$NUMBER. 97

If Usage: 97

Extract Usage: 97

Data Examples: 97

$EDIT. 97

If Usage: 98

Extract Usage: 98

Data Examples: 98

Other Functions 98

$LOOKUP. 98

If Usage: 98

Extract Usage: 98

$READ. 98

If Usage: 99

$INRECNUM.. 99

If Usage: 99

Extract Usage: 99

Date Functions 99

$TODAY. 99

If Usage: 99

Extract Usage: 99

$DATE. 99

If Usage: 100

Extract Usage: 100

$INVALID.. 100

If Usage: 100

Extract Usage: 100

$STDDATE. 100

If Usage: 100

Extract Usage: 100

$DAYS. 101

If Usage: 101

Extract Usage: 101

$MONTH.. 101

If 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

Calculator 105

Control-Y Interrupt 105

Add Command  [Add] 106

Notes 106

Examples 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

Constants 132

Dates 134

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