Suprtool 5.2 for HP-UX:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2009 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 is a trademark of Oracle Corporation, Redwood City, California, USA. Other product and company names mentioned herein may be the trademarks of their respective owners.

Robelle Solutions Technology Inc.

#372 - 7360 137 Street

Surrey, B.C. CanadaV3W 1A3

Phone: 604.501.2001

Fax: 604.501.2003

E-mail: sales@robelle.com

E-mail: support@robelle.com

Web: www.robelle.com

Table of Contents

Suprtool 5.2 for HP-UX: 1

Program and manual copyright © 1981-2009 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 16

Introduction. 16

Suprtool Components. 16

STExport - Data Export Utility. 16

Suprlink - Multidataset Access. 17

Documentation. 17

Suprtool Version 5.2 19

Highlights in HP-UX version 5.2. 19

Highlights in HP-UX version 5.1.02. 19

Highlights in AMXW version 5.2. 20

Highlights in AMXW version 5.1.02. 20

Installing Suprtool 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 Table’s 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

Setting Up a PATH for Suprtool 44

Bourne and Korn Shells. 44

Dynamic Loading. 45

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

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

Numrecs Command [N] 57

Set Commands. 58

AMXW Externalsd. 58

AMXW PerfWrite. 58

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

Date and Time Types. 62

Restrictions. 62

Suprtool and Oracle. 62

Number Data-Type. 63

Order By vs. Sort 63

Restrictions. 63

SDUnix Utility. 64

Installation. 64

SDUnix Parameters. 65

LF vs. NOLF. 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. 68

Spreadsheets. 69

Suprtool and PowerHouse Applications. 69

Suprtool with Quiz/QTP. 69

Step 1: Create a Subfile with Quiz. 69

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

Performance Issues. 80

Eloquence Performance. 81

Sort Performance. 81

Oracle Performance. 81

Analyzing Performance Data. 82

Variable Substitution. 82

Suprtool Commands 83

General Notes. 83

Abbreviating. 83

Uppercase or Lowercase. 83

Multiple Commands per Line. 83

Continuation. 84

Comments on Command Lines. 84

HP-UX Commands. 84

Control-Y Interrupt 85

Add Command [Add] 86

Base Command [BA] 87

Before Command [C] 89

Chain Command [C] 91

Clean Command [CL] 93

Removing Bad Characters. 93

Define Command [D] 95

Delete Command [DEL] 100

Do Command [DO] 102

Duplicate Command [DU] 103

Edit Command [ED] 108

Exit Command [E] 109

Export Command [EXP] 111

Extract Command [EXT] 112

Range of Fields. 116

Numeric Expressions. 117

$SubTotal Function. 119

$Total Function. 119

$Counter Function. 119

String Expressions. 120

Splitting Variable Length Strings. 121

Cleaning your Data. 122

Un-printables. 123

Clean Command Syntax. 123

Setting the Clean Character 123

Cleaning a Field. 123

Cleaning your data. 124

Extract from a Table. 124

Data Conversion. 125

$Number Function. 126

Numeric to Byte Conversion. 127

$Edit Function. 128

Placeholders and Format Characters. 128

Byte-Type Formatting. 128

Z-placeholder for byte-fields. 129

Overflow and limits. 129

Numeric field edit-masks. 130