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 – 72nd 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 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......................................................................................