Suprtool 5.9.10 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 


 

Program and manual copyright 1981-2017 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.10 for HP-UX: 1

User Manual 1

Program and manual copyright 1981-2017 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.10  21

Highlights in Suprtool 5.9.10. 21

Highlights in Suprtool 5.9. 21

Highlights in Suprtool 5.8. 21

Highlights in Suprtool 5.7. 22

Highlights in Suprtool 5.6. 22

Installing Suprtool 23

Overview. 23

Who Needs To Use These Instructions 23

Instructions for HP-UX. 23

Instructions for AMXW.. 23

Suprtool Roadmap for HP-UX   24

Road Map to Suprtool on HP-UX. 24

Suprtool for HP-UX. 24

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

Suprtool for AMXW.. 24

Quick Start Guide for Suprtool 25

How to Run Suprtool 25

What is a Task? 25

Copying Files 26

Copying One File 26

Appending to a File 26

Fields in Data Files 26

What is a Self-Describing File? 26

Creating an SD File 26

Define Fields in a Data File 26

Create an SD File from a Data File 27

Repeating Commands 27

Repeating a Command. 27

Selecting Database Records 28

Select All Records 28

Look at the First Few Records 28

Selecting by Criteria 29

Simple Criteria 29

Complex Criteria 29

String of Digits 29

Selecting by Date 29

Select by Today's Date 30

Select by Particular Date 30

Select by Year 30

Select Prior Month. 30

Selecting by Lists of Values 31

Finding Data Based on a List 31

Finding Data Based on a File 31

Finding Data Based on Another Tables Criteria 32

Finding Data in a Data File 32

Sorting Database Records 32

Sort Records 32

Sort Records in Descending Order 33

Sort by Multiple Keys 33

Duplicate Records 33

Report without Duplicate Records 33

Report Only the Duplicate Records 34

Report Only the Unique Records 34

Report Only the Duplicates and Their Originals 35

Deleting Duplicate Data File Records 35

Decimal Places 36

Converting Numbers 36

Counts and Subtotals 37

Count and Subtotal on Sort Keys 37

Sort by Count or Subtotal 37

Total by Field. 38

Running Totals 38

Running SubTotals 38

Listing Records 39

Changing the Output Record Format 39

Producing a Condensed Table Listing. 40

Simple Reports 40

Your First Report 40

Column Headings 41

Printing Mailing Labels 41

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

$ETOA. 89

Extract Usage: 89

$ATOE. 89

Extract Usage: 89

String Addition. 89

Extract Usage: 90

Example: 90

Data Result: 90

Numeric Functions 90

$TRUNCATE. 90

If Usage: 90

Extract Usage: 90

$ABS. 90

IF Usage: 90

Extract Usage: 90

$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

Arithmetic Operations 94

+ - * / mod. 94

If Usage: 94

Extract Usage: 94

Conversion/Formatting. 94

$NUMBER. 94

If Usage: 95

Extract Usage: 95

Data Examples: 95

$EDIT. 95

If Usage: 95

Extract Usage: 95

Data Examples: 95

Other Functions 96

$LOOKUP. 96

If Usage: 96

Extract Usage: 96

$READ. 96

If Usage: 96

$INRECNUM.. 96

If Usage: 96

Extract Usage: 96

Date Functions 97

$TODAY. 97

If Usage: 97

Extract Usage: 97

$DATE. 97

If Usage: 97

Extract Usage: 97

$INVALID. 97

If Usage: 97

Extract Usage: 97

$STDDATE. 98

If Usage: 98

Extract Usage: 98

$DAYS. 98

If Usage: 98

Extract Usage: 98

$MONTH. 98

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 149

Signs 149

Decimal Places 150

Data and Edit mask: 150

Currency and Dollar signs 150

Overflow and floating dollar 151

Set CurrencySymbol 151

Overflow and limits 151

Restrictions 151

Form Command  [F] 154

Get Command  [G] 157

Help Command  [H] 159

If Command  [IF] 160

Expressions 160

Constants 163

Subscripts 164

Numeric Expressions 165

String Expressions 167

Date Selection. 170

Long Expressions 175

Input Command  [I] 178

Item Command  [IT] 180

Date Formats 180

Decimal Places 183

Notes 184

Key Command  [K] 186

Link Command  [LIN] 188

List Command  [L] 189

Format 189

LaserJet Listings 190

Headings in Listings 191

Simple Reports 192

List Device 193

List File 193

Listredo Command  [LISTREDO] 196

Numrecs Command  [N] 197

Open Command  [OP] 198

Remote Databases and Oracle Issues 198

Output Command  [O] 199

Put Command  [P] 205

Q Command  [Q] 206

Redo Command  [REDO] 207

Reset Command  [R] 210

Select Command  [SEL] 211

Set Command  [S] 212

Allbase 214

Arithmetic 214

Baseclose 214

Blocksize 214

Buffer 214

CleanChar 214

Comlog. 215

CurrencySymbol 215

Date Cutoff 216

Date ForceCentury. 217

Date IfYY2000Error 217

Date MapToPHDate8. 218

DecimalSymbol 218

Defer 218

DumpOnError 218

EditStopError 218

Eofread. 219

FastRead. 219

Filecode 219

Filename 219

Firstrec 220

Hints 220

HPUXCmdErr <string> 220

Ifcheck. 221

Ignore 221

InitExtents 221

ItemAbbreviateDate 221

ItemLock. 221

Interactive 222

LabelledTapeRewind. 222

Limits 222

Table Size 222

Read Only. 223

List 223

List Date 223

List PCL. 223