User Manual

Doc-To-Help Standard Manual

 

 

 

 

 

 

 

 


 

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

 

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

 

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

 

 

 

 

 

 

 

I

 

Robelle Solutions Technology Inc.

#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.2 for HP-UX: 1

User Manual 1

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

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

Phone:              604.501.2001  2

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.2  19

Highlights in HP-UX version 5.2. 19

Highlights in HP-UX version 5.1.02. 19

Highlights in AMXW version 5.2. 20

Highlights in AMXW version 5.1.02. 20

Installing Suprtool 23

Overview.. 23

Who Needs To Use These Instructions. 23

Instructions for HP-UX.. 23

Instructions for AMXW... 23

Suprtool Roadmap for HP-UX   24

Road Map to Suprtool on HP-UX.. 24

Suprtool for HP-UX.. 24

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

Suprtool for AMXW... 24

Quick Start Guide for Suprtool 25

How to Run Suprtool 25

What is a Task?. 25

Copying Files. 26

Copying One File. 26

Appending to a File. 26

Fields in Data Files. 26

What is a Self-Describing File?. 26

Creating an SD File. 26

Define Fields in a Data File. 26

Create an SD File from a Data File. 27

Repeating Commands. 27

Repeating a Command. 27

Selecting Database Records. 28

Select All Records. 28

Look at the First Few Records. 28

Selecting by Criteria. 29

Simple Criteria. 29

Complex Criteria. 29

String of Digits. 29

Selecting by Date. 29

Select by Today's Date. 30

Select by Particular Date. 30

Select by Year 30

Select Prior Month. 30

Selecting by Lists of Values. 31

Finding Data Based on a List 31

Finding Data Based on a File. 31

Finding Data Based on Another Table’s Criteria. 32

Finding Data in a Data File. 32

Sorting Database Records. 32

Sort Records. 32

Sort Records in Descending Order 33

Sort by Multiple Keys. 33

Duplicate Records. 33

Report without Duplicate Records. 33

Report Only the Duplicate Records. 34

Report Only the Unique Records. 34

Report Only the Duplicates and Their Originals. 35

Deleting Duplicate Data File Records. 35

Decimal Places. 36

Converting Numbers. 36

Counts and Subtotals. 37

Count and Subtotal on Sort Keys. 37

Sort by Count or Subtotal 37

Total by Field. 38

Running Totals. 38

Running SubTotals. 38

Listing Records. 39

Changing the Output Record Format 39

Producing a Condensed Table Listing. 40

Simple Reports. 40

Your First Report 40

Column Headings. 41

Printing Mailing Labels. 41

Running Suprtool under HP-UX   43

Running Suprtool 43

Configuring Different Shells. 43

Bourne and Korn Shells. 43

C Shell 43

Setting Up a PATH for Suprtool 44

Bourne and Korn Shells. 44

C Shell 44

Dynamic Loading. 45

Control Characters and stty. 46

Suprmgr Configuration Files. 46

On-Line vs. Batch Access. 47

Command Line Options. 47

Initial Command Line:  -ccmdstring. 47

Default Outcount File Name:  -oc. 47

Exit with Verify:  -v. 48

Combining -c and -v. 48

Loader Warnings. 48

HP-UX Notes. 48

Shell Commands. 48

Hardcoded File Names and ROBELLE Variable. 49

ROBELLE Variable. 49

opt/robelle/suprmgr 49

opt/robelle/help/suprtool 49

Outcount File. 49

Differences Between MPE and HP-UX.. 50

Record Length. 50

Line Feeds. 50

Duplicate Output Files. 50

Classic Reals. 50

Input from Stdlist 51

Missing Features. 51

Suprtool and AMXW    53

What is AMXW... 53

What is Suprtool for AMXW... 53

Running Suprtool 53

Symbolic Links and running Supramxw.. 53

Suprtool/AMXW... 54

Form Command. 54

Numrecs Command. 54

Output Command. 54

Temporary Files. 55

Appending Records. 55

Table operations. 55

Variable Substitution. 55

Set Commands. 55

Command Details for AMXW    56

AMXW... 56

Numrecs Command  [N] 57

Set Commands. 58

AMXW Externalsd. 58

AMXW PerfWrite. 58

Filecode. 58

Squeeze. 59

Suprtool Issues and Solutions  60

A Suprtool Task. 60

Input Choices. 60

Processing Selections. 60

Output Choices. 60

Large File Support 61

Suprtool and Allbase. 61

Data-Types. 61

Date and Time Types. 62

Restrictions. 62

Suprtool and Oracle. 62

Data-Types. 62

Number Data-Type. 63

Order By vs. Sort 63

Restrictions. 63

SDUnix Utility. 64

Installation. 64

SDUnix Parameters. 65

LF vs. NOLF. 65

Examples. 65

Link vs. Query. 66

Suprtool and Self-Describing Files. 66

Create an SD File from a Table. 66

Create an SD File from a Data File. 66

SD Files as Input 67

Listing SD Files. 67

Decimal Places and Date Formats. 67

Extended Field Names. 67

Restrictions of SD Files. 68

Suprtool and Sorting Files. 68

Suprtool and Personal Computers. 68

Downloading to the PC.. 68

Decimal Places. 68

Spreadsheets. 69

Suprtool and PowerHouse Applications. 69

Suprtool with Quiz/QTP. 69

Step 1: Create a Subfile with Quiz. 69

Step 2: Output Erase in Suprtool 70

Step 3: Report with Quiz. 70

Using QTP to Create Subfiles. 70

Creating Subfile with Script File. 70

Quiz: Generating Suprtool Commands. 71

Year 2000 Solutions with Suprtool 71

What If I Have Four-Digit Years?. 71

What does Set Date Cutoff do?. 72

Stddate and Set Date Cutoff. 72

What does Set Date ForceCentury do?. 72

What If I Have Two-Digit Years?. 73

What Is Wrong with Two-Digit Years?. 73

How Do $Today and $Date Work?. 74

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

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

aammdd Date Format 75

Invalid Dates. 75

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

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

Case 2:  X6 yymmdd Data to X8 ccyymmdd. 77

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

Year 2000 Testing. 80

Performance Issues. 80

Eloquence Performance. 81

Sort Performance. 81

Oracle Performance. 81

Analyzing Performance Data. 82

Variable Substitution. 82

Suprtool Commands  83

General Notes. 83

Abbreviating. 83

Uppercase or Lowercase. 83

Multiple Commands per Line. 83

Continuation. 84

Comments on Command Lines. 84

HP-UX Commands. 84

Calculator 85

Control-Y Interrupt 85

Add Command  [Add] 86

Examples. 86

Base Command  [BA] 87

Before Command  [C] 89

Chain Command  [C] 91

Clean Command  [CL] 93

Removing Bad Characters. 93

Define Command  [D] 95

Delete Command  [DEL] 100

Do Command  [DO] 102

Duplicate Command  [DU] 103

Edit Command  [ED] 108

Exit Command  [E] 109

Export Command  [EXP] 111

Extract Command  [EXT] 112

Constants. 112

Dates. 114

Range of Fields. 116

Numeric Expressions. 117

$SubTotal Function. 119

$Total Function. 119

$Counter Function. 119

String Expressions. 120

Splitting Variable Length Strings. 121

Cleaning your Data. 122

Un-printables. 123

Clean Command Syntax. 123

Setting the Clean Character 123

Cleaning a Field. 123

Cleaning your data. 124

Extract from a Table. 124

Data Conversion. 125

$Number Function. 126

Numeric to Byte Conversion. 127

$Edit Function. 128

Placeholders and Format Characters. 128

Byte-Type Formatting. 128

Z-placeholder for byte-fields. 129

Overflow and limits. 129

Numeric field edit-masks. 130

Signs. 130

Decimal Places. 131

Data and Edit mask: 131

Currency and Dollar signs. 131

Overflow and floating dollar 132

Set CurrencySymbol 132

Overflow and limits. 132

Restrictions. 132

Form Command  [F] 135

Get Command  [G] 138

Help Command  [H] 140

If Command  [IF] 141

Expressions. 141

Constants. 144

Subscripts. 145

Numeric Expressions. 146

String Expressions. 148

Date Selection. 151

Long Expressions. 156

Input Command  [I] 159

Item Command  [IT] 161

Date Formats. 161

Decimal Places. 164

Notes. 165

Key Command  [K] 167

Link Command  [LIN] 169

List Command  [L] 170

Format 170

LaserJet Listings. 171

Headings in Listings. 172

Simple Reports. 173

List Device. 174

List File. 174

Listredo Command  [LISTREDO] 177

Numrecs Command  [N] 178

Open Command  [OP] 179

Remote Databases and Oracle Issues. 179

Output Command  [O] 180

Put Command  [P] 185

Q Command  [Q] 186

Redo Command  [REDO] 187

Reset Command  [R] 190

Select Command  [SEL] 191

Set Command  [S] 192

Allbase. 194

Arithmetic. 194

Baseclose. 194

Blocksize. 194

Buffer 194

CleanChar 195

CurrencySymbol 195

Date Cutoff. 195

Date ForceCentury. 196

Date IfYY2000Error 196

Date MapToPHDate8. 197

DecimalSymbol 197

Defer 198

DumpOnError 198

EditStopError 198

Eofread. 198

FastRead. 198

Filecode. 199

Filename. 199

Firstrec. 199

Hints. 199

HPUXCmdErr “<string>”. 199

Ifcheck. 200

Ignore. 200

InitExtents. 200

ItemAbbreviateDate. 200

ItemLock. 201

Interactive. 201

LabelledTapeRewind. 201

Limits. 202

List 202

List Date. 202

List PCL.. 203

List Time. 204

List FormFeed. 204

Lock. 205

MakeAbsent 205

NLS. 205

NumBug. 205

Openmode. 206

Oracle Rows. 206

Oracle Integer 206

Oracle OpenFix. 207

Oracle PassShift 207

Oracle ZeroNull 207

Pattern. 207

Prefetch. 208

Privmode. 208

Progress. 208

Prompt 209

RealMap. 209

Recover 209

Redo. 209

SDExtname. 210

Sortfast 211

Squeeze. 211

Statistics. 211

Subsystem... 211

Suspend. 211

ThousandSymbol 211

Userlabels. 211

Varsub. 211

VarsubCompat 212

VarsubDebug. 212

Warnings. 212

Sort Command  [SO] 213

Table Command [TA] 215

Adding Individual Values to a Table. 215

Adding Values from a File. 216

Total Command [T] 219

Update Command  [UP] 221

Use Command  [U] 222

Userpause Command  [USER] 224

Verify Command  [V] 225

Xeq Command  [X] 226

Calculator Command [=] 227

Suprtool Errors and Warnings  230

Two Types Of Messages. 230

Errors. 230

Warnings. 231

Welcome to STExport 232

Welcome to STExport 232

Installing STExport 232

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] 302

Delete Command  [D] 303

Do Command  [DO] 304

Exit Command  [E] 305

File Command  [F] 306

Form Command  [FO] 307

Help Command  [H] 308

List Command  [L] 309

Listredo Command  [LISTREDO] 310

Modify Command  [M] 311

Q Command  [Q] 312

Redo Command  [REDO] 313

Set Command  [S] 314

LP. 314

Prompt 314

Quiet 314

Reset 314

Underline. 315

Verify. 315

Use Command  [U] 316

Verify Command  [V] 317

Welcome to Suprlink  318

Welcome to Suprlink. 318

Terminology and HP-UX.. 318

Notation. 318

Installing Suprlink. 319

Hardcoded File Names and ROBELLE Variable. 319

ROBELLE Variable. 319

Accessing Suprlink  321

How To Run Suprlink. 321

How to Xeq a Suprlink Task. 321

Suprtool Link Command. 321

Exit with Verify. 321

Using Suprlink in Batch. 322

Command Line Options. 322

Default Outcount File Name:  -oc. 322

Variable Substitution -v. 322

Introduction to Suprlink  323

How Report Programs Work. 323

Input Files. 323

Link Files. 323

Output Files. 324

Sort Keys. 324

Selection Logic. 324

A Link Example. 324

A Join Example. 325

Performance Considerations. 326

Another Example. 327

Illegal Digits. 327

Selecting Non-Matches. 328

Suprlink with Quiz/QTP. 328

Suprlink Commands  331

General Notes. 331

Abbreviating. 331

Uppercase or Lowercase. 331

Continuation. 331

Comments on Command Lines. 332

HP-UX Commands. 332

File Names. 332

Calculator 332

Control-Y.. 332

Before Command  [B] 334

Do Command  [DO] 336

Exit Command  [E] 337

Exit Abort [EA] 337

Exit Suspend [ES] 337

Exit Xeq [EX] 337

Form Command  [F] 338

Help Command  [H] 340

Input Command  [I] 341

Join Command  [J] 342

Link Command  [L] 344

Listredo Command  [LISTREDO] 346

Output Command  [O] 347

Redo Command  [REDO] 348

Reset Command  [R] 349

Set Command  [S] 350

Mapped. 350

Redo. 350

Statistics. 351

Varsub. 351

VarsubCompat 351

VarsubDebug. 352

Use Command  [U] 353

Verify Command  [V] 354

Xeq Command  [X] 355

Example Suprlink Output 357

Example. 357

Limits Within Suprlink  359

Maximums