Suprtool 6.1 for HP-UX:

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

Introduction. 18

Suprtool Components 18

STExport - Data Export Utility. 18

Suprlink - Multidataset Access 19

Documentation. 19

Notation. 19

Highlights in Suprtool 21

Highlights in Suprtool 6.1. 21

Highlights in Suprtool 6.0. 21

Highlights in Suprtool 5.9. 21

Installing Suprtool 22

Overview. 22

Who Needs To Use These Instructions 22

Instructions for HP-UX.. 22

Instructions for AMXW.. 23

Suprtool Roadmap for HP-UX   23

Road Map to Suprtool on HP-UX. 23

Suprtool for HP-UX. 23

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

Suprtool for AMXW.. 23

Quick Start Guide for Suprtool 24

How to Run Suprtool 24

What is a Task? 24

Copying Files 25

Copying One File. 25

Appending to a File. 25

Fields in Data Files 25

What is a Self-Describing File? 25

Creating an SD File. 25

Define Fields in a Data File 25

Create an SD File from a Data File. 26

Repeating Commands 26

Repeating a Command. 26

Selecting Database Records 27

Select All Records 27

Look at the First Few Records 27

Selecting by Criteria 28

Simple Criteria. 28

Complex Criteria. 28

String of Digits 28

Selecting by Date 28

Select by Today's Date 29

Select by Particular Date. 29

Select by Year 29

Select Prior Month. 29

Selecting by Lists of Values 30

Finding Data Based on a List 30

Finding Data Based on a File 30

Finding Data Based on Another Table’s Criteria 31

Finding Data in a Data File 31

Sorting Database Records 31

Sort Records 31

Sort Records in Descending Order 32

Sort by Multiple Keys 32

Duplicate Records 32

Report without Duplicate Records 32

Report Only the Duplicate Records 33

Report Only the Unique Records 33

Report Only the Duplicates and Their Originals 34

Deleting Duplicate Data File Records 34

Decimal Places 35

Converting Numbers 35

Counts and Subtotals 36

Count and Subtotal on Sort Keys 36

Sort by Count or Subtotal 36

Total by Field. 37

Running Totals 37

Running SubTotals 37

Listing Records 38

Changing the Output Record Format 38

Producing a Condensed Table Listing. 39

Simple Reports 39

Your First Report 39

Column Headings 40

Printing Mailing Labels 40

Running Suprtool under HP-UX   43

Running Suprtool 43

Configuring Different Shells 43

Bourne and Korn Shells 43

C Shell 43

Setting Up a PATH for Suprtool 44

Bourne and Korn Shells 44

C Shell 44

Dynamic Loading. 44

Control Characters and stty. 46

Suprmgr Configuration Files 46

On-Line vs. Batch Access 47

Command Line Options 47

Initial Command Line:  -ccmdstring. 47

Default Outcount File Name:  -oc. 47

Exit with Verify:  -v. 48

Combining -c and -v. 48

Loader Warnings 48

HP-UX Notes 48

Shell Commands 48

Hardcoded File Names and ROBELLE Variable. 49

ROBELLE Variable. 49

/opt/robelle/suprmgr 49

/opt/robelle/help/suprtool 49

Outcount File 49

Differences Between MPE and HP-UX. 50

Record Length. 50

Line Feeds 50

Duplicate Output Files 50

Classic Reals 50

Input from Stdlist 51

Missing Features 51

Suprtool and AMXW    53

What is AMXW.. 53

What is Suprtool for AMXW.. 53

Running Suprtool 53

Symbolic Links and running Supramxw. 53

Suprtool/AMXW.. 54

Form Command. 54

Numrecs Command. 54

Output Command. 54

Temporary Files 55

Appending Records 55

Table operations 55

Variable Substitution. 55

Set Commands 55

Command Details for AMXW    56

AMXW.. 56

Numrecs Command  [N] 57

Set Commands 58

AMXW Externalsd. 58

AMXW PerfWrite. 58

Filecode. 58

Squeeze 59

Suprtool Issues and Solutions  60

A Suprtool Task. 60

Input Choices 60

Processing Selections 60

Output Choices 60

Large File Support 61

Suprtool and Allbase. 61

Data-Types 61

Date and Time Types 62

Restrictions 62

Suprtool and Oracle. 62

Data-Types 62

Number Data-Type 63

Order By vs. Sort 63

Restrictions 63

SDUnix Utility. 64

Installation. 64

SDUnix Parameters 65

LF vs. NOLF. 65

Examples 65

Link vs. Query. 66

Suprtool and Self-Describing Files 66

Create an SD File from a Table. 66

Create an SD File from a Data File. 66

SD Files as Input 67

Listing SD Files 67

Decimal Places and Date Formats 67

Extended Field Names 67

Restrictions of SD Files 68

Suprtool and Sorting Files 68

Suprtool and Personal Computers 68

Downloading to the PC. 68

Decimal Places 69

Spreadsheets 69

Suprtool and PowerHouse Applications 69

Suprtool with Quiz/QTP. 69

Step 1: Create a Subfile with Quiz 70

Step 2: Output Erase in Suprtool 70

Step 3: Report with Quiz 70

Using QTP to Create Subfiles 70

Creating Subfile with Script File. 70

Quiz: Generating Suprtool Commands 71

Year 2000 Solutions with Suprtool 71

What If I Have Four-Digit Years? 71

What does Set Date Cutoff do?. 72

Stddate and Set Date Cutoff 72

What does Set Date ForceCentury do?. 72

What If I Have Two-Digit Years? 73

What Is Wrong with Two-Digit Years? 73

How Do $Today and $Date Work? 74

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

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

aammdd Date Format 75

Invalid Dates 75

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 77

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

Year 2000 Testing. 79

Performance Issues 80

Eloquence Performance 80

Sort Performance 80

Oracle Performance 80

Analyzing Performance Data. 81

Variable Substitution. 81

Suprtool Functions 82

UC4/Scripting and Functions 82

String/Byte Functions 82

$TRIM (Works on byte type fields) 82

If Usage: 82

Extract Usage (target: Byte type fields) 83

Example: 83

Data Examples Before and After: 83

$LTRIM (Works on Byte type fields) 83

If Usage: 83

Extract Usage (target: Byte type fields) 83

Example: 83

Data Examples before and after: 83

$RTRIM (Works on Byte type fields) 83

If Usage: 84

Extract Usage (target: Byte type fields) 84

Example: 84

Data Examples: 84

Data Result 84

$UPPER (Works on Byte-type fields) 84

If Usage: 84

Extract Usage (target: Byte type fields) 84

Example: 84

Data Examples: 84

$LOWER (Works on Byte-type fields) 85

If Usage: 85

Extract Usage: 85

Example: 85

Data Examples: 85

$PROPER (Works on Byte-type fields) 85

If Usage: 85

Extract Usage: 85

Example: 85

Data Examples: 85

$SPLIT (Works on Byte-type fields) 86

If Usage: 86

Extract Usage: 86

Data Examples: 86

Data Examples: 86

$FINDCLEAN (Works on Byte-type fields) 86

If Usage: 86

$CLEAN (Works on Byte-type fields) 86

If Usage: (Not commonly used) 87

Extract Usage: 87

Example: 87

Data Examples: 87

$TRANSLATE (Works on Byte-type fields) 87

If Usage: 87

Extract Usage: 87

Data Examples: (Using above code) 87

$JUSTIFYL (Works on Byte-type fields) 87

If Usage: 88

Extract Usage: 88

Data Examples: (Using above code) 88

$JUSTIFYR (Works on Byte-type fields) 88

If Usage: 88

Extract Usage: 88

Data Examples: (Using above code) 88

$LEADZEROB (Works on Byte-type fields) 88

If Usage: 88

Extract Usage: 88

Data Examples: (Using above code) 88

$RESPACE (Works on Byte-type fields) 89

If Usage: 89

Extract Usage: 89

Data Examples: (Using above code) 89

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

If Usage: 89

Extract Usage: 89

$ETOA.. 89

Extract Usage: 89

$ATOE. 89

Extract Usage: 90

String Addition. 90

Extract Usage: 90

Example: 90

Data Result: 90

Numeric Functions 90

$TRUNCATE. 90

If Usage: 90

Extract Usage: 90

$ABS. 91

IF Usage: 91

Extract Usage: 91

$TOTAL. 91

IF Usage: 91

Extract Usage: 91

$SUBTOTAL. 91

IF Usage: 91

Extract Usage: 92

Example of $TOTAL and $SUBTOTAL. 92

$COUNTER. 92

IF Usage: 92

Extract Usage: 93

$SUBCOUNT. 93

IF Usage: 93

Extract Usage: 93

Examples for $counter and $subcount: 93

$SIGNED.. 94

IF Usage: 94

Extract Usage: 94

$LEADZEROZ (Works on Display-type fields) 94

If Usage: 94

Extract Usage: 94

Data Examples: (Using above code) 94

Arithmetic Operations 94

+ - * / mod. 94

If Usage: 94

Extract Usage: 94

Conversion/Formatting. 95

$NUMBER. 95

If Usage: 95

Extract Usage: 95

Data Examples: 95

$EDIT. 95

If Usage: 96

Extract Usage: 96

Data Examples: 96

Other Functions 96

$LOOKUP. 96

If Usage: 96

Extract Usage: 96

$READ. 96

If Usage: 97

$INRECNUM.. 97

If Usage: 97

Extract Usage: 97

Date Functions 97

$TODAY. 97

If Usage: 97

Extract Usage: 97

$DATE. 97

If Usage: 98

Extract Usage: 98

$INVALID.. 98

If Usage: 98

Extract Usage: 98

$STDDATE. 98

If Usage: 98

Extract Usage: 98

$DAYS. 98

If Usage: 99

Extract Usage: 99

$MONTH.. 99

If Usage: 99

Extract Usage: 99

Suprtool Commands  101

General Notes 101

Abbreviating. 101

Uppercase or Lowercase 101

Multiple Commands per Line. 101

Continuation. 102

Comments on Command Lines 102

HP-UX Commands 103

Calculator 103

Control-Y Interrupt 103

Add Command  [Add] 104

Notes 104

Examples 104

Base Command  [BA] 106

Before Command  [B] 108

Chain Command  [C] 110

Clean Command  [CL] 112

Removing Bad Characters 112

Define Command  [D] 113

Delete Command  [DEL] 118

Do Command  [DO] 120

Duplicate Command  [DU] 121

Edit Command  [ED] 126

Exit Command  [E] 127

Export Command  [EXP] 129

Extract Command  [EXT] 130

Constants 130

Dates 132

Range of Fields 134

Numeric Expressions 136

$SubTotal Function. 137

$Total Function. 138

$Counter Function. 138

String Expressions 139

Splitting Variable Length Strings 140

Cleaning your Data 141

Un-printables 141

Clean Command Syntax. 142

Setting the Clean Character 142

Cleaning a Field. 142

Cleaning your data 142

Extract from a Table 143

Data Conversion. 144

$Number Function. 145

Numeric to Byte Conversion. 146

$Edit Function. 147

Placeholders and Format Characters 147

Byte-Type Formatting. 147

Z-placeholder for byte-fields 148

Overflow and limits 148

Numeric field edit-masks 148

Signs 149

Decimal Places 149

Data and Edit mask: 150

Currency and Dollar signs 150

Overflow and floating dollar 150

Set CurrencySymbol 151

Overflow and limits 151

Restrictions 151

Form Command  [F] 153

Get Command  [G] 156

Help Command  [H] 158

If Command  [IF] 159

Expressions 159

Constants 162

Subscripts 163

Numeric Expressions 164

String Expressions 166

Date Selection. 169

Long Expressions 174

Input Command  [I] 177

Item Command  [IT] 179

Date Formats 179

Decimal Places 182

Notes 183

Key Command  [K] 185

Link Command  [LIN] 187

List Command  [L] 188

Format 188

LaserJet Listings 189

Headings in Listings 190

Simple Reports 191

List Device 192