Suprtool 5.5 for HP-UX:

Doc-To-Help Standard Manual

by Robelle Solutions Technology Inc.

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

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

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

Robelle 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.5 for HP-UX: 1

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

Suprtool Version 5.5 19

Highlights in HP-UX version 5.5. 19

Highlights in HP-UX version 5.4.01. 19

Highlights in HP-UX version 5.4. 19

Highlights in HP-UX version 5.3. 19

Highlights in AMXW version 5.3. 20

Installing Suprtool 22

Who Needs To Use These Instructions. 22

Instructions for HP-UX.. 22

Instructions for AMXW... 22

Suprtool Roadmap for HP-UX 23

Road Map to Suprtool on HP-UX.. 23

Suprtool for HP-UX.. 23

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

Suprtool for AMXW... 23

Quick Start Guide for Suprtool 24

How to Run Suprtool 24

What is a Task?. 24

Copying Files. 25

Copying One File. 25

Appending to a File. 25

Fields in Data Files. 25

What is a Self-Describing File?. 25

Creating an SD File. 25

Define Fields in a Data File. 25

Create an SD File from a Data File. 26

Repeating Commands. 26

Repeating a Command. 26

Selecting Database Records. 27

Select All Records. 27

Look at the First Few Records. 27

Selecting by Criteria. 28

Simple Criteria. 28

Complex Criteria. 28

String of Digits. 28

Selecting by Date. 28

Select by Today's Date. 29

Select by Particular Date. 29

Select by Year. 29

Select Prior Month. 29

Selecting by Lists of Values. 30

Finding Data Based on a List 30

Finding Data Based on a File. 30

Finding Data Based on Another Table’s Criteria. 31

Finding Data in a Data File. 31

Sorting Database Records. 31

Sort Records. 31

Sort Records in Descending Order. 32

Sort by Multiple Keys. 32

Duplicate Records. 32

Report without Duplicate Records. 32

Report Only the Duplicate Records. 33

Report Only the Unique Records. 33

Report Only the Duplicates and Their Originals. 34

Deleting Duplicate Data File Records. 34

Decimal Places. 35

Converting Numbers. 35

Counts and Subtotals. 36

Count and Subtotal on Sort Keys. 36

Sort by Count or Subtotal 36

Total by Field. 37

Running Totals. 37

Running SubTotals. 37

Listing Records. 38

Changing the Output Record Format 38

Producing a Condensed Table Listing. 39

Simple Reports. 39

Your First Report 39

Column Headings. 40

Printing Mailing Labels. 40

Running Suprtool under HP-UX 43

Running Suprtool 43

Configuring Different Shells. 43

Bourne and Korn Shells. 43

Setting Up a PATH for Suprtool 44

Bourne and Korn Shells. 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

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

Numrecs Command [N]. 57

Set Commands. 58

AMXW Externalsd. 58

AMXW PerfWrite. 58

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

Date and Time Types. 62

Restrictions. 62

Suprtool and Oracle. 62

Number Data-Type. 63

Order By vs. Sort 63

Restrictions. 63

SDUnix Utility. 64

Installation. 64

SDUnix Parameters. 65

LF vs. NOLF. 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. 69

Spreadsheets. 69

Suprtool and PowerHouse Applications. 69

Suprtool with Quiz/QTP. 69

Step 1: Create a Subfile with Quiz. 70

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. 79

Performance Issues. 80

Eloquence Performance. 80

Sort Performance. 80

Oracle Performance. 80

Analyzing Performance Data. 81

Variable Substitution. 81

Suprtool Commands 82

General Notes. 82

Abbreviating. 82

Uppercase or Lowercase. 82

Multiple Commands per Line. 83

Continuation. 83

Comments on Command Lines. 84

HP-UX Commands. 84

Control-Y Interrupt 84

Add Command [Add]. 85

Base Command [BA]. 87

Before Command [B]. 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

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. 130

Overflow and limits. 130

Numeric field edit-masks. 130

Decimal Places. 131

Data and Edit mask: 131

Currency and Dollar signs. 132

Overflow and floating dollar. 132

Set CurrencySymbol 132

Overflow and limits. 133

Restrictions. 133

Form Command [F]. 135

Get Command [G]. 138

Help Command [H]. 140

If Command [IF]. 141

Expressions. 141

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

Key Command [K]. 167

Link Command [LIN]. 169

List Command [L]. 170

LaserJet Listings. 171

Headings in Listings. 172

Simple Reports. 173

List Device. 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]. 186

Q Command [Q]. 187

Redo Command [REDO]. 188

Reset Command [R]. 191

Select Command [SEL]. 192

Set Command [S]. 194

Arithmetic. 196

CurrencySymbol 197

Date Cutoff. 197

Date ForceCentury. 198

Date IfYY2000Error. 198

Date MapToPHDate8. 199

DecimalSymbol 199

DumpOnError. 200

EditStopError. 200

HPUXCmdErr “<string>”. 201

InitExtents. 202

ItemAbbreviateDate. 202

Interactive. 203

LabelledTapeRewind. 203

Table Size. 204

List FormFeed. 206

Oracle DataBug. 208

Oracle Rows. 208

Oracle Integer. 208

Oracle OpenFix. 209

Oracle PassShift 209

Oracle SpaceNull 209

Oracle ZeroNull 210

Statistics. 213

Subsystem.. 213

ThousandSymbol 214

Userlabels. 214

VarsubCompat 214

VarsubDebug. 214

Sort Command [SO]. 216

Table Command [TA]. 218

Adding Individual Values to a Table. 218

Adding Values from a File. 219

Total Command [T]. 222

Update Command [UP]. 224

Use Command [U]. 225

Userpause Command [USER]. 227

Verify Command [V]. 228

Xeq Command [X]. 229

Calculator Command [=]. 230

Suprtool Errors and Warnings 233

Two Types Of Messages. 233

Welcome to STExport 235

Welcome to STExport 235

Installing STExport 235

Accessing STExport 237

How To Run STExport 237

How to Xeq an STExport Task. 237

Hardcoded File Names and ROBELLE Variable. 237

ROBELLE Variable. 237

Using STExport in Batch. 238

Command Line Options. 238

Default Outcount File Name: -oc. 238

Variable Substitution -v. 238

Introduction to STExport 239

Importing Data. 239

Input File. 239

Data-Types. 239

Formatting Commands. 240

Performance Considerations. 240

STExport Commands 241

General Notes. 241

Abbreviating. 241

Uppercase or Lowercase. 241

Comments on Command Lines. 241

HP-UX Commands. 241

File Names. 242

Calculator. 242

Control-Y.. 242

Before Command [B]. 243

Clean Command [CL]. 245

Removing Bad Characters. 245

Columns Command [C]. 246

Date Command [DA]. 247

Decimal Command [DEC]. 249

Delimiter Command [DE]. 250

Do Command [DO]. 251

Escape Command [ES]. 252

Exit Command [E]. 253

Exit Abort [EA]. 253

Exit Suspend [ES]. 253

Exit Xeq [EX]. 253

Floating Command [FL]. 255

Form Command [F]. 256

Heading Command [HEA]. 257

Help Command [H]. 259

HTML Command [HT]. 260

Dynamic Web Pages. 262

Web Server. 262

Shell Script 263

Perl Script 265

Input Command [I]. 268

Listredo Command [LISTREDO]. 269

Output Command [O]. 270

Quote Command [Q]. 271

Redo Command [REDO]. 272

Reset Command [R]. 273

Set Command [S]. 274

Statistics. 275

VarsubCompat 276

VarsubDebug. 276

Xmltagchar. 277

Sign Command [SI]. 278

Spaces Command [SP]. 279

Use Command [U]. 280

Verify Command [V]. 281

Xeq Command [X]. 282

XML Command [XML]. 283

Zero Command [Z]. 286

Example of STExport Output 287

Limits Within STExport 291

Welcome to Dbedit 292

Introduction. 292

Restrictions. 292

Functions of Dbedit 292

Performance of Dbedit 293

Field Lists. 293

Database Locking. 294

Decimal Points. 294

Critical-Item Update. 295

Dbedit Commands 296

General Notes. 296

Abbreviating. 296

Uppercase or Lowercase. 296

Continuation. 296

Control-Y.. 297

Comments on Command Lines. 297

OS Commands. 297

Calculator. 297

Example Database. 298

Prompting for Search Criteria. 298

Command Parameters. 298

File Parameter. 298

Option Parameter. 299

Numeric-Value Option. 299

All Option. 299

Key Option. 300

Limit Option. 300

Related Option. 300

Under Option. 301

Updatekey Option. 301

Subcommands. 301

Add Command [A]. 303

Before Command [B]. 304

Change Command [C]. 305

Delete Command [D]. 306

Do Command [DO]. 307

Exit Command [E]. 308

File Command [F]. 309

Form Command [FO]. 310

Help Command [H]. 311

List Command [L]. 312

Listredo Command [LISTREDO]. 313

Modify Command [M]. 314

Q Command [Q]. 315

Redo Command [REDO]. 316

Set Command [S]. 317

Use Command [U]. 319

Verify Command [V]. 320

Welcome to Suprlink 321

Welcome to Suprlink. 321

Terminology and HP-UX.. 321

Installing Suprlink. 322

Hardcoded File Names and ROBELLE Variable. 322

ROBELLE Variable. 322

Accessing Suprlink 323

How To Run Suprlink. 323

How to Xeq a Suprlink Task. 323

Suprtool Link Command. 323

Exit with Verify. 323

Using Suprlink in Batch. 324

Command Line Options. 324

Default Outcount File Name: -oc. 324

Variable Substitution -v. 324

Introduction to Suprlink 325

How Report Programs Work. 325

Input Files. 325

Link Files. 325

Output Files. 326

Selection Logic. 326

A Link Example. 326

A Join Example. 327

Performance Considerations. 328

Another Example. 329

Illegal Digits. 329

Selecting Non-Matches. 330

Suprlink with Quiz/QTP. 330

Suprlink Commands 333

General Notes. 333

Abbreviating. 333

Uppercase or Lowercase. 333

Continuation. 333

Comments on Command Lines. 334

HP-UX Commands. 334

File Names. 334

Calculator. 334

Control-Y.. 334

Before Command [B]. 336

Do Command [DO]. 338

Exit Command [E]. 339

Exit Abort [EA]. 339

Exit Suspend [ES]. 339

Exit Xeq [EX]. 339