Suprtool 5.6.01 for MPE:

User Manual

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

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

Support: 289.480.1060

E-mail: sales@robelle.com

E-mail: support@robelle.com

Web: www.robelle.com

Table of Contents

Table of Contents 3

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

Notation.............................................................................................................. 19

Highlights 21

Highlights in Suprtool 5.6.01................................................................................. 21

Highlights in Suprtool 5.5...................................................................................... 21

Highlights in Suprtool 5.4...................................................................................... 21

Highlights in Suprtool 5.3...................................................................................... 22

Highlights in Suprtool 5.2...................................................................................... 22

Highlights in Suprtool 5.1.02................................................................................. 22

Installing Suprtool 23

Overview............................................................................................................. 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.......................................................................... 41

Total by Field.......................................................................................... 41

Running Totals........................................................................................ 41

Running SubTotals................................................................................... 41

Listing Records.................................................................................................... 42

Changing the Output Record Format........................................................................ 42

Producing a Condensed Dataset Listing..................................................................... 43

Simple Reports..................................................................................................... 43

Your First Report...................................................................................... 43

Printing a Report...................................................................................... 44

Specifying Your Own Title......................................................................... 44

Column Headings..................................................................................... 44

Printing Mailing Labels............................................................................. 45

Running Suprtool under MPE 46

How to Run Suprtool............................................................................................ 46

How to Xeq a Suprtool Task................................................................................... 46

Info= for Commands.............................................................................................. 46

Son Process......................................................................................................... 47

Combining Info= and Son Process........................................................................... 47

Exit with Verify.................................................................................................... 48

Preventing Suprtool from Suspending....................................................................... 48

Stdin and Stdlist Files........................................................................................... 48

Input and Output Files........................................................................................... 49

Using CREATEPROCESS.................................................................................... 49

Duplicating Files.................................................................................................. 49

Job Control Word................................................................................................. 49

Suprmgr Configuration File.................................................................................... 50

Using Suprtool in Batch......................................................................................... 50

SuprtoolOutCount JCW......................................................................................... 50

SuprtoolFullCount Variable.................................................................................... 51

Summary of Parm= Values..................................................................................... 51

Suprtool Issues and Solutions 53

A Suprtool Task................................................................................................... 53

Input Choices........................................................................................... 53

Processing Selections................................................................................. 53

Output Choices......................................................................................... 53

Suprtool and Allbase............................................................................................. 54

Data-Types.............................................................................................. 54

Date and Time Types................................................................................ 55

Restrictions.............................................................................................. 55

Suprtool and IMAGE............................................................................................. 55

Reading Datasets....................................................................................... 55

Serial vs. Keyed Access.............................................................................. 56

When to Use Suprtool with IMAGE............................................................. 56

TurboIMAGE Compatibility....................................................................... 57

Locking of IMAGE Datasets........................................................................ 57

Database Maintenance (Delete, Put).............................................................. 58

B-trees.................................................................................................... 59

Master Dataset Expansion (MDX)................................................................ 59

Jumbo Datasets and Large Datasets............................................................... 59

Suprtool and KSAM Files...................................................................................... 60

Locking Output KSAM Files...................................................................... 60

Locking Input KSAM Files........................................................................ 60

Compatibility Mode KSAM/V Files............................................................ 61

Reorganizing KSAM/V Files...................................................................... 61

KSAM/XL Files....................................................................................... 62

Loading KSAM/XL Files........................................................................... 62

How Do I Convert CM Ksam to NM KSAM?............................................... 62

Reuse option and KSAM/XL Files............................................................... 63

Suprtool and MPE Files......................................................................................... 63

Buffered and NOBUF File Access................................................................. 63

Message Files........................................................................................... 64

Circular Files........................................................................................... 64

RIO Files................................................................................................ 64

Temporary Files....................................................................................... 65

Lockwords............................................................................................... 65

Copying User Labels................................................................................. 65

SDUnix Utility..................................................................................................... 66

SDUnix Parameters................................................................................... 66

LF vs. NOLF........................................................................................... 66

Examples................................................................................................. 66

Link vs. Query......................................................................................... 67

Suprtool and Self-Describing Files........................................................................... 67

Create an SD File from a Dataset.................................................................. 67

Create an SD File from a Data File............................................................... 67

SD Files as Input...................................................................................... 68

Listing SD Files....................................................................................... 68

Decimal Places and Date Formats................................................................. 68

Restrictions of SD Files............................................................................. 68

Creating KSAM SD Files........................................................................... 69

HowMessy Loadfile................................................................................... 70

Notes on SD Files..................................................................................... 70

Convert an SD File to a Disc File................................................................ 70

Suprtool and Sorting Files...................................................................................... 70

Fast Sorting............................................................................................. 71

Native Language Support............................................................................ 71

With Reduced Disc Space........................................................................... 71

Suprtool and Tape Files......................................................................................... 72

Labelled Tapes......................................................................................... 72

Multiple Files.......................................................................................... 73

Notes...................................................................................................... 73

File User Labels........................................................................................ 73

Suprtool and Remote File Access............................................................................. 74

Network Services (NS)............................................................................... 74

Suprtool and MPE/iX............................................................................................ 74

Calling Suprtool in Native Mode................................................................. 74

User XL Files........................................................................................... 74

When Errors Occur.................................................................................... 75

Sorting with Suprtool/iX............................................................................ 75

Suprtool and CI Variable Substitution...................................................................... 75

Example.................................................................................................. 75

Batch Requires Indent................................................................................ 76

Avoiding Double Resolution....................................................................... 76

Suprlink and STExport.............................................................................. 77

Suprtool and User Prompting.................................................................................. 77

Example.................................................................................................. 78

Resolving Variables................................................................................... 78

Suprtool and Personal Computers............................................................................ 78

Downloading to the PC.............................................................................. 79

Decimal Places......................................................................................... 79

Spreadsheets............................................................................................. 79

Suprtool and PowerHouse Applications..................................................................... 79

Suprtool with Quiz/QTP............................................................................ 79

Step 1: Create a Subfile with Quiz............................................................... 80

Step 2: Output Erase in Suprtool................................................................ 80

Step 3: Report with Quiz........................................................................... 80

Using QTP to Create Subfiles..................................................................... 81

Creating Subfile with Command File............................................................ 81

Suprtool and PowerHouse Data-Types.......................................................... 83

Suprtool Definitions - QSCHEMA............................................................... 85

Notes on QSHOW Output.......................................................................... 86

The Quiz Report....................................................................................... 87

Quiz: Generating Suprtool Commands.......................................................... 88

Generating Suprtool Commands from Quick.................................................. 88

Suprtool and Application Systems........................................................................... 89

Third-Party Indexing................................................................................. 89

Z-type TPI-keys........................................................................................ 89

Omnidex without TPI................................................................................ 90

OmniQuest.............................................................................................. 91

Suprtool with TRANSACT........................................................................ 91

XSORT and RPG..................................................................................... 92

QUERY Program...................................................................................... 92

SRN Chronos Dates.................................................................................. 93

Year 2000 Solutions with Suprtool.......................................................................... 93

What If I Have Four-Digit Years?................................................................. 93

What does Set Date Cutoff do?.................................................................... 94

Stddate and Set Date Cutoff......................................................................... 94

What does Set Date ForceCentury do?.......................................................... 94

What If I Have Two-Digit Years?................................................................. 94

What Is Wrong with Two-Digit Years?........................................................ 95

How Do $Today and $Date Work?.............................................................. 95

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

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

aammdd Date Format................................................................................. 96

Invalid Dates............................................................................................ 97

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

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

Case 2: X6 yymmdd Data to X8 ccyymmdd................................................. 99

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

Year 2000 Testing................................................................................... 101

Performance Issues............................................................................................... 102

Native Mode and Compatibility Mode........................................................ 102

CPU-Bound?.......................................................................................... 102

Sort Speed............................................................................................. 103

Analyzing Performance Data...................................................................... 103

Suprtool Performance Hints....................................................................... 104

Obtaining Accurate Measurements.............................................................. 104

Performance Summary.............................................................................. 105

Suprtool Commands 107

General Notes..................................................................................................... 107

Abbreviating........................................................................................... 107

Uppercase or Lowercase............................................................................ 107

Multiple Commands per Line.................................................................... 107

Continuation.......................................................................................... 108

Comments on Command Lines.................................................................. 108

STREAMX............................................................................................ 108

MPE Commands..................................................................................... 109

MPE/iX Commands................................................................................ 109

Calculator.............................................................................................. 109

Control-Y Interrupt.................................................................................. 109

Error Recovery........................................................................................ 110

Add Command [AD]........................................................................................... 111

Base Command [BA].......................................................................................... 112

Before Command [B].......................................................................................... 115

Chain Command [C]........................................................................................... 117

Clean Command [CL]......................................................................................... 120

Removing Bad Characters......................................................................... 120

Define Command [D].......................................................................................... 121

Delete Command [DEL]...................................................................................... 126

Do Command [DO]............................................................................................ 128

Duplicate Command [DU].................................................................................... 129

Edit Command [ED]........................................................................................... 134

Exit Command [E]............................................................................................. 135

Export Command [EXP]...................................................................................... 137

Extract Command [EXT]..................................................................................... 138

Constants............................................................................................... 138

Dates..................................................................................................... 140

Range of Fields....................................................................................... 142

Numeric Expressions................................................................................ 144

$SubTotal Function................................................................................. 146

$Total Function...................................................................................... 146

$Counter Function................................................................................... 146

String Expressions................................................................................... 147

Splitting Variable Length Strings............................................................... 148

Cleaning your Data.................................................................................. 150

Clean Command Syntax........................................................................... 150

Setting the Clean Character....................................................................... 150

Cleaning a Field...................................................................................... 150

Cleaning your data................................................................................... 151

Extract from a Table................................................................................. 151

Data Conversion...................................................................................... 152

$Number Function................................................................................... 154

Numeric to Byte Conversion..................................................................... 155

$Edit Function........................................................................................ 155

Placeholders and Format Characters............................................................ 155

Byte-Type Formatting.............................................................................. 155

Z-placeholder for byte-fields....................................................................... 156

Overflow and limits................................................................................. 156

Numeric field edit-masks........................................................................... 157

Signs.................................................................................................... 157

Decimal Places........................................................................................ 158

Data and Edit mask:................................................................................. 158

Currency and Dollar signs......................................................................... 158

Overflow and floating dollar....................................................................... 159

Set CurrencySymbol................................................................................ 159

Overflow and limits................................................................................. 159

Form Command [F]............................................................................................ 162

Get Command [G].............................................................................................. 167

Help Command [H]............................................................................................ 170

If Command [IF]................................................................................................ 171

Expressions............................................................................................ 171

Constants............................................................................................... 174

Subscripts.............................................................................................. 175

Numeric Expressions................................................................................ 176

String Expressions................................................................................... 178

Date Selection......................................................................................... 182

Long Expressions.................................................................................... 188

Input Command [I]............................................................................................. 191

Item Command [IT]............................................................................................ 194

Date Formats.......................................................................................... 194

Decimal Places........................................................................................ 197

Notes.................................................................................................... 198

Key Command [K]............................................................................................. 200

Link Command [LIN]......................................................................................... 202

List Command [L].............................................................................................. 203

Format.................................................................................................. 203

LaserJet Listings..................................................................................... 204

Headings in Listings................................................................................ 205

Simple Reports....................................................................................... 206

List Device............................................................................................. 207

Listredo Command [LISTREDO].......................................................................... 209

Numrecs Command [N]....................................................................................... 210

Open Command [OP].......................................................................................... 212

Output Command [O]......................................................................................... 213

Put Command [P].............................................................................................. 220

Q Command [Q]................................................................................................ 222

Redo Command [REDO]..................................................................................... 223

Reset Command [R]........................................................................................... 226

Select Command [SEL]........................................................................................ 227

Set Command [S]............................................................................................... 228

Allbase.................................................................................................. 230

Arithmetic.............................................................................................. 230

Baseclose............................................................................................... 230

Blocksize............................................................................................... 230

Buffer.................................................................................................... 230

CleanChar.............................................................................................. 231

CurrencySymbol..................................................................................... 231

Date Cutoff............................................................................................. 231

Date ForceCentury................................................................................... 233

Date IfYY2000Error................................................................................. 233

Date MapToPHDate8............................................................................... 233

DecimalSymbol...................................................................................... 234

Defer..................................................................................................... 234

DumpOnError......................................................................................... 234

EditStopError......................................................................................... 234

Eofread.................................................................................................. 235

FastRead................................................................................................ 235

Filecode................................................................................................. 235

Filename................................................................................................ 236

Firstrec.................................................................................................. 236

Hints..................................................................................................... 236

Ifcheck................................................................................................... 236

Ignore.................................................................................................... 237

InitExtents............................................................................................. 237

ItemAbbreviateDate.................................................................................. 237

ItemLock............................................................................................... 237

Interactive.............................................................................................. 238

LabelledTapeRewind................................................................................ 238

Limits................................................................................................... 238

List....................................................................................................... 239

List Date................................................................................................ 239

List PCL............................................................................................... 240

List Time.............................................................................................. 241

Lock..................................................................................................... 241

MakeAbsent........................................................................................... 242

NLS...................................................................................................... 242

NumBug................................................................................................ 243

Openmode.............................................................................................. 243

Oracle Rows........................................................................................... 243

Oracle OpenFix....................................................................................... 243

Oracle Integer.......................................................................................... 243

Oracle PassShift...................................................................................... 243

Oracle ZeroNull....................................................................................... 244

Pattern................................................................................................... 244

Prefetch.................................................................................................. 244

Privmode............................................................................................... 245

Progress................................................................................................. 245

Prompt.................................................................................................. 246

RealMap................................................................................................ 246

Recover................................................................................................. 246

Redo..................................................................................................... 246

Sortfast.................................................................................................. 247

Squeeze................................................................................................. 248

Statistics................................................................................................ 248

Subsystem............................................................................................. 248

Suspend................................................................................................. 249

ThousandSymbol.................................................................................... 249

Userlabels.............................................................................................. 249

Varsub................................................................................................... 250

VarsubCompat........................................................................................ 250

VarsubDebug.......................................................................................... 250

Warnings............................................................................................... 250

Xltrim................................................................................................... 251

Sort Command [SO]........................................................................................... 252

Table Command [TA].......................................................................................... 254

Adding Individual Values to a Table........................................................... 254

Adding Values from a File........................................................................ 255

Total Command [T]............................................................................................ 259

Update Command [UP]....................................................................................... 261

Use Command [U].............................................................................................. 262

Userpause Command [USER]............................................................................... 264

Verify Command [V]........................................................................................... 265

Xeq Command [X]............................................................................................. 266

Calculator Command [=]...................................................................................... 267

Suprtool Errors and Warnings 270

Two Types Of Messages....................................................................................... 270

Errors................................................................................................................ 270

Warnings........................................................................................................... 271

Welcome to STExport 273

Welcome to STExport......................................................................................... 273

Installing STExport............................................................................................. 273

Built-In File Names............................................................................................. 273

Accessing STExport 275

How To Run STExport........................................................................................ 275

How to Xeq an STExport Task.............................................................................. 275

Son Process........................................................................................................ 275

Suprtool Export Command................................................................................... 276

Preventing MPE Commands................................................................................. 276

Exit with Verify.................................................................................................. 276

Preventing STExport from Suspending.................................................................... 276

Job Control Word............................................................................................... 277

Using STExport in Batch..................................................................................... 277

Summary of Parm= Values.................................................................................... 277

STExportOutCount JCW..................................................................................... 277

STExportFullCount Variable................................................................................. 278

Introduction to STExport 279

Importing Data.................................................................................................... 279

Input File........................................................................................................... 279

Data-Types......................................................................................................... 279

Formatting Commands......................................................................................... 280

Commands......................................................................................................... 280

Performance Considerations................................................................................... 280

CI Variable Substitution....................................................................................... 281

STExport Commands 283

General Notes..................................................................................................... 283

Abbreviating........................................................................................... 283

Uppercase or Lowercase............................................................................ 283

Comments on Command Lines.................................................................. 283

STREAMX............................................................................................ 284

MPE Commands..................................................................................... 284

MPE/iX Commands................................................................................ 284

File Names............................................................................................. 284

Calculator.............................................................................................. 285

Control-Y.............................................................................................. 285

Before Command [B].......................................................................................... 286

Clean Command [CL]......................................................................................... 288

Removing Bad Characters......................................................................... 288

Columns Command [C]...................................................................................... 289

Date Command [DA].......................................................................................... 290

Decimal Command [DEC]................................................................................... 292

Delimiter Command [DE].................................................................................... 293

Do Command [DO]............................................................................................ 294

Escape Command [ES]........................................................................................ 295

Exit Command [E]............................................................................................. 296

Exit Abort [EA]...................................................................................... 296

Exit Suspend [ES]................................................................................... 296

Exit Xeq [EX]......................................................................................... 297

Floating Command [FL]...................................................................................... 298

Form Command [F]............................................................................................ 299

Heading Command [HEA]................................................................................... 301

Help Command [H]............................................................................................ 303

HTML Command [HT]....................................................................................... 304

Input Command [I]............................................................................................. 306

Listredo Command [LISTREDO].......................................................................... 307

Output Command [O]......................................................................................... 308

Quote Command [Q]........................................................................................... 309

Redo Command [REDO]..................................................................................... 310

Reset Command [R]........................................................................................... 311

Set Command [S]............................................................................................... 312

CleanChar.............................................................................................. 312

Mapped................................................................................................. 312

Redo..................................................................................................... 312

Statistics................................................................................................ 313

Varsub................................................................................................... 314

VarsubDebug.......................................................................................... 314

Warnings............................................................................................... 314

Xmltagchar............................................................................................. 314

ZonedFix............................................................................................... 315

Sign Command [SI]............................................................................................ 316

Spaces Command [SP]........................................................................................ 317

Use Command [U].............................................................................................. 318

Verify Command [V]........................................................................................... 319

Xeq Command [X]............................................................................................. 320

XML Command [XML]...................................................................................... 321

Zero Command [Z]............................................................................................. 324

Example of STExport Output 325

Example............................................................................................................ 325

Limits Within STExport 329

Maximums......................................................................................................... 329

Welcome to Dbedit 330

Introduction........................................................................................................ 330

Restrictions........................................................................................................ 330

Functions of Dbedit............................................................................................. 330

Performance of Dbedit........................................................................................... 331

Field Lists......................................................................................................... 331

Database Locking................................................................................................ 332

Decimal Points................................................................................................... 332

Critical-Item Update............................................................................................. 332

Dbedit Commands 335

General Notes..................................................................................................... 335

Abbreviating........................................................................................... 335

Uppercase or Lowercase............................................................................ 335

Continuation.......................................................................................... 335

Control-Y.............................................................................................. 336

Comments on Command Lines.................................................................. 336

MPE Commands..................................................................................... 336

MPE/iX Commands................................................................................ 336

Calculator.............................................................................................. 336

Example Database.................................................................................... 337

Prompting for Search Criteria..................................................................... 337

Command Parameters........................................................................................... 337

File Parameter......................................................................................... 337

Option Parameter..................................................................................... 338

Numeric-Value Option.............................................................................. 338

All Option............................................................................................. 338

Key Option............................................................................................ 338

Limit Option.......................................................................................... 339

Related Option........................................................................................ 339

Under Option.......................................................................................... 339

Updatekey Option.................................................................................... 340

Subcommands.................................................................................................... 340

Add Command [A]............................................................................................. 342

Before Command [B].......................................................................................... 343

Change Command [C]......................................................................................... 344

Delete Command [D].......................................................................................... 345

Do Command [DO]............................................................................................ 346

Exit Command [E]............................................................................................. 347

File Command [F].............................................................................................. 348

Form Command [FO]......................................................................................... 349

Help Command [H]............................................................................................ 350

List Command [L].............................................................................................. 351

Listredo Command [LISTREDO].......................................................................... 352

Modify Command [M]........................................................................................ 353

Q Command [Q]................................................................................................ 354

Redo Command [REDO]..................................................................................... 355

Set Command [S]............................................................................................... 356

LP........................................................................................................ 356

Prompt.................................................................................................. 356

Quiet..................................................................................................... 356

Reset..................................................................................................... 356

Underline............................................................................................... 357

Verify.................................................................................................... 357

Use Command [U].............................................................................................. 358

Verify Command [V]........................................................................................... 359

Welcome to Suprlink 360

Welcome to Suprlink........................................................................................... 360

Installing Suprlink............................................................................................... 360

Built-In File Names............................................................................................. 360

Accessing Suprlink 362

How To Run Suprlink......................................................................................... 362

How to Xeq a Suprlink Task................................................................................. 362

Son Process........................................................................................................ 362

Suprtool Link Command...................................................................................... 363

Preventing MPE Commands................................................................................. 363

Exit with Verify.................................................................................................. 363

Preventing Suprlink from Suspending..................................................................... 364

Job Control Word............................................................................................... 364

Using Suprlink in Batch....................................................................................... 364

Summary of Parm= Values.................................................................................... 364

SuprlinkOutCount JCW....................................................................................... 364

SuprlinkFullCount Variable.................................................................................. 365

Introduction to Suprlink 367

How Report Programs Work................................................................................. 367

Input Files......................................................................................................... 367

Link Files.......................................................................................................... 368

Output Files....................................................................................................... 368

Sort Keys........................................................................................................... 368

Selection Logic................................................................................................... 368

A Link Example.................................................................................................. 369

A Join Example.................................................................................................. 369

Performance Considerations................................................................................... 371

Another Example................................................................................................. 371

Illegal Digits...................................................................................................... 372

Selecting Non-Matches......................................................................................... 372

Linking MPE and KSAM Files............................................................................. 373

CI Variable Substitution....................................................................................... 374

Suprlink with Quiz/QTP...................................................................................... 375

Suprlink Commands 378

General Notes..................................................................................................... 378

Abbreviating........................................................................................... 378

Uppercase or Lowercase............................................................................ 378

Continuation.......................................................................................... 378

Comments on Command Lines.................................................................. 379

STREAMX............................................................................................ 379

MPE Commands..................................................................................... 379

MPE/iX Commands................................................................................ 380

File Names............................................................................................. 380

Calculator.............................................................................................. 380

Control-Y.............................................................................................. 380

Before Command [B].......................................................................................... 381

Do Command [DO]............................................................................................ 383

Exit Command [E]............................................................................................. 384

Exit Abort [EA]...................................................................................... 384

Exit Suspend [ES]................................................................................... 384

Exit Xeq [EX]......................................................................................... 384

Form Command [F]............................................................................................ 386

Help Command [H]............................................................................................ 388

Input Command [I]............................................................................................. 389

Join Command [J].............................................................................................. 390

Link Command [L]............................................................................................. 392

Listredo Command [LISTREDO].......................................................................... 394

Output Command [O]......................................................................................... 395

Redo Command [REDO]..................................................................................... 396

Reset Command [R]........................................................................................... 397

Set Command [S]............................................................................................... 398

Mapped................................................................................................. 398

Redo..................................................................................................... 398

Statistics................................................................................................ 399

Varsub................................................................................................... 399

VarsubDebug.......................................................................................... 399

Use Command [U].............................................................................................. 401

Verify Command [V]........................................................................................... 402

Xeq Command [X]............................................................................................. 403

Example Suprlink Output 404

Example............................................................................................................ 404

Limits Within Suprlink 407

Maximums......................................................................................................... 407

Welcome to Speed Demon 409

Welcome to Speed Demon.................................................................................... 409

MPE V.............................................................................................................. 409

MPE/iX............................................................................................................. 409

Conditions of Use................................................................................................ 409

Speed Demon vs. Suprtool.................................................................................... 410

Fourth-Generation Languages (4GLs)...................................................................... 410

Caveats for Privileged Mode Users.......................................................................... 410

SPDEPREFETCH JCW......................................................................................