Suprtool 5.1.02 for MPE

Suprtool 5.1.02 for MPE:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

Program and manual copyright © 1981-2008 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, 13711 – 72^nd Avenue,

Surrey, B.C. Canada V3W 2P2

Phone: 604.501.2001

Fax: 604.501.2003

E-mail: solutions@robelle.com

E-mail: support@robelle.com

Web: www.robelle.com

Suprtool 5.1.02 for MPE: 1

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

Welcome to Suprtool 17

Introduction. 17

Suprtool Components. 17

Database Editing. 18

Speed Demon - Replacing DBGET Mode-2. 18

STExport - Data Export Utility. 18

Suprlink - Multidataset Access. 18

Suprtool2 - Interface Routine. 19

Documentation. 19

Highlights in Suprtool 5.1.02. 21

Highlights in Suprtool 5.0. 22

Installing Suprtool 23

Ecometry Users. 23

Instructions. 23

Getting a Quick Start with Suprtool 24

How to Run Suprtool 24

What is a Task?. 24

Copying Files. 25

Copying One File. 25

Appending to a File. 25

Concatenating Two Files. 25

Fields in Data Files. 25

What is a Self-Describing File?. 25

Creating an SD File. 26

Define Fields in a Data File. 26

Create an SD File from a Data File. 26

Repeating Commands. 27

Repeating a Command. 27

How to Save On-line Commands to a File. 27

Selecting Database Records. 27

Select All Records. 28

Select a Random Sample. 28

Look at the First Few Records. 28

Selecting by Criteria. 28

Simple Criteria. 28

Complex Criteria. 28

String of Digits. 29

Selecting by Date. 29

Select by Today's Date. 29

Select by Particular Date. 29

Select by Year 30

Select Prior Month. 30

Selecting by Lists of Values. 30

Finding Data Based on a List 30

Finding Data Based on a File. 31

Finding Data Based on Another Dataset's Criteria. 31

Finding Data in a Data File. 32

Comparing against a Key and Data. 32

Sorting Database Records. 33

Sort Records. 33

Sort Records in Descending Order 33

Sort by Multiple Keys. 33

Deleting Records. 33

Updating Records. 34

Duplicate Records. 34

Report without Duplicate Records. 34

Report Only the Duplicate Records. 35

Report Only the Unique Records. 35

Report Only the Duplicates and Their Originals. 36

Deleting Duplicate Database Records. 36

Deleting Non-Unique Duplicate Database Records. 37

Deleting Duplicate Data File Records. 38

Sorting IMAGE to KSAM... 39

Loading a Dataset 39

Decimal Places. 39

Converting Numbers. 40

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 Dataset Listing. 42

Simple Reports. 43

Your First Report 43

Printing a Report 43

Specifying Your Own Title. 44

Column Headings. 44

Printing Mailing Labels. 44

Running Suprtool under MPE 45

How to Run Suprtool 45

How to Xeq a Suprtool Task. 45

Info= for Commands. 45

Son Process. 46

Combining Info= and Son Process. 46

Exit with Verify. 47

Preventing Suprtool from Suspending. 47

Stdin and Stdlist Files. 47

Input and Output Files. 48

Using CREATEPROCESS. 48

Duplicating Files. 48

Job Control Word. 48

Suprmgr Configuration File. 49

Using Suprtool in Batch. 49

SuprtoolOutCount JCW... 49

SuprtoolFullCount Variable. 50

Summary of Parm= Values. 50

Suprtool Issues and Solutions 51

A Suprtool Task. 51

Input Choices. 51

Processing Selections. 51

Output Choices. 51

Suprtool and Allbase. 52

Date and Time Types. 53

Restrictions. 53

Suprtool and IMAGE.. 53

Reading Datasets. 53

Serial vs. Keyed Access. 54

When to Use Suprtool with IMAGE.. 54

TurboIMAGE Compatibility. 55

Locking of IMAGE Datasets. 55

Database Maintenance (Delete, Put) 56

Master Dataset Expansion (MDX) 57

Jumbo Datasets and Large Datasets. 57

Suprtool and KSAM Files. 58

Locking Output KSAM Files. 58

Locking Input KSAM Files. 58

Compatibility Mode KSAM/V Files. 59

Reorganizing KSAM/V Files. 59

KSAM/XL Files. 60

Loading KSAM/XL Files. 60

Reuse option and KSAM/XL Files. 60

Suprtool and MPE Files. 61

Buffered and NOBUF File Access. 61

Message Files. 61

Circular Files. 61

Temporary Files. 62

Copying User Labels. 63

SDUnix Utility. 63

SDUnix Parameters. 63

LF vs. NOLF. 63

Link vs. Query. 65

Suprtool and Self-Describing Files. 65

Create an SD File from a Dataset 65

Create an SD File from a Data File. 65

SD Files as Input 65

Listing SD Files. 66

Decimal Places and Date Formats. 66

Restrictions of SD Files. 66

Creating KSAM SD Files. 67

HowMessy Loadfile. 67

Notes on SD Files. 68

Convert an SD File to a Disc File. 68

Suprtool and Sorting Files. 68

Fast Sorting. 68

Native Language Support 69

With Reduced Disc Space. 69

Suprtool and Tape Files. 69

Labelled Tapes. 70

Multiple Files. 70

File User Labels. 71

Suprtool and Remote File Access. 71

Network Services (NS) 71

Suprtool and MPE/iX.. 72

Calling Suprtool in Native Mode. 72

User XL Files. 72

When Errors Occur 72

Sorting with Suprtool/iX.. 72

Suprtool and CI Variable Substitution. 73

Batch Requires Indent 73

Avoiding Double Resolution. 74

Suprlink and STExport 74

Suprtool and User Prompting. 75

Resolving Variables. 75

Suprtool and Personal Computers. 76

Downloading to the PC.. 76

Decimal Places. 76

Spreadsheets. 76

Suprtool and PowerHouse Applications. 77

Suprtool with Quiz/QTP. 77

Step 1: Create a Subfile with Quiz. 77

Step 2: Output Erase in Suprtool 78

Step 3: Report with Quiz. 78

Using QTP to Create Subfiles. 78

Creating Subfile with Command File. 79

Suprtool and PowerHouse Data-Types. 80

Suprtool Definitions - QSCHEMA.. 83

Notes on QSHOW Output 83

The Quiz Report 84

Quiz: Generating Suprtool Commands. 85

Generating Suprtool Commands from Quick. 86

Suprtool and Application Systems. 86

Third-Party Indexing. 86

Z-type TPI-keys. 87

Omnidex without TPI. 87

Suprtool with TRANSACT.. 88

XSORT and RPG.. 89

QUERY Program... 89

SRN Chronos Dates. 90

Year 2000 Solutions with Suprtool 90

What If I Have Four-Digit Years?.