Suprtool 5.8 for HP-UX:

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 are trademarks 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 - 7360 137 Street

Surrey, B.C. CanadaV3W 1A3

 

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                                                                                              18

Introduction......................................................................................................... 18

Suprtool Components............................................................................................ 18

STExport - Data Export Utility.................................................................... 18

Suprlink - Multidataset Access.................................................................... 19

Documentation..................................................................................................... 19

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

Suprtool Version 5.7                                                                                               21

Highlights in Suprtool 5.7...................................................................................... 21

Highlights in Suprtool 5.6...................................................................................... 21

Highlights in Suprtool 5.5...................................................................................... 22

Highlights in HP-UX version 5.4.01........................................................................ 22

Highlights in HP-UX version 5.4............................................................................. 23

Installing Suprtool                                                                                                   24

Overview............................................................................................................. 24

Who Needs To Use These Instructions...................................................................... 24

Instructions for HP-UX.......................................................................................... 24

Instructions for AMXW.......................................................................................... 24

Suprtool Roadmap for HP-UX                                                                              25

Road Map to Suprtool on HP-UX............................................................................ 25

Suprtool for HP-UX.................................................................................. 25

Suprtool for HP-UX, with Dynamic Image loading......................................... 25

Suprtool for AMXW.................................................................................. 25

Quick Start Guide for Suprtool                                                                             26

How to Run Suprtool............................................................................................ 26

What is a Task?.................................................................................................... 26

Copying Files...................................................................................................... 27

Copying One File..................................................................................... 27

Appending to a File................................................................................... 27

Fields in Data Files............................................................................................... 27

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

Creating an SD File................................................................................... 27

Define Fields in a Data File........................................................................ 27

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

Repeating Commands............................................................................................ 28

Repeating a Command............................................................................... 28

Selecting Database Records..................................................................................... 29

Select All Records..................................................................................... 29

Look at the First Few Records..................................................................... 29

Selecting by Criteria.............................................................................................. 30

Simple Criteria......................................................................................... 30

Complex Criteria...................................................................................... 30

String of Digits........................................................................................ 30

Selecting by Date.................................................................................................. 30

Select by Today's Date............................................................................... 31

Select by Particular Date............................................................................. 31

Select by Year.......................................................................................... 31

Select Prior Month.................................................................................... 31

Selecting by Lists of Values.................................................................................... 32

Finding Data Based on a List...................................................................... 32

Finding Data Based on a File...................................................................... 32

Finding Data Based on Another TableÕs Criteria............................................. 33

Finding Data in a Data File......................................................................... 33

Sorting Database Records....................................................................................... 33

Sort Records............................................................................................ 33

Sort Records in Descending Order................................................................ 34

Sort by Multiple Keys............................................................................... 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 Data File Records............................................................ 36

Decimal Places..................................................................................................... 37

Converting Numbers.............................................................................................. 37

Counts and Subtotals............................................................................................. 38

Count and Subtotal on Sort Keys................................................................. 38

Sort by Count or Subtotal.......................................................................... 38

Total by Field.......................................................................................... 39

Running Totals......................................................................................... 39

Running SubTotals................................................................................... 39

Listing Records.................................................................................................... 40

Changing the Output Record Format........................................................................ 40

Producing a Condensed Table Listing....................................................................... 41

Simple Reports..................................................................................................... 41

Your First Report...................................................................................... 41

Column Headings..................................................................................... 42

Printing Mailing Labels............................................................................. 42

Running Suprtool under HP-UX                                                                           45

Running Suprtool................................................................................................. 45

Configuring Different Shells................................................................................... 45

Bourne and Korn Shells............................................................................. 45

C Shell................................................................................................... 45

Setting Up a PATH for Suprtool.............................................................................. 46

Bourne and Korn Shells............................................................................. 46

C Shell................................................................................................... 46

Dynamic Loading.................................................................................................. 46

Control Characters and stty..................................................................................... 48

Suprmgr Configuration Files................................................................................... 48

On-Line vs. Batch Access....................................................................................... 49

Command Line Options......................................................................................... 49

Initial Command Line:  -ccmdstring............................................................. 49

Default Outcount File Name:  -oc................................................................. 49

Exit with Verify:  -v.................................................................................. 50

Combining -c and -v.................................................................................. 50

Loader Warnings....................................................................................... 50

HP-UX Notes....................................................................................................... 50

Shell Commands...................................................................................... 50

Hardcoded File Names and ROBELLE Variable.......................................................... 51

ROBELLE Variable................................................................................... 51

/opt/robelle/suprmgr.................................................................................. 51

/opt/robelle/help/suprtool............................................................................ 51

Outcount File........................................................................................... 51

Differences Between MPE and HP-UX...................................................................... 52

Record Length.......................................................................................... 52

Line Feeds............................................................................................... 52

Duplicate Output Files............................................................................... 52

Classic Reals............................................................................................ 52

Input from Stdlist..................................................................................... 53

Missing Features....................................................................................... 53

Suprtool and AMXW                                                                                                55

What is AMXW.................................................................................................... 55

What is Suprtool for AMXW.................................................................................. 55

Running Suprtool................................................................................................. 55

Symbolic Links and running Supramxw.................................................................... 55

Suprtool/AMXW.................................................................................................. 56

Form Command....................................................................................... 56

Numrecs Command................................................................................... 56

Output Command..................................................................................... 56

Temporary Files........................................................................................ 57

Appending Records................................................................................... 57

Table operations........................................................................................ 57

Variable Substitution................................................................................. 57

Set Commands......................................................................................... 57

Command Details for AMXW                                                                               58

AMXW............................................................................................................... 58

Numrecs Command  [N]......................................................................................... 59

Set Commands..................................................................................................... 60

AMXW Externalsd.................................................................................... 60

AMXW PerfWrite..................................................................................... 60

Filecode.................................................................................................. 60

Squeeze................................................................................................... 61

Suprtool Issues and Solutions                                                                             62

A Suprtool Task................................................................................................... 62

Input Choices........................................................................................... 62

Processing Selections................................................................................. 62

Output Choices......................................................................................... 62

Large File Support................................................................................................ 63

Suprtool and Allbase............................................................................................. 63

Data-Types............................................................................................... 63

Date and Time Types................................................................................. 64

Restrictions.............................................................................................. 64

Suprtool and Oracle............................................................................................... 64

Data-Types............................................................................................... 64

Number Data-Type.................................................................................... 65

Order By vs. Sort...................................................................................... 65

Restrictions.............................................................................................. 65

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

Installation............................................................................................... 66

SDUnix Parameters................................................................................... 67

LF vs. NOLF........................................................................................... 67

Examples................................................................................................. 67

Link vs. Query......................................................................................... 68

Suprtool and Self-Describing Files........................................................................... 68

Create an SD File from a Table.................................................................... 68

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

SD Files as Input...................................................................................... 69

Listing SD Files....................................................................................... 69

Decimal Places and Date Formats................................................................. 69

Extended Field Names............................................................................... 69

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

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

Suprtool and Personal Computers............................................................................ 70

Downloading to the PC.............................................................................. 70

Decimal Places......................................................................................... 71

Spreadsheets............................................................................................. 71

Suprtool and PowerHouse Applications..................................................................... 71

Suprtool with Quiz/QTP............................................................................ 71

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

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

Step 3: Report with Quiz............................................................................ 72

Using QTP to Create Subfiles..................................................................... 72

Creating Subfile with Script File................................................................. 72

Quiz: Generating Suprtool Commands.......................................................... 73

Year 2000 Solutions with Suprtool.......................................................................... 73

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

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

Stddate and Set Date Cutoff........................................................................ 74

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

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

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

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

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

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

aammdd Date Format................................................................................. 77

Invalid Dates............................................................................................ 77

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

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

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

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

Year 2000 Testing..................................................................................... 81

Performance Issues................................................................................................ 82

Eloquence Performance............................................................................... 82

Sort Performance....................................................................................... 82

Oracle Performance.................................................................................... 82

Analyzing Performance Data........................................................................ 83

Variable Substitution............................................................................................. 83

Suprtool Functions................................................................................................ 84

UC4/Scripting and Functions.................................................................................. 84

String/Byte Functions............................................................................................ 84

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

If Usage:.................................................................................................. 85

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

Example:................................................................................................. 85

Data Examples Before and After:.................................................................. 85

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

If Usage:.................................................................................................. 85

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

Example:................................................................................................. 85

Data Examples before and after:................................................................... 85

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

If Usage:.................................................................................................. 86

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

Example:................................................................................................. 86

Data Examples:......................................................................................... 86

Data Result.............................................................................................. 86

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

If Usage:.................................................................................................. 87

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

Example:................................................................................................. 87

Data Examples:......................................................................................... 87

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

If Usage:.................................................................................................. 87

Extract Usage:.......................................................................................... 87

Example:................................................................................................. 87

Data Examples:......................................................................................... 87

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

If Usage:.................................................................................................. 88

Extract Usage:.......................................................................................... 88

Example:................................................................................................. 88

Data Examples:......................................................................................... 88

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

If Usage:.................................................................................................. 88

Extract Usage:.......................................................................................... 88

Data Examples:......................................................................................... 88

Data Examples:......................................................................................... 88

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

If Usage:.................................................................................................. 89

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

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

Extract Usage:.......................................................................................... 89

Example:................................................................................................. 89

Data Examples:......................................................................................... 89

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

If Usage:.................................................................................................. 90

Extract Usage:.......................................................................................... 90

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

$ETOA............................................................................................................... 90

Extract Usage:.......................................................................................... 90

$ATOE............................................................................................................... 90

Extract Usage:.......................................................................................... 90

String Addition.................................................................................................... 90

Extract Usage:.......................................................................................... 91

Example:................................................................................................. 91

Data Result:............................................................................................. 91

Numeric Functions................................................................................................ 91

$TRUNCATE...................................................................................................... 91

If Usage:.................................................................................................. 91

Extract Usage:.......................................................................................... 91

$ABS................................................................................................................. 91

IF Usage:................................................................................................. 91

Extract Usage:.......................................................................................... 91

$TOTAL............................................................................................................. 92

IF Usage:................................................................................................. 92

Extract Usage:.......................................................................................... 92

$SUBTOTAL....................................................................................................... 92

IF Usage:................................................................................................. 92

Extract Usage:.......................................................................................... 93

Example of $TOTAL and $SUBTOTAL....................................................... 93

$COUNTER........................................................................................................ 93

IF Usage:................................................................................................. 93

Extract Usage:.......................................................................................... 94

$SUBCOUNT...................................................................................................... 94

IF Usage:................................................................................................. 94

Extract Usage:.......................................................................................... 94

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

$SIGNED............................................................................................................ 95

IF Usage:................................................................................................. 95

Extract Usage:.......................................................................................... 95

Arithmetic Operations............................................................................................ 95

+ - * / mod.............................................................................................. 95

If Usage:.................................................................................................. 95

Extract Usage:.......................................................................................... 95

Conversion/Formatting.......................................................................................... 95

$NUMBER.......................................................................................................... 95

If Usage:.................................................................................................. 96

Extract Usage:.......................................................................................... 96

Data Examples:......................................................................................... 96

$EDIT................................................................................................................. 96

If Usage:.................................................................................................. 96

Extract Usage:.......................................................................................... 96

Data Examples:......................................................................................... 96

Other Functions.................................................................................................... 97

$LOOKUP........................................................................................................... 97

If Usage:.................................................................................................. 97

Extract Usage:.......................................................................................... 97

$NULL............................................................................................................... 97

$READ............................................................................................................... 97

If Usage:.................................................................................................. 97

Date Functions..................................................................................................... 98

$TODAY............................................................................................................. 98

If Usage:.................................................................................................. 98

Extract Usage:.......................................................................................... 98

$DATE............................................................................................................... 98

If Usage:.................................................................................................. 98

Extract Usage:.......................................................................................... 98

$INVALID........................................................................................................... 98

If Usage:.................................................................................................. 98

Extract Usage:.......................................................................................... 98

$STDDATE......................................................................................................... 99

If Usage:.................................................................................................. 99

Extract Usage:.......................................................................................... 99

$DAYS............................................................................................................... 99

If Usage:.................................................................................................. 99

Extract Usage:.......................................................................................... 99

Suprtool Commands                                                                                            100

General Notes..................................................................................................... 100

Abbreviating........................................................................................... 100

Uppercase or Lowercase............................................................................ 100

Multiple Commands per Line.................................................................... 100

Continuation.......................................................................................... 101

Comments on Command Lines.................................................................. 101

HP-UX Commands.................................................................................. 102

Calculator.............................................................................................. 102

Control-Y Interrupt.................................................................................. 102

Add Command  [Add].......................................................................................... 103

Notes.................................................................................................... 103

Examples............................................................................................... 103

Base Command  [BA].......................................................................................... 105

Before Command  [B].......................................................................................... 107

Chain Command  [C]........................................................................................... 109

Clean Command  [CL]......................................................................................... 111

Removing Bad Characters......................................................................... 111

Define Command  [D].......................................................................................... 112

Delete Command  [DEL]...................................................................................... 117

Do Command  [DO]............................................................................................ 119

Duplicate Command  [DU].................................................................................... 120

Edit Command  [ED]........................................................................................... 125

Exit Command  [E]............................................................................................. 126

Export Command  [EXP]...................................................................................... 128

Extract Command  [EXT]..................................................................................... 129

Constants............................................................................................... 129

Dates..................................................................................................... 131

Range of Fields....................................................................................... 133

Numeric Expressions................................................................................ 135

$SubTotal Function................................................................................. 136

$Total Function...................................................................................... 137

$Counter Function................................................................................... 137

String Expressions................................................................................... 138

Splitting Variable Length Strings............................................................... 139

Cleaning your Data.................................................................................. 140

Un-printables.......................................................................................... 140

Clean Command Syntax........................................................................... 141

Setting the Clean Character....................................................................... 141

Cleaning a Field...................................................................................... 141

Cleaning your data................................................................................... 141

Extract from a Table................................................................................. 142

Data Conversion...................................................................................... 143

$Number Function................................................................................... 144

Numeric to Byte Conversion..................................................................... 145

$Edit Function........................................................................................ 146

Placeholders and Format Characters............................................................ 146

Byte-Type Formatting.............................................................................. 146

Z-placeholder for byte-fields...................................................................... 147

Overflow and limits................................................................................. 147

Numeric field edit-masks.......................................................................... 148

Signs.................................................................................................... 148

Decimal Places........................................................................................ 149

Data and Edit mask:................................................................................. 149

Currency and Dollar signs......................................................................... 149

Overflow and floating dollar...................................................................... 150

Set CurrencySymbol................................................................................ 150

Overflow and limits................................................................................. 150

Restrictions............................................................................................ 150

Form Command  [F]............................................................................................ 153

Get Command  [G].............................................................................................. 156

Help Command  [H]............................................................................................ 158

If Command  [IF]................................................................................................ 159

Expressions............................................................................................ 159

Constants............................................................................................... 162

Subscripts.............................................................................................. 163

Numeric Expressions................................................................................ 164

String Expressions................................................................................... 166

Date Selection......................................................................................... 169

Long Expressions.................................................................................... 174

Input Command  [I]............................................................................................. 177

Item Command  [IT]............................................................................................ 179

Date Formats.......................................................................................... 179

Decimal Places........................................................................................ 182

Notes.................................................................................................... 183

Key Command  [K]............................................................................................. 185

Link Command  [LIN]......................................................................................... 187

List Command  [L].............................................................................................. 188

Format.................................................................................................. 188

LaserJet Listings..................................................................................... 189

Headings in Listings................................................................................ 190

Simple Reports....................................................................................... 191

List Device............................................................................................. 192

List File................................................................................................ 192

Listredo Command  [LISTREDO].......................................................................... 195

Numrecs Command  [N]....................................................................................... 196

Open Command  [OP].......................................................................................... 197

Remote Databases and Oracle Issues............................................................ 197

Output Command  [O]......................................................................................... 198

Put Command  [P].............................................................................................. 204

Q Command  [Q]................................................................................................ 205

Redo Command  [REDO]..................................................................................... 206

Reset Command  [R]........................................................................................... 209

Select Command  [SEL]....................................................................................... 210

Set Command  [S]............................................................................................... 211

Allbase.................................................................................................. 213

Arithmetic.............................................................................................. 213

Baseclose............................................................................................... 213

Blocksize............................................................................................... 213

Buffer.................................................................................................... 213

CleanChar.............................................................................................. 213

Comlog................................................................................................. 214

CurrencySymbol..................................................................................... 214

Date Cutoff............................................................................................ 215

Date ForceCentury................................................................................... 216

Date IfYY2000Error................................................................................. 216

Date MapToPHDate8............................................................................... 217

DecimalSymbol...................................................................................... 217

Defer..................................................................................................... 217

DumpOnError......................................................................................... 217

EditStopError......................................................................................... 217

Eofread.................................................................................................. 218

FastRead................................................................................................ 218

Filecode................................................................................................. 218

Filename................................................................................................ 218

Firstrec.................................................................................................. 219

Hints..................................................................................................... 219

HPUXCmdErr Ò<string>Ó......................................................................... 219

Ifcheck................................................................................................... 220

Ignore.................................................................................................... 220

InitExtents............................................................................................. 220

ItemAbbreviateDate.................................................................................. 220

ItemLock............................................................................................... 220

Interactive.............................................................................................. 221

LabelledTapeRewind................................................................................ 221

Limits................................................................................................... 221

Table Size.............................................................................................. 221

Read Only.............................................................................................. 222

List....................................................................................................... 222

List Date................................................................................................ 222

List PCL............................................................................................... 222

List Time............................................................................................... 224

List FormFeed........................................................................................ 224

Lock..................................................................................................... 224

MakeAbsent........................................................................................... 224

NLS...................................................................................................... 224

NumBug................................................................................................ 225

Openmode.............................................................................................. 225

Oracle Rows........................................................................................... 226

Oracle Integer.......................................................................................... 226

Oracle OpenFix....................................................................................... 226

Oracle PassShift...................................................................................... 227

Oracle SpaceNull..................................................................................... 227

Oracle ZeroNull....................................................................................... 227

Pattern................................................................................................... 227

Prefetch................................................................................................. 228

Privmode............................................................................................... 228

Progress................................................................................................. 228

Prompt.................................................................................................. 229

RealMap................................................................................................ 229

Recover................................................................................................. 229

Redo..................................................................................................... 229

SDExtname............................................................................................ 230

Sortfast.................................................................................................. 231

Squeeze................................................................................................. 231

Statistics................................................................................................ 231

Subsystem............................................................................................. 231

Suspend................................................................................................. 231

ThousandSymbol.................................................................................... 231

Userlabels.............................................................................................. 231

Varsub................................................................................................... 231

VarsubCompat........................................................................................ 232

VarsubDebug.......................................................................................... 232

Warnings............................................................................................... 232

Sort Command  [SO]........................................................................................... 233

Table Command [TA].......................................................................................... 235

Adding Individual Values to a Table........................................................... 235

Adding Values from a File........................................................................ 236

TRanslate Command [TR].................................................................................... 239

Total Command [T]............................................................................................. 240

Update Command  [UP]....................................................................................... 242

Use Command  [U].............................................................................................. 243

Userpause Command  [USER]............................................................................... 245

Verify Command  [V].......................................................................................... 246

Xeq Command  [X]............................................................................................. 247

Calculator Command [=]...................................................................................... 248

Suprtool Errors and Warnings                                                                           251

Two Types Of Messages....................................................................................... 251

Errors................................................................................................................ 251

Warnings........................................................................................................... 252

Welcome to STExport                                                                                          253

Welcome to STExport.......................................................................................... 253

Installing STExport............................................................................................. 253

Accessing STExport                                                                                            255

How To Run STExport........................................................................................ 255

How to Xeq an STExport Task.............................................................................. 255

Hardcoded File Names and ROBELLE Variable........................................................ 255

ROBELLE Variable................................................................................. 255

Using STExport in Batch...................................................................................... 256

Command Line Options....................................................................................... 256

Default Outcount File Name:  -oc............................................................... 256

Variable Substitution -v............................................................................ 256

Introduction to STExport                                                                                     257

Importing Data.................................................................................................... 257

Input File........................................................................................................... 257

Data-Types......................................................................................................... 257

Formatting Commands......................................................................................... 258

Commands......................................................................................................... 258

Performance Considerations................................................................................... 258

STExport Commands                                                                                          259

General Notes..................................................................................................... 259

Abbreviating........................................................................................... 259

Uppercase or Lowercase............................................................................ 259

Comments on Command Lines.................................................................. 259

HP-UX Commands.................................................................................. 259

File Names............................................................................................. 260

Calculator.............................................................................................. 260

Control-Y.............................................................................................. 260

Before Command  [B].......................................................................................... 261

Clean Command  [CL]......................................................................................... 263

Removing Bad Characters......................................................................... 263

Columns Command  [C]...................................................................................... 264

Date Command  [DA].......................................................................................... 265

Decimal Command  [DEC]................................................................................... 267

Delimiter Command  [DE].................................................................................... 268

Do Command  [DO]............................................................................................ 269

Escape Command  [ES]........................................................................................ 270

Exit Command  [E]............................................................................................. 271

Exit Abort [EA]...................................................................................... 271

Exit Suspend [ES]................................................................................... 271

Exit Xeq [EX]......................................................................................... 271

Floating Command  [FL]...................................................................................... 272

Form Command  [F]............................................................................................ 273

Heading Command  [HEA]................................................................................... 274

Help Command  [H]............................................................................................ 276

HTML Command  [HT]....................................................................................... 277

Dynamic Web Pages................................................................................ 279

Web Server............................................................................................. 279

Shell Script............................................................................................ 280

Perl Script.............................................................................................. 282

CGI Script............................................................................................. 283

Input Command  [I]............................................................................................. 285

Listredo Command  [LISTREDO].......................................................................... 286

Output Command  [O]......................................................................................... 287

Quote Command  [Q]........................................................................................... 288

Redo Command  [REDO]..................................................................................... 289

Reset Command  [R]........................................................................................... 290

Set Command  [S]............................................................................................... 291

CleanChar.............................................................................................. 291

Comlog................................................................................................. 291

Mapped................................................................................................. 292

Redo..................................................................................................... 292

Statistics................................................................................................ 293

Varsub................................................................................................... 293

VarsubCompat........................................................................................ 293

VarsubDebug.......................................................................................... 293

Warnings............................................................................................... 294

Xmltagchar............................................................................................. 294

ZonedFix............................................................................................... 294

Sign Command  [SI]............................................................................................ 296

Spaces Command  [SP]........................................................................................ 297

Use Command  [U].............................................................................................. 298

Verify Command  [V].......................................................................................... 299

Xeq Command  [X]............................................................................................. 300

XML Command  [XML]...................................................................................... 301

Zero Command  [Z]............................................................................................. 304

Example of STExport Output                                                                             305

Example............................................................................................................ 305

Limits Within STExport                                                                                        309

Maximums......................................................................................................... 309

Welcome to Dbedit                                                                                               310

Introduction........................................................................................................ 310

Restrictions........................................................................................................ 310

Functions of Dbedit............................................................................................. 310

Performance of Dbedit.......................................................................................... 311

Field Lists......................................................................................................... 311

Database Locking................................................................................................ 312

Decimal Points................................................................................................... 312

Critical-Item Update............................................................................................. 313

Dbedit Commands                                                                                                314

General Notes..................................................................................................... 314

Abbreviating........................................................................................... 314

Uppercase or Lowercase............................................................................ 314

Continuation.......................................................................................... 314

Control-Y.............................................................................................. 315

Comments on Command Lines.................................................................. 315

OS Commands....................................................................................... 315

Calculator.............................................................................................. 315

Example Database.................................................................................... 316

Prompting for Search Criteria.................................................................... 316

Command Parameters........................................................................................... 316

File Parameter......................................................................................... 316

Option Parameter..................................................................................... 317

Numeric-Value Option.............................................................................. 317

All Option............................................................................................. 317

Key Option............................................................................................ 318

Limit Option.......................................................................................... 318

Related Option........................................................................................ 318