User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

 


 

Program and manual copyright © 1981-2010 Robelle Solutions Technology Inc.

 

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

 

Qedit and Suprtool are trademarks of Robelle Solutions Technology Inc. Oracle is a trademark of Oracle Corporation, Redwood City, California, USA. Other product and company names mentioned herein may be the trademarks of their respective owners.

 

 

 

 

 

 

 

I

 

Robelle Solutions Technology Inc.

Suite 372 - 7360 137 Street

Surrey, B.C. CanadaV3W 1A3

 

Phone:   604.501.2001

Fax:       604.501.2003

 

E-mail:  sales@robelle.com

E-mail:  support@robelle.com

Web:      www.robelle.com


Table of Contents

Suprtool 5.3 for HP-UX: 1

User Manual 1

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

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

Phone:             604.501.2001  2

Table of Contents  3

Welcome to Suprtool 16

Introduction. 16

Suprtool Components. 16

STExport - Data Export Utility. 16

Suprlink - Multidataset Access. 17

Documentation. 17

Notation. 17

Suprtool Version 5.3  19

Highlights in HP-UX version 5.3. 19

Highlights in AMXW version 5.3. 20

Installing Suprtool 21

Overview.. 21

Who Needs To Use These Instructions. 21

Instructions for HP-UX.. 21

Instructions for AMXW... 21

Suprtool Roadmap for HP-UX  22

Road Map to Suprtool on HP-UX.. 22

Suprtool for HP-UX.. 22

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

Suprtool for AMXW... 22

Quick Start Guide for Suprtool 23

How to Run Suprtool 23

What is a Task?. 23

Copying Files. 24

Copying One File. 24

Appending to a File. 24

Fields in Data Files. 24

What is a Self-Describing File?. 24

Creating an SD File. 24

Define Fields in a Data File. 24

Create an SD File from a Data File. 25

Repeating Commands. 25

Repeating a Command. 25

Selecting Database Records. 26

Select All Records. 26

Look at the First Few Records. 26

Selecting by Criteria. 27

Simple Criteria. 27

Complex Criteria. 27

String of Digits. 27

Selecting by Date. 27

Select by Today's Date. 28

Select by Particular Date. 28

Select by Year. 28

Select Prior Month. 28

Selecting by Lists of Values. 29

Finding Data Based on a List 29

Finding Data Based on a File. 29

Finding Data Based on Another Table’s Criteria. 30

Finding Data in a Data File. 30

Sorting Database Records. 30

Sort Records. 30

Sort Records in Descending Order. 31

Sort by Multiple Keys. 31

Duplicate Records. 31

Report without Duplicate Records. 31

Report Only the Duplicate Records. 32

Report Only the Unique Records. 32

Report Only the Duplicates and Their Originals. 33

Deleting Duplicate Data File Records. 33

Decimal Places. 34

Converting Numbers. 34

Counts and Subtotals. 35

Count and Subtotal on Sort Keys. 35

Sort by Count or Subtotal 35

Total by Field. 36

Running Totals. 36

Running SubTotals. 36

Listing Records. 37

Changing the Output Record Format 37

Producing a Condensed Table Listing. 38

Simple Reports. 38

Your First Report 38

Column Headings. 39

Printing Mailing Labels. 39

Running Suprtool under HP-UX  41

Running Suprtool 41

Configuring Different Shells. 41

Bourne and Korn Shells. 41

C Shell 41

Setting Up a PATH for Suprtool 42

Bourne and Korn Shells. 42

C Shell 42

Dynamic Loading. 43

Control Characters and stty. 44

Suprmgr Configuration Files. 44

On-Line vs. Batch Access. 45

Command Line Options. 45

Initial Command Line:  -ccmdstring. 45

Default Outcount File Name:  -oc. 45

Exit with Verify:  -v. 46

Combining -c and -v. 46

Loader Warnings. 46

HP-UX Notes. 46

Shell Commands. 46

Hardcoded File Names and ROBELLE Variable. 47

ROBELLE Variable. 47

opt/robelle/suprmgr. 47

opt/robelle/help/suprtool 47

Outcount File. 47

Differences Between MPE and HP-UX.. 48

Record Length. 48

Line Feeds. 48

Duplicate Output Files. 48

Classic Reals. 48

Input from Stdlist 49

Missing Features. 49

Suprtool and AMXW   51

What is AMXW... 51

What is Suprtool for AMXW... 51

Running Suprtool 51

Symbolic Links and running Supramxw.. 51

Suprtool/AMXW... 52

Form Command. 52

Numrecs Command. 52

Output Command. 52

Temporary Files. 53

Appending Records. 53

Table operations. 53

Variable Substitution. 53

Set Commands. 53

Command Details for AMXW   54

AMXW... 54

Numrecs Command  [N]. 55

Set Commands. 56

AMXW Externalsd. 56

AMXW PerfWrite. 56

Filecode. 56

Squeeze. 57

Suprtool Issues and Solutions  58

A Suprtool Task. 58

Input Choices. 58

Processing Selections. 58

Output Choices. 58

Large File Support 59

Suprtool and Allbase. 59

Data-Types. 59

Date and Time Types. 60

Restrictions. 60

Suprtool and Oracle. 60

Data-Types. 60

Number Data-Type. 61

Order By vs. Sort 61

Restrictions. 61

SDUnix Utility. 62

Installation. 62

SDUnix Parameters. 63

LF vs. NOLF. 63

Examples. 63

Link vs. Query. 64

Suprtool and Self-Describing Files. 64

Create an SD File from a Table. 64

Create an SD File from a Data File. 64

SD Files as Input 65

Listing SD Files. 65

Decimal Places and Date Formats. 65

Extended Field Names. 65

Restrictions of SD Files. 66

Suprtool and Sorting Files. 66

Suprtool and Personal Computers. 66

Downloading to the PC.. 66

Decimal Places. 67

Spreadsheets. 67

Suprtool and PowerHouse Applications. 67

Suprtool with Quiz/QTP. 67

Step 1: Create a Subfile with Quiz. 68

Step 2: Output Erase in Suprtool 68

Step 3: Report with Quiz. 68

Using QTP to Create Subfiles. 68

Creating Subfile with Script File. 68

Quiz: Generating Suprtool Commands. 69

Year 2000 Solutions with Suprtool 69

What If I Have Four-Digit Years?. 70

What does Set Date Cutoff do?. 70

Stddate and Set Date Cutoff. 70

What does Set Date ForceCentury do?. 71

What If I Have Two-Digit Years?. 71

What Is Wrong with Two-Digit Years?. 71

How Do $Today and $Date Work?. 72

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

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

aammdd Date Format 73

Invalid Dates. 73

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 75

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

Year 2000 Testing. 77

Performance Issues. 78

Eloquence Performance. 78

Sort Performance. 78

Oracle Performance. 78

Analyzing Performance Data. 79

Variable Substitution. 79

Suprtool Commands  80

General Notes. 80

Abbreviating. 80

Uppercase or Lowercase. 80

Multiple Commands per Line. 81

Continuation. 81

Comments on Command Lines. 82

HP-UX Commands. 82

Calculator. 82

Control-Y Interrupt 82

Add Command  [Add]. 83

Notes. 83

Examples. 83

Base Command  [BA]. 85

Before Command  [B]. 87

Chain Command  [C]. 89

Clean Command  [CL]. 91

Removing Bad Characters. 91

Define Command  [D]. 93

Delete Command  [DEL]. 98

Do Command  [DO]. 100

Duplicate Command  [DU]. 101

Edit Command  [ED]. 106

Exit Command  [E]. 107

Export Command  [EXP]. 109

Extract Command  [EXT]. 110

Constants. 110

Dates. 112

Range of Fields. 114

Numeric Expressions. 115

$SubTotal Function. 117

$Total Function. 117

$Counter Function. 117

String Expressions. 118

Splitting Variable Length Strings. 119

Cleaning your Data. 120

Un-printables. 121

Clean Command Syntax. 121

Setting the Clean Character. 121

Cleaning a Field. 121

Cleaning your data. 122

Extract from a Table. 122

Data Conversion. 123

$Number Function. 124

Numeric to Byte Conversion. 125

$Edit Function. 126

Placeholders and Format Characters. 126

Byte-Type Formatting. 126

Z-placeholder for byte-fields. 127

Overflow and limits. 127

Numeric field edit-masks. 128

Signs. 128

Decimal Places. 129

Data and Edit mask: 129

Currency and Dollar signs. 129

Overflow and floating dollar. 130

Set CurrencySymbol 130

Overflow and limits. 130

Restrictions. 130

Form Command  [F]. 133

Get Command  [G]. 136

Help Command  [H]. 138

If Command  [IF]. 139

Expressions. 139

Constants. 142

Subscripts. 143

Numeric Expressions. 144

String Expressions. 146

Date Selection. 149

Long Expressions. 154

Input Command  [I]. 157

Item Command  [IT]. 159

Date Formats. 159

Decimal Places. 162

Notes. 163

Key Command  [K]. 165

Link Command  [LIN]. 167

List Command  [L]. 168

Format 168

LaserJet Listings. 169

Headings in Listings. 170

Simple Reports. 171

List Device. 172

List File. 172

Listredo Command  [LISTREDO]. 175

Numrecs Command  [N]. 176

Open Command  [OP]. 177

Remote Databases and Oracle Issues. 177

Output Command  [O]. 178

Put Command  [P]. 183

Q Command  [Q]. 184

Redo Command  [REDO]. 185

Reset Command  [R]. 188

Select Command  [SEL]. 189

Set Command  [S]. 190

Allbase. 192

Arithmetic. 192

Baseclose. 192

Blocksize. 192

Buffer. 192

CleanChar. 192

CurrencySymbol 193

Date Cutoff. 193

Date ForceCentury. 194

Date IfYY2000Error. 194

Date MapToPHDate8. 195

DecimalSymbol 195

Defer. 195

DumpOnError. 196

EditStopError. 196

Eofread. 196

FastRead. 196

Filecode. 197

Filename. 197

Firstrec. 197

Hints. 197

HPUXCmdErr “<string>”. 197

Ifcheck. 198

Ignore. 198

InitExtents. 198

ItemAbbreviateDate. 198

ItemLock. 199

Interactive. 199

LabelledTapeRewind. 199

Limits. 199

Table Size. 200

Read Only. 200

List 200

List Date. 200

List PCL.. 201

List Time. 202

List FormFeed. 202

Lock. 202

MakeAbsent 203

NLS. 203

NumBug. 203

Openmode. 204

Oracle Rows. 204

Oracle Integer. 204

Oracle OpenFix. 204

Oracle PassShift 205

Oracle SpaceNull 205

Oracle ZeroNull 205

Pattern. 206

Prefetch. 206

Privmode. 206

Progress. 206

Prompt 207

RealMap. 207

Recover. 207

Redo. 207

SDExtname. 208

Sortfast 209

Squeeze. 209

Statistics. 209

Subsystem.. 209

Suspend. 209

ThousandSymbol 209

Userlabels. 210

Varsub. 210

VarsubCompat 210

VarsubDebug. 210

Warnings. 210

Sort Command  [SO]. 212

Table Command [TA]. 214

Adding Individual Values to a Table. 214

Adding Values from a File. 215

Total Command [T]. 218

Update Command  [UP]. 220

Use Command  [U]. 221

Userpause Command  [USER]. 223

Verify Command  [V]. 224

Xeq Command  [X]. 225

Calculator Command [=]. 226

Suprtool Errors and Warnings  229

Two Types Of Messages. 229

Errors. 229

Warnings. 230

Welcome to STExport 231

Welcome to STExport 231

Installing STExport 231

Accessing STExport 233

How To Run STExport 233

How to Xeq an STExport Task. 233

Hardcoded File Names and ROBELLE Variable. 233

ROBELLE Variable. 233

Using STExport in Batch. 234

Command Line Options. 234

Default Outcount File Name:  -oc. 234

Variable Substitution -v. 234

Introduction to STExport 235

Importing Data. 235

Input File. 235

Data-Types. 235

Formatting Commands. 236

Commands. 236

Performance Considerations. 236

STExport Commands  237

General Notes. 237

Abbreviating. 237

Uppercase or Lowercase. 237

Comments on Command Lines. 237

HP-UX Commands. 237

File Names. 238

Calculator. 238

Control-Y.. 238

Before Command  [B]. 239

Clean Command  [CL]. 241

Removing Bad Characters. 241

Columns Command  [C]. 242

Date Command  [DA]. 243

Decimal Command  [DEC]. 245

Delimiter Command  [DE]. 246

Do Command  [DO]. 247

Escape Command  [ES]. 248

Exit Command  [E]. 249

Exit Abort [EA]. 249

Exit Suspend [ES]. 249

Exit Xeq [EX]. 249

Floating Command  [FL]. 251

Form Command  [F]. 252

Heading Command  [HEA]. 253

Help Command  [H]. 255

HTML Command  [HT]. 256

Dynamic Web Pages. 258

Web Server. 258

Shell Script 259

Perl Script 261

CGI Script 262

Input Command  [I]. 264

Listredo Command  [LISTREDO]. 265

Output Command  [O]. 266

Quote Command  [Q]. 267

Redo Command  [REDO]. 268

Reset Command  [R]. 269

Set Command  [S]. 270

CleanChar. 270

Mapped. 270

Redo. 270

Statistics. 271

Varsub. 271

VarsubCompat 272

VarsubDebug. 272

Warnings. 272

Xmltagchar. 273

ZonedFix. 273

Sign Command  [SI]. 274

Spaces Command  [SP]. 275

Use Command  [U]. 276

Verify Command  [V]. 277

Xeq Command  [X]. 278

XML Command  [XML]. 279

Zero Command  [Z]. 282

Example of STExport Output 283

Example. 283

Limits Within STExport 287

Maximums. 287

Welcome to Dbedit 288

Introduction. 288

Restrictions. 288

Functions of Dbedit 288

Performance of Dbedit 289

Field Lists. 289

Database Locking. 290

Decimal Points. 290

Critical-Item Update. 291

Dbedit Commands  292

General Notes. 292

Abbreviating. 292

Uppercase or Lowercase. 292

Continuation. 292

Control-Y.. 293

Comments on Command Lines. 293

OS Commands. 293

Calculator. 293

Example Database. 294

Prompting for Search Criteria. 294

Command Parameters. 294

File Parameter. 294

Option Parameter. 295

Numeric-Value Option. 295

All Option. 295

Key Option. 296

Limit Option. 296

Related Option. 296

Under Option. 297

Updatekey Option. 297

Subcommands. 297

Add Command  [A]. 299

Before Command  [B]. 300

Change Command  [C]. 301

Delete Command  [D]. 302

Do Command  [DO]. 303

Exit Command  [E]. 304

File Command  [F]. 305

Form Command  [FO]. 306

Help Command  [H]. 307

List Command  [L]. 308

Listredo Command  [LISTREDO]. 309

Modify Command  [M]. 310

Q Command  [Q]. 311

Redo Command  [REDO]. 312

Set Command  [S]. 313

LP. 313

Prompt 313

Quiet 313

Reset 313

Underline. 314

Verify. 314

Use Command  [U]. 315

Verify Command  [V]. 316

Welcome to Suprlink  317

Welcome to Suprlink. 317

Terminology and HP-UX.. 317

Notation. 317

Installing Suprlink. 318

Hardcoded File Names and ROBELLE Variable. 318

ROBELLE Variable. 318

Accessing Suprlink  319

How To Run Suprlink. 319

How to Xeq a Suprlink Task. 319

Suprtool Link Command. 319

Exit with Verify. 319

Using Suprlink in Batch. 320

Command Line Options. 320

Default Outcount File Name:  -oc. 320

Variable Substitution -v. 320

Introduction to Suprlink  321

How Report Programs Work. 321

Input Files. 321

Link Files. 321

Output Files. 322

Sort Keys. 322

Selection Logic. 322

A Link Example. 322

A Join Example. 323

Performance Considerations. 324

Another Example. 325

Illegal Digits. 325

Selecting Non-Matches. 326

Suprlink with Quiz/QTP. 326

Suprlink Commands  329

General Notes. 329

Abbreviating. 329

Uppercase or Lowercase. 329

Continuation. 329

Comments on Command Lines. 330

HP-UX Commands. 330

File Names. 330

Calculator. 330

Control-Y.. 330

Before Command  [B]. 332

Do Command  [DO]. 334

Exit Command  [E]. 335

Exit Abort [EA]. 335

Exit Suspend [ES]. 335

Exit Xeq [EX]. 335

Form Command  [F]. 336

Help Command  [H]. 338

Input Command  [I]. 339

Join Command  [J]. 340

Link Command  [L]. 342

Listredo Command  [LISTREDO]. 344

Output Command  [O]. 345

Redo Command  [REDO]. 346

Reset Command  [R]. 347

Set Command  [S]. 348

Mapped. 348

Redo. 348

Statistics. 349

Varsub. 349

VarsubCompat 349

VarsubDebug. 350

Use Command  [U]. 351

Verify Command  [V]. 352

Xeq Command  [X]. 353