Suprtool 5.8 for MPE:

User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

by Robelle Solutions Technology Inc.

 

suprtool

 


 

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

 

Robelle Solutions Technology Inc.

Suite 372, 13711 – 72nd Avenue,

Surrey, B.C. Canada  V3W 2P2

 

Phone:   604.501.2001

Support: 289.480.1060

 

E-mail:  sales@robelle.com

E-mail:  support@robelle.com

Web:     www.robelle.com


Table of Contents

Table of Contents                                                                                                      3

Welcome to Suprtool                                                                                              19

Introduction......................................................................................................... 19

Suprtool Components............................................................................................ 19

Database Editing....................................................................................... 19

Speed Demon - Replacing DBGET Mode-2................................................... 20

STExport - Data Export Utility.................................................................... 20

Suprlink - Multidataset Access.................................................................... 20

Suprtool2 - Interface Routine....................................................................... 21

Documentation..................................................................................................... 21

Notation.............................................................................................................. 21

Highlights                                                                                                                  23

Highlights in Suprtool 5.7...................................................................................... 23

Highlights in Suprtool 5.6...................................................................................... 23

Highlights in Suprtool 5.5...................................................................................... 23

Highlights in Suprtool 5.4...................................................................................... 23

Highlights in Suprtool 5.3...................................................................................... 24

Highlights in Suprtool 5.2...................................................................................... 24

Highlights in Suprtool 5.1.02................................................................................. 24

Installing Suprtool                                                                                                   26

Overview............................................................................................................. 26

Ecometry Users..................................................................................................... 26

Instructions.......................................................................................................... 26

Getting a Quick Start with Suprtool                                                                    27

How to Run Suprtool............................................................................................ 27

What is a Task?.................................................................................................... 27

Copying Files...................................................................................................... 28

Copying One File..................................................................................... 28

Appending to a File................................................................................... 28

Concatenating Two Files............................................................................ 28

Fields in Data Files............................................................................................... 28

What is a Self-Describing File?.................................................................... 28

Creating an SD File................................................................................... 28

Define Fields in a Data File........................................................................ 29

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

Repeating Commands............................................................................................ 30

Repeating a Command............................................................................... 30

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

Selecting Database Records..................................................................................... 30

Select All Records..................................................................................... 31

Select a Random Sample............................................................................ 31

Look at the First Few Records..................................................................... 31

Selecting by Criteria.............................................................................................. 31

Simple Criteria......................................................................................... 31

Complex Criteria...................................................................................... 31

String of Digits........................................................................................ 32

Selecting by Date.................................................................................................. 32

Select by Today's Date............................................................................... 32

Select by Particular Date............................................................................. 32

Select by Year.......................................................................................... 33

Select Prior Month.................................................................................... 33

Selecting by Lists of Values.................................................................................... 33

Finding Data Based on a List...................................................................... 33

Finding Data Based on a File...................................................................... 34

Finding Data Based on Another Dataset's Criteria........................................... 34

Finding Data in a Data File......................................................................... 35

Comparing against a Key and Data............................................................... 35

Sorting Database Records....................................................................................... 36

Sort Records............................................................................................ 36

Sort Records in Descending Order................................................................ 36

Sort by Multiple Keys............................................................................... 36

Deleting Records................................................................................................... 36

Updating Records.................................................................................................. 37

Duplicate Records................................................................................................. 37

Report without Duplicate Records................................................................ 37

Report Only the Duplicate Records............................................................... 38

Report Only the Unique Records.................................................................. 38

Report Only the Duplicates and Their Originals.............................................. 39

Deleting Duplicate Database Records............................................................ 39

Deleting Non-Unique Duplicate Database Records........................................... 40

Deleting Duplicate Data File Records............................................................ 41

Sorting IMAGE to KSAM...................................................................................... 42

Loading a Dataset.................................................................................................. 42

Decimal Places..................................................................................................... 42

Converting Numbers.............................................................................................. 43

Counts and Subtotals............................................................................................. 43

Count and Subtotal on Sort Keys................................................................. 43

Sort by Count or Subtotal.......................................................................... 44

Total by Field.......................................................................................... 44

Running Totals......................................................................................... 44

Running SubTotals................................................................................... 44

Listing Records.................................................................................................... 45

Changing the Output Record Format........................................................................ 45

Producing a Condensed Dataset Listing..................................................................... 46

Simple Reports..................................................................................................... 46

Your First Report...................................................................................... 46

Printing a Report...................................................................................... 47

Specifying Your Own Title......................................................................... 47

Column Headings..................................................................................... 47

Printing Mailing Labels............................................................................. 48

Running Suprtool under MPE                                                                               49

How to Run Suprtool............................................................................................ 49

How to Xeq a Suprtool Task................................................................................... 49

Info= for Commands............................................................................................. 49

Son Process......................................................................................................... 50

Combining Info= and Son Process........................................................................... 50

Exit with Verify.................................................................................................... 51

Preventing Suprtool from Suspending....................................................................... 51

Stdin and Stdlist Files........................................................................................... 51

Input and Output Files........................................................................................... 52

Using CREATEPROCESS..................................................................................... 52

Duplicating Files.................................................................................................. 52

Job Control Word................................................................................................. 52

Suprmgr Configuration File.................................................................................... 53

Using Suprtool in Batch......................................................................................... 53

SuprtoolOutCount JCW......................................................................................... 53

SuprtoolFullCount Variable.................................................................................... 54

Summary of Parm= Values..................................................................................... 54

Suprtool Issues and Solutions                                                                             55

A Suprtool Task................................................................................................... 55

Input Choices........................................................................................... 55

Processing Selections................................................................................. 55

Output Choices......................................................................................... 55

Suprtool and Allbase............................................................................................. 56

Data-Types............................................................................................... 56

Date and Time Types................................................................................. 57

Restrictions.............................................................................................. 57

Suprtool and IMAGE............................................................................................. 57

Reading Datasets....................................................................................... 57

Serial vs. Keyed Access.............................................................................. 58

When to Use Suprtool with IMAGE............................................................. 58

TurboIMAGE Compatibility....................................................................... 59

Locking of IMAGE Datasets....................................................................... 59

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

B-trees.................................................................................................... 61

Master Dataset Expansion (MDX)................................................................ 61

Jumbo Datasets and Large Datasets............................................................... 61

Suprtool and KSAM Files...................................................................................... 62

Locking Output KSAM Files...................................................................... 62

Locking Input KSAM Files........................................................................ 62

Compatibility Mode KSAM/V Files............................................................ 63

Reorganizing KSAM/V Files...................................................................... 63

KSAM/XL Files....................................................................................... 64

Loading KSAM/XL Files........................................................................... 64

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

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

Suprtool and MPE Files......................................................................................... 65

Buffered and NOBUF File Access................................................................ 65

Message Files........................................................................................... 66

Circular Files........................................................................................... 66

RIO Files................................................................................................ 66

Temporary Files........................................................................................ 67

Lockwords............................................................................................... 67

Copying User Labels................................................................................. 67

SDUnix Utility..................................................................................................... 68

SDUnix Parameters................................................................................... 68

LF vs. NOLF........................................................................................... 68

Examples................................................................................................. 68

Link vs. Query......................................................................................... 69

Suprtool and Self-Describing Files........................................................................... 69

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

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

SD Files as Input...................................................................................... 70

Listing SD Files....................................................................................... 70

Decimal Places and Date Formats................................................................. 70

Restrictions of SD Files............................................................................. 70

Creating KSAM SD Files........................................................................... 71

HowMessy Loadfile................................................................................... 72

Notes on SD Files..................................................................................... 72

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

Suprtool and Sorting Files...................................................................................... 72

Fast Sorting............................................................................................. 73

Native Language Support............................................................................ 73

With Reduced Disc Space........................................................................... 73

Suprtool and Tape Files......................................................................................... 74

Labelled Tapes.......................................................................................... 74

Multiple Files.......................................................................................... 75

Notes...................................................................................................... 75

File User Labels........................................................................................ 75

Suprtool and Remote File Access............................................................................. 76

Network Services (NS)............................................................................... 76

Suprtool and MPE/iX............................................................................................ 76

Calling Suprtool in Native Mode................................................................. 76

User XL Files........................................................................................... 76

When Errors Occur.................................................................................... 77

Sorting with Suprtool/iX............................................................................ 77

Suprtool and CI Variable Substitution...................................................................... 77

Example.................................................................................................. 77

Batch Requires Indent................................................................................ 78

Avoiding Double Resolution....................................................................... 78

Suprlink and STExport.............................................................................. 79

Suprtool and User Prompting.................................................................................. 79

Example.................................................................................................. 80

Resolving Variables................................................................................... 80

Suprtool and Personal Computers............................................................................ 80

Downloading to the PC.............................................................................. 81

Decimal Places......................................................................................... 81

Spreadsheets............................................................................................. 81

Suprtool and PowerHouse Applications..................................................................... 81

Suprtool with Quiz/QTP............................................................................ 81

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

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

Step 3:  Report with Quiz........................................................................... 82

Using QTP to Create Subfiles..................................................................... 83

Creating Subfile with Command File........................................................... 83

Suprtool and PowerHouse Data-Types........................................................... 85

Suprtool Definitions - QSCHEMA............................................................... 87

Notes on QSHOW Output.......................................................................... 88

The Quiz Report....................................................................................... 89

Quiz: Generating Suprtool Commands.......................................................... 90

Generating Suprtool Commands from Quick.................................................. 90

Suprtool and Application Systems........................................................................... 91

Third-Party Indexing.................................................................................. 91

Z-type TPI-keys........................................................................................ 91

Omnidex without TPI................................................................................ 92

OmniQuest.............................................................................................. 93

Suprtool with TRANSACT........................................................................ 93

XSORT and RPG..................................................................................... 94

QUERY Program...................................................................................... 94

SRN Chronos Dates.................................................................................. 95

Year 2000 Solutions with Suprtool.......................................................................... 95

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

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

Stddate and Set Date Cutoff........................................................................ 96

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

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

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

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

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

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

aammdd Date Format................................................................................. 98

Invalid Dates............................................................................................ 99

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

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

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

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

Year 2000 Testing................................................................................... 103

Performance Issues............................................................................................... 104

Native Mode and Compatibility Mode........................................................ 104

CPU-Bound?.......................................................................................... 104

Sort Speed............................................................................................. 105

Analyzing Performance Data...................................................................... 105

Suprtool Performance Hints....................................................................... 106

Obtaining Accurate Measurements.............................................................. 106

Performance Summary.............................................................................. 107

Suprtool Functions.............................................................................................. 107

UC4/Scripting and Functions................................................................................ 107

String/Byte Functions.......................................................................................... 108

$TRIM (Works on byte type fields)........................................................................ 108

If Usage:................................................................................................ 108

Extract Usage (target: Byte type fields)........................................................ 108

Example:............................................................................................... 108

Data Examples Before and After:................................................................ 109

$LTRIM (Works on Byte type fields)...................................................................... 109

If Usage:................................................................................................ 109

Extract Usage (target: Byte type fields)........................................................ 109

Example:............................................................................................... 109

Data Examples before and after:.................................................................. 109

$RTRIM (Works on Byte type fields)..................................................................... 109

If Usage:................................................................................................ 110

Extract Usage (target: Byte type fields)........................................................ 110

Example:............................................................................................... 110

Data Examples:....................................................................................... 110

Data Result............................................................................................ 110

$UPPER (Works on Byte-type fields)..................................................................... 110

If Usage:................................................................................................ 110

Extract Usage (target: Byte type fields)........................................................ 110

Example:............................................................................................... 110

Data Examples:....................................................................................... 110

$LOWER (Works on Byte-type fields).................................................................... 111

If Usage:................................................................................................ 111

Extract Usage:......................................................................................... 111

Example:............................................................................................... 111

Data Examples:....................................................................................... 111

$PROPER (Works on Byte-type fields)................................................................... 111

If Usage:................................................................................................ 111

Extract Usage:......................................................................................... 111

Example:............................................................................................... 111

Data Examples:....................................................................................... 111

$SPLIT (Works on Byte-type fields)....................................................................... 112

If Usage:................................................................................................ 112

Extract Usage:......................................................................................... 112

Data Examples:....................................................................................... 112

Data Examples:....................................................................................... 112

$FINDCLEAN (Works on Byte-type fields)............................................................. 112

If Usage:................................................................................................ 112

$CLEAN (Works on Byte-type fields)..................................................................... 112

If Usage: (Not commonly used).................................................................. 113

Extract Usage:......................................................................................... 113

Example:............................................................................................... 113

Data Examples:....................................................................................... 113

$TRANSLATE (Works on Byte-type fields)............................................................. 113

If Usage:................................................................................................ 113

Extract Usage:......................................................................................... 113

Data Examples: (Using above code)............................................................ 113

$ETOA.............................................................................................................. 113

Extract Usage:......................................................................................... 114

$ATOE.............................................................................................................. 114

Extract Usage:......................................................................................... 114

String Addition................................................................................................... 114

Extract Usage:......................................................................................... 114

Example:............................................................................................... 114

Data Result:........................................................................................... 114

Numeric Functions.............................................................................................. 114

$TRUNCATE..................................................................................................... 114

If Usage:................................................................................................ 115

Extract Usage:......................................................................................... 115

$ABS................................................................................................................ 115

IF Usage:............................................................................................... 115

Extract Usage:......................................................................................... 115

$TOTAL............................................................................................................ 115

IF Usage:............................................................................................... 115

Extract Usage:......................................................................................... 115

$SUBTOTAL..................................................................................................... 115

IF Usage:............................................................................................... 115

Extract Usage:......................................................................................... 116

Example of $TOTAL and $SUBTOTAL...................................................... 116

$COUNTER....................................................................................................... 116

IF Usage:............................................................................................... 116

Extract Usage:......................................................................................... 117

$SUBCOUNT.................................................................................................... 117

IF Usage:............................................................................................... 117

Extract Usage:......................................................................................... 117

Examples for $counter and $subcount:......................................................... 117

$SIGNED.......................................................................................................... 118

IF Usage:............................................................................................... 118

Extract Usage:......................................................................................... 118

Arithmetic Operations.......................................................................................... 118

+ - * / mod............................................................................................ 118

If Usage:................................................................................................ 118

Extract Usage:......................................................................................... 118

Conversion/Formatting......................................................................................... 118

$NUMBER........................................................................................................ 118

If Usage:................................................................................................ 119

Extract Usage:......................................................................................... 119

Data Examples:....................................................................................... 119

$EDIT............................................................................................................... 119

If Usage:................................................................................................ 119

Extract Usage:......................................................................................... 119

Data Examples:....................................................................................... 119

Other Functions.................................................................................................. 119

$LOOKUP......................................................................................................... 119

If Usage:................................................................................................ 120

Extract Usage:......................................................................................... 120

$READ............................................................................................................. 120

If Usage:................................................................................................ 120

Date Functions.................................................................................................... 120

$TODAY........................................................................................................... 120

If Usage:................................................................................................ 120

Extract Usage:......................................................................................... 120

$DATE.............................................................................................................. 120

If Usage:................................................................................................ 121

Extract Usage:......................................................................................... 121

$INVALID......................................................................................................... 121

If Usage:................................................................................................ 121

Extract Usage:......................................................................................... 121

$STDDATE....................................................................................................... 121

If Usage:................................................................................................ 121

Extract Usage:......................................................................................... 121

$DAYS............................................................................................................. 121

If Usage:................................................................................................ 122

Extract Usage:......................................................................................... 122

Suprtool Commands                                                                                            123

General Notes..................................................................................................... 123

Abbreviating........................................................................................... 123

Uppercase or Lowercase............................................................................ 123

Multiple Commands per Line.................................................................... 123

Continuation.......................................................................................... 124

Comments on Command Lines.................................................................. 124

STREAMX............................................................................................ 124

MPE Commands..................................................................................... 125

MPE/iX Commands................................................................................ 125

Calculator.............................................................................................. 125

Control-Y Interrupt.................................................................................. 125

Error Recovery........................................................................................ 126

Add Command  [AD]........................................................................................... 127

Base Command  [BA].......................................................................................... 128

Before Command  [B].......................................................................................... 131

Chain Command  [C]........................................................................................... 133

Clean Command  [CL]......................................................................................... 136

Removing Bad Characters......................................................................... 136

Define Command  [D].......................................................................................... 137

Delete Command  [DEL]...................................................................................... 142

Do Command  [DO]............................................................................................ 144

Duplicate Command  [DU].................................................................................... 145

Edit Command  [ED]........................................................................................... 150

Exit Command  [E]............................................................................................. 151

Export Command  [EXP]...................................................................................... 153

Extract Command  [EXT]..................................................................................... 154

Constants............................................................................................... 154

Dates..................................................................................................... 156

Range of Fields....................................................................................... 158

Numeric Expressions................................................................................ 160

$SubTotal Function................................................................................. 162

$Total Function...................................................................................... 162

$Counter Function................................................................................... 162

String Expressions................................................................................... 163

Splitting Variable Length Strings............................................................... 164

Cleaning your Data.................................................................................. 166

Clean Command Syntax........................................................................... 166

Setting the Clean Character....................................................................... 166

Cleaning a Field...................................................................................... 166

Cleaning your data................................................................................... 167

Extract from a Table................................................................................. 167

Data Conversion...................................................................................... 168

$Number Function................................................................................... 170

Numeric to Byte Conversion..................................................................... 171

$Edit Function........................................................................................ 171

Placeholders and Format Characters............................................................ 171

Byte-Type Formatting.............................................................................. 171

Z-placeholder for byte-fields...................................................................... 172

Overflow and limits................................................................................. 172

Numeric field edit-masks.......................................................................... 173

Signs.................................................................................................... 173

Decimal Places........................................................................................ 174

Data and Edit mask:................................................................................. 174

Currency and Dollar signs......................................................................... 174

Overflow and floating dollar...................................................................... 175

Set CurrencySymbol................................................................................ 175

Overflow and limits................................................................................. 175

Form Command  [F]............................................................................................ 178

Get Command  [G].............................................................................................. 183

Help Command  [H]............................................................................................ 186

If Command  [IF]................................................................................................ 187

Expressions............................................................................................ 187

Constants............................................................................................... 190

Subscripts.............................................................................................. 191

Numeric Expressions................................................................................ 192

String Expressions................................................................................... 194

Date Selection......................................................................................... 198

Long Expressions.................................................................................... 204

Input Command  [I]............................................................................................. 207

Item Command  [IT]............................................................................................ 210

Date Formats.......................................................................................... 210

Decimal Places........................................................................................ 213

Notes.................................................................................................... 214

Key Command  [K]............................................................................................. 216

Link Command  [LIN]......................................................................................... 218

List Command  [L].............................................................................................. 219

Format.................................................................................................. 219

LaserJet Listings..................................................................................... 220

Headings in Listings................................................................................ 221

Simple Reports....................................................................................... 222

List Device............................................................................................. 223

Listredo Command  [LISTREDO].......................................................................... 225

Numrecs Command  [N]....................................................................................... 226

Open Command  [OP].......................................................................................... 228

Output Command  [O]......................................................................................... 229

Put Command  [P].............................................................................................. 236

Q Command  [Q]................................................................................................ 238

Redo Command  [REDO]..................................................................................... 239

Reset Command  [R]........................................................................................... 242

Select Command [SEL]........................................................................................ 243

Set Command  [S]............................................................................................... 244

Allbase.................................................................................................. 246

Arithmetic.............................................................................................. 246

Baseclose............................................................................................... 246

Blocksize............................................................................................... 246

Buffer.................................................................................................... 246

CleanChar.............................................................................................. 247

CurrencySymbol..................................................................................... 247

Date Cutoff............................................................................................ 247

Date ForceCentury................................................................................... 249

Date IfYY2000Error................................................................................. 249

Date MapToPHDate8............................................................................... 249

DecimalSymbol...................................................................................... 250

Defer..................................................................................................... 250

DumpOnError......................................................................................... 250

EditStopError......................................................................................... 250

Eofread.................................................................................................. 251

FastRead................................................................................................ 251

Filecode................................................................................................. 251

Filename................................................................................................ 252

Firstrec.................................................................................................. 252

Hints..................................................................................................... 252

Ifcheck................................................................................................... 252

Ignore.................................................................................................... 253

InitExtents............................................................................................. 253

ItemAbbreviateDate.................................................................................. 253

ItemLock............................................................................................... 253

Interactive.............................................................................................. 254

LabelledTapeRewind................................................................................ 254

Limits................................................................................................... 254

List....................................................................................................... 255

List Date................................................................................................ 255

List PCL............................................................................................... 256

List Time............................................................................................... 257

Lock..................................................................................................... 257

MakeAbsent........................................................................................... 258

NLS...................................................................................................... 258

NumBug................................................................................................ 259

Openmode.............................................................................................. 259

Oracle Rows........................................................................................... 259

Oracle OpenFix....................................................................................... 259

Oracle Integer.......................................................................................... 259

Oracle PassShift...................................................................................... 259

Oracle ZeroNull....................................................................................... 260

Pattern................................................................................................... 260

Prefetch................................................................................................. 260

Privmode............................................................................................... 261

Progress................................................................................................. 261

Prompt.................................................................................................. 262

RealMap................................................................................................ 262

Recover................................................................................................. 262

Redo..................................................................................................... 262

Sortfast.................................................................................................. 263

Squeeze................................................................................................. 264

Statistics................................................................................................ 264

Subsystem............................................................................................. 264

Suspend................................................................................................. 265

ThousandSymbol.................................................................................... 265

Userlabels.............................................................................................. 265

Varsub................................................................................................... 266

VarsubCompat........................................................................................ 266

VarsubDebug.......................................................................................... 266

Warnings............................................................................................... 266

Xltrim................................................................................................... 267

Sort Command  [SO]........................................................................................... 268

Table Command [TA].......................................................................................... 270

Adding Individual Values to a Table........................................................... 270

Adding Values from a File........................................................................ 271

TRanslate Command [TR].................................................................................... 275

Total Command [T]............................................................................................. 277

Update Command  [UP]....................................................................................... 279

Use Command  [U].............................................................................................. 280

Userpause Command  [USER]............................................................................... 282

Verify Command  [V].......................................................................................... 283

Xeq Command  [X]............................................................................................. 284

Calculator Command [=]...................................................................................... 285

Suprtool Errors and Warnings                                                                           288

Two Types Of Messages....................................................................................... 288

Errors................................................................................................................ 288

Warnings........................................................................................................... 289

Welcome to STExport                                                                                          291

Welcome to STExport.......................................................................................... 291

Installing STExport............................................................................................. 291

Built-In File Names............................................................................................. 291

Accessing STExport                                                                                            293

How To Run STExport........................................................................................ 293

How to Xeq an STExport Task.............................................................................. 293

Son Process........................................................................................................ 293

Suprtool Export Command................................................................................... 294

Preventing MPE Commands................................................................................. 294

Exit with Verify.................................................................................................. 294

Preventing STExport from Suspending.................................................................... 294

Job Control Word................................................................................................ 295

Using STExport in Batch...................................................................................... 295

Summary of Parm= Values................................................................................... 295

STExportOutCount JCW...................................................................................... 295

STExportFullCount Variable................................................................................. 296

Introduction to STExport                                                                                     297

Importing Data.................................................................................................... 297

Input File........................................................................................................... 297

Data-Types......................................................................................................... 297

Formatting Commands......................................................................................... 298

Commands......................................................................................................... 298

Performance Considerations................................................................................... 298

CI Variable Substitution....................................................................................... 299

STExport Commands                                                                                          301

General Notes..................................................................................................... 301

Abbreviating........................................................................................... 301

Uppercase or Lowercase............................................................................ 301

Comments on Command Lines.................................................................. 301

STREAMX............................................................................................ 302

MPE Commands..................................................................................... 302

MPE/iX Commands................................................................................ 302

File Names............................................................................................. 302

Calculator.............................................................................................. 303

Control-Y.............................................................................................. 303

Before Command  [B].......................................................................................... 304

Clean Command  [CL]......................................................................................... 306

Removing Bad Characters......................................................................... 306

Columns Command  [C]...................................................................................... 307

Date Command  [DA].......................................................................................... 308

Decimal Command  [DEC]................................................................................... 310

Delimiter Command  [DE].................................................................................... 311

Do Command  [DO]............................................................................................ 312

Escape Command  [ES]........................................................................................ 313

Exit Command  [E]............................................................................................. 314

Exit Abort [EA]...................................................................................... 314

Exit Suspend [ES]................................................................................... 314

Exit Xeq [EX]......................................................................................... 314

Floating Command  [FL]...................................................................................... 316

Form Command  [F]............................................................................................ 317

Heading Command  [HEA]................................................................................... 319

Help Command  [H]............................................................................................ 321

HTML Command  [HT]....................................................................................... 322

Input Command  [I]............................................................................................. 324

Listredo Command  [LISTREDO].......................................................................... 325

Output Command  [O]......................................................................................... 326

Quote Command  [Q]........................................................................................... 327

Redo Command  [REDO]..................................................................................... 328

Reset Command  [R]........................................................................................... 329

Set Command  [S]............................................................................................... 330

CleanChar.............................................................................................. 330