Clients who need training for three or more Suprtool users will likely
want to have one of our certified trainers visit their site to
conduct the training:
- Paul Edwards has over 22 years of
HP 3000 system management and
applications development consulting experience.
Please contact Paul Edwards & Associates
for his pricing and availability.
phone: (972) 242-6660
e-mail: pedwards@gte.net
web: www.peassoc.com
Testimonial: "It is really a great help to have Suprtool on all the machines I interface
with again! I have also been able to convert most of the staff to using
Suprtool as a tool of first choice over Query or a custom program. Getting
Paul Edwards here to train them was a great method to accomplish that."
Alan Wyman, Programming Manager
Alliant Foodservice
- Jeff Kubler specializes in performance consulting and
capacity planning for HP 3000 and HP 9000 sites.
Please contact Kubler Consulting
for his pricing and availability.
phone: (541) 745-7457
e-mail: jeff@kublerconsulting.com
web: www.kublerconsulting.com
Testimonial: I recently attended a Suprtool class
and I would
recommend it highly. The instructor was Jeffrey Kubler of Kubler
Consulting, and he did a great job in presenting the material.
-Dean McBee, Fandom, Inc. (DeanMcBee@aol.com)
The two-day Suprtool for MPE and HP-UX class is divided into
10 Basic modules and five optional modules, each
module covering a specific topic.
The Suprtool Course
- Introduction to Suprtool
- Components of Suprtool
- Using Suprtool for the first time
- What is a task?
- Getting help
- Working with Databases
- Reading records from datasets
- Reading serially vs. chained, which one to use?
- Selecting records - selection criteria
- Selecting fields
- Suprtool and third-party indexing tools
- Suprtool speed vs. IMAGE intrinsics
- Eloquence issues
- Commands for Eloquence
- Base Command
- Put Command
- Working with DISC Files
- Reading non-IMAGE files
- Selecting records
- Creating files
- Copying files
- Working with KSAM files
- Tape files
- Selecting Records
- Choosing records
- Comparing fields
- Date selection
- Selecting by generic relative-to-today dates
- Complex selection criteria
- Selecting by pattern matching and wildcards
- File-driven selections
- Using "tables" of selection criteria
- Suprlink: Linking Data From Multiple Sources
- Accessing Suprlink
- Self-describing files
- Link masters and details
- Linking on non-key values
- Optional vs. required links
- Exporting Data to the World
- Exporting from MPE systems to PC systems
- Creating files with comma-separated values (CSV)
- Record reformatting options
- Transferring files to the PC
- Preparing data onto Web pages
- Extract Command
- Using the Extract command
- Coercion
- $-functions
- Extract from a Table
- New Features
- Latest and Greatest Features
- Programming with Suprtool2
- Calling Suprtool from a COBOL or other 3GL program
- Invoking Suprtool for an end-user
- Prompting users for selection criteria
Optional Modules
- Editing TurboIMAGE Datasets
- Using Dbedit to alter data interactively
- Accessing Dbedit
- Finding entries with a known key
- Modifying records one-by-one and globally
- Inserting and deleting data
- Working with Speed Demon
- Calling Speed Demon from a COBOL or other 3GL program
- Reading records 5-10 times faster than DBGET
- Speed Demon vs DBGET
- Speed Demon vs Suprtool
- The Speed Demon Intrinsics
- Suprtool and PowerHouse
- Use Quiz for Reporting, Suprtool for fast reading
- Passing Suprtool data to Quiz
- Creating a subfile using Quiz or QTP
- Filling a subfile using Suprtool
- Reporting on the subfile using Quiz
- Suprlink link vs. Quiz link
- Subfiles for multiple datasets
- Debugging tips
- How Messy Is My Database?
- (This module is for TurboIMAGE 'experts')
- Using the HowMessy IMAGE database analyzer
- Interpreting performance statistics
- Efficient vs. inefficient pointers
- Database design tips
New! Introduction to Image
- Image - A Users Guide
- IMAGE Database Overview
- Record Retrieval
- Item formats
- Recent enhancements
- Tools and Utilities
You can download the student workbook in both Power Point and Adobe PDF formats:
You can download the complete course, or just the
Modules that interest you.
The workbook was prepared using Microsoft PowerPoint for
Windows and each individual module is available in PPT. We also
supply the individual modules in pdf as well as the complete course
in Acrobat PDF format. If you do not have the acrobat
viewer, you can download it at the
Adobe Website
Please send questions or suggestions regarding the workbooks to:
| 
