Suprtool 6.4 for HP-UX:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 

 

Program and manual copyright © 1981-2022 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 6.4 for HP-UX: 1

User Manual 1

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

Permission is granted to reprint this document (but not for profit), provided that copyright notice is given. 1

Phone:              604.501.2001  1

Table of Contents  1

Welcome to Suprtool 1

Introduction. 1

Suprtool Components. 1

STExport - Data Export Utility. 1

Rport - Data Reporting Utility. 1

Suprlink - Multidataset Access. 1

Documentation. 1

Notation. 1

Highlights in Suprtool 1

Highlights in Suprtool 6.4. 1

Highlights in Suprtool 6.3. 1

Highlights in Suprtool 6.2. 1

Highlights in Suprtool 6.1. 1

Highlights in Suprtool 6.0. 1

Highlights in Suprtool 5.9. 1

Installing Suprtool 1

Overview.. 1

Who Needs To Use These Instructions. 1

Instructions for HP-UX.. 1

Suprtool Roadmap for HP-UX   1

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

Suprtool for HP-UX.. 1

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

Suprtool on Linux. 1

Quick Start Guide for Suprtool 1

How to Run Suprtool 1

What is a Task?. 1

Copying Files. 1

Copying One File. 1

Appending to a File. 1

Fields in Data Files. 1

What is a Self-Describing File?. 1

Creating an SD File. 1

Define Fields in a Data File. 1

Create an SD File from a Data File. 1

Repeating Commands. 1

Repeating a Command. 1

Selecting Database Records. 1

Select All Records. 1

Look at the First Few Records. 1

Selecting by Criteria. 1

Simple Criteria. 1

Complex Criteria. 1

String of Digits. 1

Selecting by Date. 1

Select by Today's Date. 1

Select by Particular Date. 1

Select by Year 1

Select Prior Month. 1

Selecting by Lists of Values. 1

Finding Data Based on a List 1

Finding Data Based on a File. 1

Finding Data Based on Another Table’s Criteria. 1

Finding Data in a Data File. 1

Sorting Database Records. 1

Sort Records. 1

Sort Records in Descending Order 1

Sort by Multiple Keys. 1

Duplicate Records. 1

Report without Duplicate Records. 1

Report Only the Duplicate Records. 1

Report Only the Unique Records. 1

Report Only the Duplicates and Their Originals. 1

Deleting Duplicate Data File Records. 1

Decimal Places. 1

Converting Numbers. 1

Counts and Subtotals. 1

Count and Subtotal on Sort Keys. 1

Sort by Count or Subtotal 1

Total by Field. 1

Running Totals. 1

Running SubTotals. 1

Listing Records. 1

Changing the Output Record Format 1

Producing a Condensed Table Listing. 1

Simple Reports. 1

Your First Report 1

Column Headings. 1

Printing Mailing Labels. 1

Running Suprtool under HP-UX   1

Running Suprtool 1

Configuring Different Shells. 1

Bourne and Korn Shells. 1

C Shell 1

Setting Up a PATH for Suprtool 1

Bourne and Korn Shells. 1

C Shell 1

Dynamic Loading. 1

Control Characters and stty. 1

Suprmgr Configuration Files. 1

On-Line vs. Batch Access. 1

Command Line Options. 1

Initial Command Line:  -ccmdstring. 1

Default Outcount File Name:  -oc. 1

Exit with Verify:  -v. 1

Combining -c and -v. 1

Loader Warnings. 1

HP-UX Notes. 1

Shell Commands. 1

Hardcoded File Names and ROBELLE Variable. 1

ROBELLE Variable. 1

/opt/robelle/suprmgr 1

/opt/robelle/help/suprtool 1

Outcount File. 1

Differences Between MPE and HP-UX.. 1

Record Length. 1

Line Feeds. 1

Duplicate Output Files. 1

Classic Reals. 1

Input from Stdlist 1

Missing Features. 1

Suprtool and AMXW    1

What is AMXW... 1

What is Suprtool for AMXW... 1

Running Suprtool 1

Symbolic Links and running Supramxw.. 1

Suprtool/AMXW... 1

Form Command. 1

Numrecs Command. 1

Output Command. 1

Temporary Files. 1

Appending Records. 1

Table operations. 1

Variable Substitution. 1

Set Commands. 1

Command Details for AMXW    1

AMXW... 1

Numrecs Command  [N] 1

Set Commands. 1

AMXW Externalsd. 1

AMXW PerfWrite. 1

Filecode. 1

Squeeze. 1

Suprtool Issues and Solutions  1

A Suprtool Task. 1

Input Choices. 1

Processing Selections. 1

Output Choices. 1

Large File Support 1

Suprtool and Allbase. 1

Data-Types. 1

Date and Time Types. 1

Restrictions. 1

Suprtool and Oracle. 1

Data-Types. 1

Number Data-Type. 1

Order By vs. Sort 1

Restrictions. 1

SDUnix Utility. 1

Installation. 1

SDUnix Parameters. 1

LF vs. NOLF. 1

Examples. 1

Link vs. Query. 1

Suprtool and Self-Describing Files. 1

Create an SD File from a Table. 1

Create an SD File from a Data File. 1

SD Files as Input 1

Listing SD Files. 1

Decimal Places and Date Formats. 1

Extended Field Names. 1

Restrictions of SD Files. 1

Suprtool and Sorting Files. 1

Suprtool and Personal Computers. 1

Downloading to the PC.. 1

Decimal Places. 1

Spreadsheets. 1

Suprtool and PowerHouse Applications. 1

Suprtool with Quiz/QTP. 1

Step 1: Create a Subfile with Quiz. 1

Step 2: Output Erase in Suprtool 1

Step 3: Report with Quiz. 1

Using QTP to Create Subfiles. 1

Creating Subfile with Script File. 1

Quiz: Generating Suprtool Commands. 1

Year 2000 Solutions with Suprtool 1

What If I Have Four-Digit Years?. 1

What does Set Date Cutoff do?. 1

Stddate and Set Date Cutoff. 1

What does Set Date ForceCentury do?. 1

What If I Have Two-Digit Years?. 1

What Is Wrong with Two-Digit Years?. 1

How Do $Today and $Date Work?. 1

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

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

aammdd Date Format 1

Invalid Dates. 1

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 1

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

Year 2000 Testing. 1

Performance Issues. 1

Eloquence Performance. 1

Sort Performance. 1

Oracle Performance. 1

Analyzing Performance Data. 1

Variable Substitution. 1

Suprtool Functions. 1

UC4/Scripting and Functions. 1

String/Byte Functions. 1

$TRIM (Works on byte type fields) 1

If Usage: 1

Extract Usage (target: Byte type fields) 1

Example: 1

Data Examples Before and After: 1

$LTRIM (Works on Byte type fields) 1

If Usage: 1

Extract Usage (target: Byte type fields) 1

Example: 1

Data Examples before and after: 1

$RTRIM (Works on Byte type fields) 1

If Usage: 1

Extract Usage (target: Byte type fields) 1

Example: 1

Data Examples: 1

Data Result 1

$UPPER (Works on Byte-type fields) 1

If Usage: 1

Extract Usage (target: Byte type fields) 1

Example: 1

Data Examples: 1

$LOWER (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Example: 1

Data Examples: 1

$PROPER (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Example: 1

Data Examples: 1

$SPLIT (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: 1

Data Examples: 1

$FINDCLEAN (Works on Byte-type fields) 1

If Usage: 1

$CLEAN (Works on Byte-type fields) 1

If Usage: (Not commonly used) 1

Extract Usage: 1

Example: 1

Data Examples: 1

$TRANSLATE (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

$JUSTIFYL (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

$JUSTIFYR (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

$LEADZEROB (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

$RESPACE (Works on Byte-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

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

If Usage: 1

Extract Usage: 1

$ETOA.. 1

Extract Usage: 1

$ATOE.. 1

Extract Usage: 1

String Addition. 1

Extract Usage: 1

Example: 1

Data Result: 1

Numeric Functions. 1

$TRUNCATE.. 1

If Usage: 1

Extract Usage: 1

$ABS. 1

IF Usage: 1

Extract Usage: 1

$TOTAL.. 1

IF Usage: 1

Extract Usage: 1

$SUBTOTAL.. 1

IF Usage: 1

Extract Usage: 1

Example of $TOTAL and $SUBTOTAL.. 1

$COUNTER.. 1

IF Usage: 1

Extract Usage: 1

$SUBCOUNT.. 1

IF Usage: 1

Extract Usage: 1

Examples for $counter and $subcount: 1

$SIGNED.. 1

IF Usage: 1

Extract Usage: 1

$LEADZEROZ (Works on Display-type fields) 1

If Usage: 1

Extract Usage: 1

Data Examples: (Using above code) 1

Arithmetic Operations. 1

+ - * / mod. 1

If Usage: 1

Extract Usage: 1

Conversion/Formatting. 1

$NUMBER.. 1

If Usage: 1

Extract Usage: 1

Data Examples: 1

$EDIT.. 1

If Usage: 1

Extract Usage: 1

Data Examples: 1

Other Functions. 1

$LOOKUP. 1

If Usage: 1

Extract Usage: 1

$READ.. 1

If Usage: 1

$INRECNUM... 1

If Usage: 1

Extract Usage: 1

Date Functions. 1

$TODAY.. 1

If Usage: 1

Extract Usage: 1

$DATE.. 1

If Usage: 1

Extract Usage: 1

$INVALID.. 1

If Usage: 1

Extract Usage: 1

$STDDATE.. 1

If Usage: 1

Extract Usage: 1

$DAYS. 1

If Usage: 1

Extract Usage: 1

$MONTH.. 1

If Usage: 1

Extract Usage: 1

Suprtool Commands  1

General Notes. 1

Abbreviating. 1

Uppercase or Lowercase. 1

Multiple Commands per Line. 1

Continuation. 1

Comments on Command Lines. 1

HP-UX Commands. 1

Calculator 1

Control-Y Interrupt