Suprtool 5.8 for HP-UX:
User Manual
Doc-To-Help Standard Manual
by Robelle Solutions Technology Inc.
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 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 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