Suprtool 6.5 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 


 

Program and manual copyright © 1981-2023 Robelle Solutions Technology Inc.

 

Permission is granted to reprint this document (but not for profit) if 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.5 for HP-UX: 1

User Manual 1

Program and manual copyright © 1981-2023 Robelle Solutions Technology Inc. 2

Permission is granted to reprint this document (but not for profit) if 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.5. 23

Highlights in Suprtool 6.4. 23

Highlights in Suprtool 6.3. 24

Highlights in Suprtool 6.2. 24

Highlights in Suprtool 6.1. 25

Highlights in Suprtool 6.0. 25

Installing Suprtool 26

Overview.. 26

Who Needs To Use These Instructions. 26

Instructions for HP-UX.. 26

Suprtool Roadmap for HP-UX   27

Road Map to Suprtool on HP-UX and Linux. 27

Suprtool for HP-UX.. 27

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

Suprtool on Linux. 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

$CHANGE (Works on Byte-type fields) 93

If Usage: 93

Extract Usage: 93

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

If Usage: 94

Extract Usage: 94

$ETOA.. 94

Extract Usage: 94

$ATOE.. 94

Extract Usage: 94

String Addition. 94

Extract Usage: 95

Example: 95

Data Result: 95

Numeric Functions. 95

$TRUNCATE.. 95

If Usage: 95

Extract Usage: 95

$ABS. 95

IF Usage: 95

Extract Usage: 95

$TOTAL.. 96

IF Usage: 96

Extract Usage: 96

$SUBTOTAL.. 96

IF Usage: 96

Extract Usage: 97

Example of $TOTAL and $SUBTOTAL.. 97

$COUNTER.. 97

IF Usage: 97

Extract Usage: 98

$SUBCOUNT.. 98

IF Usage: 98

Extract Usage: 98

Examples for $counter and $subcount: 98

$SIGNED.. 99

IF Usage: 99

Extract Usage: 99

$LEADZEROZ (Works on Display-type fields) 99

If Usage: 99

Extract Usage: 99

Data Examples: (Using above code) 99

Arithmetic Operations. 99

+ - * / mod. 99

If Usage: 99

Extract Usage: 99

Conversion/Formatting. 100

$NUMBER.. 100

If Usage: 100

Extract Usage: 100

Data Examples: 100

$EDIT.. 100

If Usage: 101

Extract Usage: 101

Data Examples: 101

Other Functions. 101

$LOOKUP. 101

If Usage: 101

Extract Usage: 101

$READ.. 101

If Usage: 102

$INRECNUM... 102

If Usage: 102

Extract Usage: 102