Suprtool 6.3 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 

 

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

User Manual 1

Program and manual copyright © 1981-2021 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.3. 23

Highlights in Suprtool 6.2. 23

Highlights in Suprtool 6.1. 24

Highlights in Suprtool 6.0. 24

Highlights in Suprtool 5.9. 24

Installing Suprtool 26

Overview. 26

Who Needs To Use These Instructions 26

Instructions for HP-UX.. 26

Instructions for AMXW.. 26

Suprtool Roadmap for HP-UX   27

Road Map to Suprtool on HP-UX. 27

Suprtool for HP-UX. 27

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

Suprtool for AMXW.. 27

Quick Start Guide for Suprtool 28

How to Run Suprtool 28

What is a Task? 28

Copying Files 28

Copying One File. 28

Appending to a File. 29

Fields in Data Files 29

What is a Self-Describing File? 29

Creating an SD File. 29

Define Fields in a Data File 29

Create an SD File from a Data File. 30

Repeating Commands 30

Repeating a Command. 30

Selecting Database Records 31

Select All Records 31

Look at the First Few Records 31

Selecting by Criteria 32

Simple Criteria. 32

Complex Criteria. 32

String of Digits 32

Selecting by Date 32

Select by Today's Date 33

Select by Particular Date. 33

Select by Year 33

Select Prior Month. 33

Selecting by Lists of Values 34

Finding Data Based on a List 34

Finding Data Based on a File 34

Finding Data Based on Another Table’s Criteria 35

Finding Data in a Data File 35

Sorting Database Records 35

Sort Records 35

Sort Records in Descending Order 36

Sort by Multiple Keys 36

Duplicate Records 36

Report without Duplicate Records 36

Report Only the Duplicate Records 37

Report Only the Unique Records 37

Report Only the Duplicates and Their Originals 38

Deleting Duplicate Data File Records 38

Decimal Places 39

Converting Numbers 39

Counts and Subtotals 40

Count and Subtotal on Sort Keys 40

Sort by Count or Subtotal 40

Total by Field. 41

Running Totals 41

Running SubTotals 41

Listing Records 42

Changing the Output Record Format 42

Producing a Condensed Table Listing. 43

Simple Reports 43

Your First Report 43

Column Headings 44

Printing Mailing Labels 44

Running Suprtool under HP-UX   47

Running Suprtool 47

Configuring Different Shells 47

Bourne and Korn Shells 47

C Shell 47

Setting Up a PATH for Suprtool 48

Bourne and Korn Shells 48

C Shell 48

Dynamic Loading. 48

Control Characters and stty. 50

Suprmgr Configuration Files 50

On-Line vs. Batch Access 51

Command Line Options 51

Initial Command Line:  -ccmdstring. 51

Default Outcount File Name:  -oc. 51

Exit with Verify:  -v. 52

Combining -c and -v. 52

Loader Warnings 52

HP-UX Notes 52

Shell Commands 52

Hardcoded File Names and ROBELLE Variable. 53

ROBELLE Variable. 53

/opt/robelle/suprmgr 53

/opt/robelle/help/suprtool 53

Outcount File 53

Differences Between MPE and HP-UX. 54

Record Length. 54

Line Feeds 54

Duplicate Output Files 54

Classic Reals 54

Input from Stdlist 55

Missing Features 55

Suprtool and AMXW    57

What is AMXW.. 57

What is Suprtool for AMXW.. 57

Running Suprtool 57

Symbolic Links and running Supramxw. 57

Suprtool/AMXW.. 58

Form Command. 58

Numrecs Command. 58

Output Command. 58

Temporary Files 59

Appending Records 59

Table operations 59

Variable Substitution. 59

Set Commands 59

Command Details for AMXW    60

AMXW.. 60

Numrecs Command  [N] 61

Set Commands 62

AMXW Externalsd. 62

AMXW PerfWrite. 62

Filecode. 62

Squeeze 63

Suprtool Issues and Solutions  64

A Suprtool Task. 64

Input Choices 64

Processing Selections 64

Output Choices 64

Large File Support 65

Suprtool and Allbase. 65

Data-Types 65

Date and Time Types 65

Restrictions 66

Suprtool and Oracle. 66

Data-Types 66

Number Data-Type 67

Order By vs. Sort 67

Restrictions 67

SDUnix Utility. 67

Installation. 68

SDUnix Parameters 69

LF vs. NOLF. 69

Examples 69

Link vs. Query. 70

Suprtool and Self-Describing Files 70

Create an SD File from a Table. 70

Create an SD File from a Data File. 70

SD Files as Input 71

Listing SD Files 71

Decimal Places and Date Formats 71

Extended Field Names 71

Restrictions of SD Files 72

Suprtool and Sorting Files 72

Suprtool and Personal Computers 72

Downloading to the PC. 72

Decimal Places 73

Spreadsheets 73

Suprtool and PowerHouse Applications 73

Suprtool with Quiz/QTP. 73

Step 1: Create a Subfile with Quiz 74

Step 2: Output Erase in Suprtool 74

Step 3: Report with Quiz 74

Using QTP to Create Subfiles 74

Creating Subfile with Script File. 74

Quiz: Generating Suprtool Commands 75

Year 2000 Solutions with Suprtool 75

What If I Have Four-Digit Years? 75

What does Set Date Cutoff do?. 76

Stddate and Set Date Cutoff 76

What does Set Date ForceCentury do?. 76

What If I Have Two-Digit Years? 77

What Is Wrong with Two-Digit Years? 77

How Do $Today and $Date Work? 78

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

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

aammdd Date Format 79

Invalid Dates 79

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 81

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

Year 2000 Testing. 83

Performance Issues 84

Eloquence Performance 84

Sort Performance 84

Oracle Performance 84

Analyzing Performance Data. 85

Variable Substitution. 85

Suprtool Functions 86

UC4/Scripting and Functions 86

String/Byte Functions 86

$TRIM (Works on byte type fields) 86

If Usage: 86

Extract Usage (target: Byte type fields) 87

Example: 87

Data Examples Before and After: 87

$LTRIM (Works on Byte type fields) 87

If Usage: 87

Extract Usage (target: Byte type fields) 87

Example: 87

Data Examples before and after: 87

$RTRIM (Works on Byte type fields) 87

If Usage: 88

Extract Usage (target: Byte type fields) 88

Example: 88

Data Examples: 88

Data Result 88

$UPPER (Works on Byte-type fields) 88

If Usage: 88

Extract Usage (target: Byte type fields) 88

Example: 88

Data Examples: 88

$LOWER (Works on Byte-type fields) 89

If Usage: 89

Extract Usage: 89

Example: 89

Data Examples: 89

$PROPER (Works on Byte-type fields) 89

If Usage: 89

Extract Usage: 89

Example: 89

Data Examples: 89

$SPLIT (Works on Byte-type fields) 90

If Usage: 90

Extract Usage: 90

Data Examples: 90

Data Examples: 90

$FINDCLEAN (Works on Byte-type fields) 90

If Usage: 90

$CLEAN (Works on Byte-type fields) 90

If Usage: (Not commonly used) 91

Extract Usage: 91

Example: 91

Data Examples: 91

$TRANSLATE (Works on Byte-type fields) 91

If Usage: 91

Extract Usage: 91

Data Examples: (Using above code) 91

$JUSTIFYL (Works on Byte-type fields) 91

If Usage: 92

Extract Usage: 92

Data Examples: (Using above code) 92

$JUSTIFYR (Works on Byte-type fields) 92

If Usage: 92

Extract Usage: 92

Data Examples: (Using above code) 92

$LEADZEROB (Works on Byte-type fields) 92

If Usage: 92

Extract Usage: 92

Data Examples: (Using above code) 92

$RESPACE (Works on Byte-type fields) 93

If Usage: 93

Extract Usage: 93

Data Examples: (Using above code) 93

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

If Usage: 93

Extract Usage: 93

$ETOA.. 93

Extract Usage: 93

$ATOE. 93

Extract Usage: 94

String Addition. 94

Extract Usage: 94

Example: 94

Data Result: 94

Numeric Functions 94

$TRUNCATE. 94

If Usage: 94

Extract Usage: 94

$ABS. 95

IF Usage: 95

Extract Usage: 95

$TOTAL. 95

IF Usage: 95

Extract Usage: 95

$SUBTOTAL. 95

IF Usage: 95

Extract Usage: 96

Example of $TOTAL and $SUBTOTAL. 96

$COUNTER. 96

IF Usage: 96

Extract Usage: 97

$SUBCOUNT. 97

IF Usage: 97

Extract Usage: 97

Examples for $counter and $subcount: 97

$SIGNED.. 98

IF Usage: 98

Extract Usage: 98

$LEADZEROZ (Works on Display-type fields) 98

If Usage: 98

Extract Usage: 98

Data Examples: (Using above code) 98

Arithmetic Operations 98

+ - * / mod. 98

If Usage: 98

Extract Usage: 98

Conversion/Formatting. 99

$NUMBER. 99

If Usage: 99

Extract Usage: 99

Data Examples: 99

$EDIT. 99

If Usage: 100

Extract Usage: 100

Data Examples: 100

Other Functions 100

$LOOKUP. 100

If Usage: 100

Extract Usage: 100

$READ. 100

If Usage: 101

$INRECNUM.. 101

If Usage: 101

Extract Usage: 101

Date Functions 101

$TODAY. 101

If Usage: 101

Extract Usage: 101

$DATE. 101

If Usage: 102

Extract Usage: 102

$INVALID.. 102

If Usage: 102

Extract Usage: 102

$STDDATE. 102

If Usage: 102

Extract Usage: 102

$DAYS. 103

If Usage: 103

Extract Usage: 103

$MONTH.. 103

If Usage: 103

Extract Usage: 103

Suprtool Commands  105

General Notes 105

Abbreviating. 105

Uppercase or Lowercase 105

Multiple Commands per Line. 105

Continuation. 106

Comments on Command Lines 106

HP-UX Commands 107

Calculator 107

Control-Y Interrupt 107

Add Command  [Add] 108

Notes 108

Examples 108

Base Command  [BA] 110

Before Command  [B] 112

Chain Command  [C] 114

Clean Command  [CL] 116

Removing Bad Characters 116

Define Command  [D] 117

Delete Command  [DEL] 122

Do Command  [DO] 124

Duplicate Command  [DU] 125

Edit Command  [ED] 130

Exit Command  [E] 131

Export Command  [EXP] 133

Extract Command  [EXT]