Suprtool 5.3 for HP-UX:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2010 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.

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

Program and manual copyright © 1981-2010 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.3 19

Highlights in HP-UX version 5.3. 19

Highlights in AMXW version 5.3. 20

Installing Suprtool 21

Who Needs To Use These Instructions. 21

Instructions for HP-UX.. 21

Instructions for AMXW... 21

Suprtool Roadmap for HP-UX 22

Road Map to Suprtool on HP-UX.. 22

Suprtool for HP-UX.. 22

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

Suprtool for AMXW... 22

Quick Start Guide for Suprtool 23

How to Run Suprtool 23

What is a Task?. 23

Copying Files. 24

Copying One File. 24

Appending to a File. 24

Fields in Data Files. 24

What is a Self-Describing File?. 24

Creating an SD File. 24

Define Fields in a Data File. 24

Create an SD File from a Data File. 25

Repeating Commands. 25

Repeating a Command. 25

Selecting Database Records. 26

Select All Records. 26

Look at the First Few Records. 26

Selecting by Criteria. 27

Simple Criteria. 27

Complex Criteria. 27

String of Digits. 27

Selecting by Date. 27

Select by Today's Date. 28

Select by Particular Date. 28

Select by Year. 28

Select Prior Month. 28

Selecting by Lists of Values. 29

Finding Data Based on a List 29

Finding Data Based on a File. 29

Finding Data Based on Another Table’s Criteria. 30

Finding Data in a Data File. 30

Sorting Database Records. 30

Sort Records. 30

Sort Records in Descending Order. 31

Sort by Multiple Keys. 31

Duplicate Records. 31

Report without Duplicate Records. 31

Report Only the Duplicate Records. 32

Report Only the Unique Records. 32

Report Only the Duplicates and Their Originals. 33

Deleting Duplicate Data File Records. 33

Decimal Places. 34

Converting Numbers. 34

Counts and Subtotals. 35

Count and Subtotal on Sort Keys. 35

Sort by Count or Subtotal 35

Total by Field. 36

Running Totals. 36

Running SubTotals. 36

Listing Records. 37

Changing the Output Record Format 37

Producing a Condensed Table Listing. 38

Simple Reports. 38

Your First Report 38

Column Headings. 39

Printing Mailing Labels. 39

Running Suprtool under HP-UX 41

Running Suprtool 41

Configuring Different Shells. 41

Bourne and Korn Shells. 41

Setting Up a PATH for Suprtool 42

Bourne and Korn Shells. 42

Dynamic Loading. 43

Control Characters and stty. 44

Suprmgr Configuration Files. 44

On-Line vs. Batch Access. 45

Command Line Options. 45

Initial Command Line: -ccmdstring. 45

Default Outcount File Name: -oc. 45

Exit with Verify: -v. 46

Combining -c and -v. 46

Loader Warnings. 46

HP-UX Notes. 46

Shell Commands. 46

Hardcoded File Names and ROBELLE Variable. 47

ROBELLE Variable. 47

opt/robelle/suprmgr. 47

opt/robelle/help/suprtool 47

Outcount File. 47

Differences Between MPE and HP-UX.. 48

Record Length. 48

Duplicate Output Files. 48

Classic Reals. 48

Input from Stdlist 49

Missing Features. 49

Suprtool and AMXW 51

What is AMXW... 51

What is Suprtool for AMXW... 51

Running Suprtool 51

Symbolic Links and running Supramxw.. 51

Suprtool/AMXW... 52

Form Command. 52

Numrecs Command. 52

Output Command. 52

Temporary Files. 53

Appending Records. 53

Table operations. 53

Variable Substitution. 53

Set Commands. 53

Command Details for AMXW 54

Numrecs Command [N]. 55

Set Commands. 56

AMXW Externalsd. 56

AMXW PerfWrite. 56

Suprtool Issues and Solutions 58

A Suprtool Task. 58

Input Choices. 58

Processing Selections. 58

Output Choices. 58

Large File Support 59

Suprtool and Allbase. 59

Date and Time Types. 60

Restrictions. 60

Suprtool and Oracle. 60

Number Data-Type. 61

Order By vs. Sort 61

Restrictions. 61

SDUnix Utility. 62

Installation. 62

SDUnix Parameters. 63

LF vs. NOLF. 63

Link vs. Query. 64

Suprtool and Self-Describing Files. 64

Create an SD File from a Table. 64

Create an SD File from a Data File. 64

SD Files as Input 65

Listing SD Files. 65

Decimal Places and Date Formats. 65

Extended Field Names. 65

Restrictions of SD Files. 66

Suprtool and Sorting Files. 66

Suprtool and Personal Computers. 66

Downloading to the PC.. 66

Decimal Places. 67

Spreadsheets. 67

Suprtool and PowerHouse Applications. 67

Suprtool with Quiz/QTP. 67

Step 1: Create a Subfile with Quiz. 68

Step 2: Output Erase in Suprtool 68

Step 3: Report with Quiz. 68

Using QTP to Create Subfiles. 68

Creating Subfile with Script File. 68

Quiz: Generating Suprtool Commands. 69

Year 2000 Solutions with Suprtool 69

What If I Have Four-Digit Years?. 70

What does Set Date Cutoff do?. 70

Stddate and Set Date Cutoff. 70

What does Set Date ForceCentury do?. 71

What If I Have Two-Digit Years?. 71

What Is Wrong with Two-Digit Years?. 71

How Do $Today and $Date Work?. 72

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

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

aammdd Date Format 73

Invalid Dates. 73

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

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

Case 2: X6 yymmdd Data to X8 ccyymmdd. 75

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

Year 2000 Testing. 77

Performance Issues. 78

Eloquence Performance. 78

Sort Performance. 78

Oracle Performance. 78

Analyzing Performance Data. 79

Variable Substitution. 79

Suprtool Commands 80

General Notes. 80

Abbreviating. 80

Uppercase or Lowercase. 80

Multiple Commands per Line. 81

Continuation. 81

Comments on Command Lines. 82

HP-UX Commands. 82

Control-Y Interrupt 82

Add Command [Add]. 83

Base Command [BA]. 85

Before Command [B]. 87

Chain Command [C]. 89

Clean Command [CL]. 91

Removing Bad Characters. 91

Define Command [D]. 93

Delete Command [DEL]. 98

Do Command [DO]. 100

Duplicate Command [DU]. 101

Edit Command [ED]. 106

Exit Command [E]. 107

Export Command [EXP]. 109

Extract Command [EXT]. 110

Range of Fields. 114

Numeric Expressions. 115

$SubTotal Function. 117

$Total Function. 117

$Counter Function. 117

String Expressions. 118

Splitting Variable Length Strings. 119

Cleaning your Data. 120

Un-printables. 121

Clean Command Syntax. 121

Setting the Clean Character. 121

Cleaning a Field. 121

Cleaning your data. 122

Extract from a Table. 122

Data Conversion. 123

$Number Function. 124

Numeric to Byte Conversion. 125

$Edit Function. 126

Placeholders and Format Characters. 126

Byte-Type Formatting. 126

Z-placeholder for byte-fields. 127

Overflow and limits. 127

Numeric field edit-masks. 128