Suprtool 5.9 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 


 

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

User Manual 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

Notation. 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

Overview. 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 Tables 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

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 64

Restrictions 64

Suprtool and Oracle 64

Data-Types 64

Number Data-Type 65

Order By vs. Sort 65

Restrictions 65

SDUnix Utility. 66

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

If Usage: 85

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

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: 87

Extract Usage (target: Byte type fields) 87

Example: 87

Data Examples: 87

$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: 88

Extract Usage: 88

Example: 88

Data Examples: 88

$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) 89

If Usage: 89

$CLEAN (Works on Byte-type fields) 89

If Usage: (Not commonly used) 89

Extract Usage: 89

Example: 89

Data Examples: 89

$TRANSLATE (Works on Byte-type fields) 89

If Usage: 90

Extract Usage: 90

Data Examples: (Using above code) 90

$ETOA. 90

Extract Usage: 90

$ATOE. 90

Extract Usage: 90

String Addition. 90

Extract Usage: 91

Example: 91

Data Result: 91

Numeric Functions 91

$TRUNCATE. 91

If Usage: 91

Extract Usage: 91

$ABS. 91

IF Usage: 91

Extract Usage: 91

$TOTAL. 92

IF Usage: 92

Extract Usage: 92

$SUBTOTAL. 92

IF Usage: 92

Extract Usage: 93

Example of $TOTAL and $SUBTOTAL. 93

$COUNTER. 93

IF Usage: 93

Extract Usage: 94

$SUBCOUNT. 94

IF Usage: 94

Extract Usage: 94

Examples for $counter and $subcount: 94

$SIGNED. 95

IF Usage: 95

Extract Usage: 95

Arithmetic Operations 95

+ - * / mod. 95

If Usage: 95

Extract Usage: 95

Conversion/Formatting. 95

$NUMBER. 95

If Usage: 96

Extract Usage: 96

Data Examples: 96

$EDIT. 96

If Usage: 96

Extract Usage: 96

Data Examples: 96

Other Functions 97

$LOOKUP. 97

If Usage: 97

Extract Usage: 97

$NULL. 97

$READ. 97

If Usage: 97

Date Functions 98

$TODAY. 98

If Usage: 98

Extract Usage: 98

$DATE. 98

If Usage: 98

Extract Usage: 98

$INVALID. 98

If Usage: 98

Extract Usage: 98

$STDDATE. 99

If Usage: 99

Extract Usage: 99

$DAYS. 99

If Usage: 99

Extract Usage: 99

$MONTH. 99

If Usage: 100

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

Calculator 104

Control-Y Interrupt 104

Add Command  [Add] 105

Notes 105

Examples 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

Constants 131

Dates 133

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

Signs 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

Constants 164

Subscripts 165

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

Notes 185

Key Command  [K] 187

Link Command  [LIN] 189

List Command  [L] 190

Format 190

LaserJet Listings 191

Headings in Listings 192

Simple Reports 193

List Device 194

List File 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

Allbase 215

Arithmetic 215

Baseclose 215

Blocksize 215

Buffer 215

CleanChar 215

Comlog. 216

CurrencySymbol 216

Date Cutoff 217

Date ForceCentury. 218

Date IfYY2000Error 218

Date MapToPHDate8. 219

DecimalSymbol 219

Defer 219

DumpOnError 219

EditStopError 219

Eofread. 220

FastRead. 220

Filecode 220

Filename 220

Firstrec 221

Hints 221

HPUXCmdErr <string> 221

Ifcheck. 222

Ignore 222

InitExtents 222

ItemAbbreviateDate 222

ItemLock. 222

Interactive 223

LabelledTapeRewind. 223

Limits 223

Table Size 223

Read Only. 224

List 224

List Date 224

List PCL. 224

List Time 226

List FormFeed.