User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

 


 

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

 

 

 

 

 

 

 

I

 

Robelle Solutions Technology Inc.

Suite 372, 13711 72nd Avenue,

Surrey, B.C. Canada V3W 2P2

 

Phone: 604.501.2001

Fax: 604.501.2003

 

E-mail: sales@robelle.com

E-mail: support@robelle.com

Web: www.robelle.com


Suprtool 5.2 for MPE: 1

User Manual 1

Program and manual copyright 1981-2009 Robelle Solutions Technology Inc. 2

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

Phone: 604.501.2001 2

Welcome to Suprtool 17

Introduction. 17

Suprtool Components. 17

Database Editing. 18

Speed Demon - Replacing DBGET Mode-2. 18

STExport - Data Export Utility. 18

Suprlink - Multidataset Access. 18

Suprtool2 - Interface Routine. 19

Documentation. 19

Notation. 19

Highlights 21

Highlights in Suprtool 5.2. 21

Highlights in Suprtool 5.1.02. 21

Highlights in Suprtool 5.0. 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 40

Total by Field. 41

Running Totals. 41

Running SubTotals. 41

Listing Records. 42

Changing the Output Record Format 42

Producing a Condensed Dataset Listing. 42

Simple Reports. 43

Your First Report 43

Printing a Report 43

Specifying Your Own Title. 44

Column Headings. 44

Printing Mailing Labels. 44

Running Suprtool under MPE 45

How to Run Suprtool 45

How to Xeq a Suprtool Task. 45

Info= for Commands. 45

Son Process. 46

Combining Info= and Son Process. 46

Exit with Verify. 47

Preventing Suprtool from Suspending. 47

Stdin and Stdlist Files. 47

Input and Output Files. 48

Using CREATEPROCESS. 48

Duplicating Files. 48

Job Control Word. 48

Suprmgr Configuration File. 49

Using Suprtool in Batch. 49

SuprtoolOutCount JCW... 49

SuprtoolFullCount Variable. 50

Summary of Parm= Values. 50

Suprtool Issues and Solutions 51

A Suprtool Task. 51

Input Choices. 51

Processing Selections. 51

Output Choices. 51

Suprtool and Allbase. 52

Data-Types. 52

Date and Time Types. 53

Restrictions. 53

Suprtool and IMAGE.. 53

Reading Datasets. 53

Serial vs. Keyed Access. 54

When to Use Suprtool with IMAGE.. 54

TurboIMAGE Compatibility. 55

Locking of IMAGE Datasets. 55

Database Maintenance (Delete, Put) 56

B-trees. 57

Master Dataset Expansion (MDX) 57

Jumbo Datasets and Large Datasets. 57

Suprtool and KSAM Files. 58

Locking Output KSAM Files. 58

Locking Input KSAM Files. 58

Compatibility Mode KSAM/V Files. 59

Reorganizing KSAM/V Files. 59

KSAM/XL Files. 60

Loading KSAM/XL Files. 60

Reuse option and KSAM/XL Files. 60

Suprtool and MPE Files. 61

Buffered and NOBUF File Access. 61

Message Files. 61

Circular Files. 61

RIO Files. 62

Temporary Files. 62

Lockwords. 62

Copying User Labels. 63

SDUnix Utility. 63

SDUnix Parameters. 63

LF vs. NOLF. 63

Examples. 64

Link vs. Query. 65

Suprtool and Self-Describing Files. 65

Create an SD File from a Dataset 65

Create an SD File from a Data File. 65

SD Files as Input 65

Listing SD Files. 66

Decimal Places and Date Formats. 66

Restrictions of SD Files. 66

Creating KSAM SD Files. 67

HowMessy Loadfile. 67

Notes on SD Files. 68

Convert an SD File to a Disc File. 68

Suprtool and Sorting Files. 68

Fast Sorting. 68

Native Language Support 69

With Reduced Disc Space. 69

Suprtool and Tape Files. 69

Labelled Tapes. 70

Multiple Files. 70

Notes. 71

File User Labels. 71

Suprtool and Remote File Access. 71

Network Services (NS) 71

Suprtool and MPE/iX.. 72

Calling Suprtool in Native Mode. 72

User XL Files. 72

When Errors Occur 72

Sorting with Suprtool/iX.. 72

Suprtool and CI Variable Substitution. 73

Example. 73

Batch Requires Indent 73

Avoiding Double Resolution. 74

Suprlink and STExport 74

Suprtool and User Prompting. 75

Example. 75

Resolving Variables. 75

Suprtool and Personal Computers. 76

Downloading to the PC.. 76

Decimal Places. 76

Spreadsheets. 76

Suprtool and PowerHouse Applications. 77

Suprtool with Quiz/QTP. 77

Step 1: Create a Subfile with Quiz. 77

Step 2: Output Erase in Suprtool 78

Step 3: Report with Quiz. 78

Using QTP to Create Subfiles. 78

Creating Subfile with Command File. 79

Suprtool and PowerHouse Data-Types. 80

Suprtool Definitions - QSCHEMA.. 83

Notes on QSHOW Output 83

The Quiz Report 84

Quiz: Generating Suprtool Commands. 85

Generating Suprtool Commands from Quick. 86

Suprtool and Application Systems. 86

Third-Party Indexing. 86

Z-type TPI-keys. 87

Omnidex without TPI. 87

OmniQuest 88

Suprtool with TRANSACT.. 88

XSORT and RPG.. 89

QUERY Program... 89

SRN Chronos Dates. 90

Year 2000 Solutions with Suprtool 90

What If I Have Four-Digit Years?. 90

What does Set Date Cutoff do?. 91

Stddate and Set Date Cutoff. 91

What does Set Date ForceCentury do?. 91

What If I Have Two-Digit Years?. 91

What Is Wrong with Two-Digit Years?. 92

How Do $Today and $Date Work?. 92

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

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

aammdd Date Format 93

Invalid Dates. 94

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

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

Case 2: X6 yymmdd Data to X8 ccyymmdd. 96

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

Year 2000 Testing. 99

Performance Issues. 99

Native Mode and Compatibility Mode. 100

CPU-Bound?. 100

Sort Speed. 100

Analyzing Performance Data. 101

Suprtool Performance Hints. 101

Obtaining Accurate Measurements. 102

Performance Summary. 103

Suprtool Commands 105

General Notes. 105

Abbreviating. 105

Uppercase or Lowercase. 105

Multiple Commands per Line. 105

Continuation. 106

Comments on Command Lines. 106

STREAMX.. 106

MPE Commands. 107

MPE/iX Commands. 107

Calculator 107

Control-Y Interrupt 107

Error Recovery. 108

Add Command [AD] 109

Base Command [BA] 110

Before Command [B] 113

Chain Command [C] 115

Clean Command [CL] 118

Removing Bad Characters. 118

Define Command [D] 119

Delete Command [DEL] 124

Do Command [DO] 126

Duplicate Command [DU] 127

Edit Command [ED] 132

Exit Command [E] 133

Export Command [EXP] 135

Extract Command [EXT] 136

Constants. 136

Dates. 138

Range of Fields. 140

Numeric Expressions. 141

$SubTotal Function. 143

$Total Function. 143

$Counter Function. 144

String Expressions. 144

Splitting Variable Length Strings. 146

Cleaning your Data. 147

Clean Command Syntax. 147

Setting the Clean Character 147

Cleaning a Field. 148

Cleaning your data. 148

Extract from a Table. 148

Data Conversion. 150

$Number Function. 151

Numeric to Byte Conversion. 152

$Edit Function. 152

Placeholders and Format Characters. 152

Byte-Type Formatting. 153

Z-placeholder for byte-fields. 154

Overflow and limits. 154

Numeric field edit-masks. 154

Signs. 155

Decimal Places. 155

Data and Edit mask: 156

Currency and Dollar signs. 156

Overflow and floating dollar 156

Set CurrencySymbol 157

Overflow and limits. 157

Form Command [F] 159

Get Command [G] 164

Help Command [H] 167

If Command [IF] 168

Expressions. 168

Constants. 171

Subscripts. 172

Numeric Expressions. 173

String Expressions. 175

Date Selection. 179

Long Expressions. 185

Input Command [I] 188

Item Command [IT] 191

Date Formats. 191

Decimal Places. 194

Notes. 195

Key Command [K] 197

Link Command [LIN] 199

List Command [L] 200

Format 200

LaserJet Listings. 201

Headings in Listings. 202

Simple Reports. 203

List Device. 204

Listredo Command [LISTREDO] 206

Numrecs Command [N] 207

Open Command [OP] 209

Output Command [O] 210

Put Command [P] 217

Q Command [Q] 219

Redo Command [REDO] 220

Reset Command [R] 223

Select Command [SEL] 224

Set Command [S] 225

Allbase. 227

Arithmetic. 227

Baseclose. 227

Blocksize. 227

Buffer 227

CleanChar 228

CurrencySymbol 228

Date Cutoff. 228

Date ForceCentury. 230

Date IfYY2000Error 230

Date MapToPHDate8. 230

DecimalSymbol 231

Defer 231

DumpOnError 231

EditStopError 231

Eofread. 232

FastRead. 232

Filecode. 232

Filename. 233

Firstrec. 233

Hints. 233

Ifcheck. 233

Ignore. 234

InitExtents. 234

ItemAbbreviateDate. 234

ItemLock. 234

Interactive. 235

LabelledTapeRewind. 235

Limits. 235

List 236

List Date. 236

List PCL.. 237

List Time. 238

Lock. 238

MakeAbsent 239

NLS. 239

NumBug. 240

Openmode. 240

Oracle Rows. 240

Oracle OpenFix. 240

Oracle Integer 240

Oracle PassShift 240

Oracle ZeroNull 241

Pattern. 241

Prefetch. 241

Privmode. 242

Progress. 242

Prompt 243

RealMap. 243

Recover 243

Redo. 243

Sortfast 244

Squeeze. 245

Statistics. 245

Subsystem... 245

Suspend. 246

ThousandSymbol 246

Userlabels. 246

Varsub. 247

VarsubCompat 247

VarsubDebug. 247

Warnings. 247

Sort Command [SO] 248

Table Command [TA] 250

Adding Individual Values to a Table. 250

Adding Values from a File. 251

Total Command [T] 255

Update Command [UP] 257

Use Command [U] 258

Userpause Command [USER] 260

Verify Command [V] 261

Xeq Command [X] 262

Calculator Command [=] 263

Suprtool Errors and Warnings 266

Two Types Of Messages. 266

Errors. 266

Warnings. 267

Welcome to STExport 269

Welcome to STExport 269

Installing STExport 269

Built-In File Names. 269

Accessing STExport 271

How To Run STExport 271

How to Xeq an STExport Task. 271

Son Process. 271

Suprtool Export Command. 272

Preventing MPE Commands. 272

Exit with Verify. 272

Preventing STExport from Suspending. 272

Job Control Word. 273

Using STExport in Batch. 273

Summary of Parm= Values. 273

STExportOutCount JCW... 273

STExportFullCount Variable. 274

Introduction to STExport 275

Importing Data. 275

Input File. 275

Data-Types. 275

Formatting Commands. 276

Commands. 276

Performance Considerations. 276

CI Variable Substitution. 277

STExport Commands 279

General Notes. 279

Abbreviating. 279

Uppercase or Lowercase. 279

Comments on Command Lines. 279

STREAMX.. 280

MPE Commands. 280

MPE/iX Commands. 280

File Names. 280

Calculator 281

Control-Y.. 281

Before Command [B] 282

Clean Command [CL] 284

Removing Bad Characters. 284

Columns Command [C] 285

Date Command [DA] 286

Decimal Command [DEC] 288

Delimiter Command [DE] 289

Do Command [DO] 290

Escape Command [ES] 291

Exit Command [E] 292

Exit Abort [EA] 292

Exit Suspend [ES] 292

Exit Xeq [EX] 293

Floating Command [FL] 294

Form Command [F] 295

Heading Command [HEA] 297

Help Command [H] 299

HTML Command [HT] 300

Input Command [I] 302

Listredo Command [LISTREDO] 303

Output Command [O] 304

Quote Command [Q] 305

Redo Command [REDO] 306

Reset Command [R] 307

Set Command [S] 308

CleanChar 308

Mapped. 308

Redo. 308

Statistics. 309

Varsub. 310

VarsubDebug. 310

Warnings. 310

Xmltagchar 310

ZonedFix. 311

Sign Command [SI] 312

Spaces Command [SP] 313

Use Command [U] 314

Verify Command [V] 315

Xeq Command [X] 316

XML Command [XML] 317

Zero Command [Z] 320

Example of STExport Output 321

Example. 321

Limits Within STExport 325

Maximums. 325

Welcome to Dbedit 326

Introduction. 326

Restrictions. 326

Functions of Dbedit 326

Performance of Dbedit 327

Field Lists. 327

Database Locking. 328

Decimal Points. 328

Critical-Item Update. 328

Dbedit Commands 331

General Notes. 331

Abbreviating. 331

Uppercase or Lowercase. 331

Continuation. 331

Control-Y.. 332

Comments on Command Lines. 332

MPE Commands. 332

MPE/iX Commands. 332

Calculator 332

Example Database. 333

Prompting for Search Criteria. 333

Command Parameters. 333

File Parameter 333

Option Parameter 334

Numeric-Value Option. 334

All Option. 334

Key Option. 334

Limit Option. 335

Related Option. 335

Under Option. 335

Updatekey Option. 336

Subcommands. 336

Add Command [A] 338

Before Command [B] 339

Change Command [C] 340

Delete Command [D] 341

Do Command [DO] 342

Exit Command [E] 343

File Command [F] 344

Form Command [FO] 345

Help Command [H] 346

List Command [L] 347

Listredo Command [LISTREDO] 348

Modify Command [M] 349

Q Command [Q] 350

Redo Command [REDO] 351

Set Command [S] 352

LP. 352

Prompt 352

Quiet 352

Reset 352