Suprtool Questions and Answers

What's New in Suprtool? Suprtool is constantly being improved and enhanced. Here are just 3 of the many recent new features: $Edit for COBOL-Type Formatting. Accept Free-form Numerics. Splitting Byte Fields. Our Support Page Migrating Apps About Eloquence OS Compatibility Installation Other compatibility Tips, Techniques, Topic Discussions Working with Dates Manipulating datatypes What does this mean? "What's Up, Doc?" newsletter? Licensing Policies Suprtool Training Opportunities

Operating system compatibility Upgrading to MPE/iX 7.0 Upgrading to MPE/iX 6.5 Upgrading to MPE/iX 6.0 Upgrading to MPE/iX 5.5 Installation and documentation Suprtool for MPE Installation Instructions (TAPE) Suprtool for HP-UX Installation Instructions (TAPE) Install on private volumes Do I need exclusive access to install Suprtool? Latest Suprtool MPE Change notice and installation instructions Latest Suprtool UX Change notice and installation instructions Where can I get my own copy of the Suprtool Manual? Other compatibility issues Warning regarding using Netbase and remote Jumbo Datasets Tips, Techniques, Topic Discussions Uses of Suprtool Jumping on Problems with Suprtool Suprtool Speed Stories Enabling Users with Suprtool Updating data I have a file with 2 fields. How can I lookup on the first field, and update with the second? Update From a Table (the easiest way) Method 2: Use Suprtool and Chain command. Method 3: Use Dbedit. Upshifting data in a field (Using Qedit) What detail datasets have the bad data? Clean your data Selecting data Find bad data: Exception reporting with Suprtool How do I enter an IF command longer than 256 characters? Selecting the top ten records Tables to Replace Quiz Links Reporting How do I append the record count to the output file in MPE? Create Sort-break Subtotals with Suprtool? Use Suprtool to generate random passwords Converting a comma-delimited file to fixed-column format (Using Qedit) Suprtool, CGI, and the Web Self-Describing Files (aka Link) Edit Self-Describing Files Add Recnum to SD Files Other Oracle Migration with OpenTurbo Suprtool Compared to Query Enable, Disable, or fine-tune Suprtool's progress messages? Hiding database passwords from Users Sorting Huge Datasets with Limited Disc Space Suprtool DEFINEs, some discussion .... More Suprtool Tips Working with Dates Do Range Selection on Non-collating dates How can I compare dates of different formats? How can I change my date's format to CCYYMMDD? Check a user-input date against $stddate Converting dates to ASK format Working with Century-included PHDATEs Inserting a timestamp into an output file/list Selection Based on Day of the Week Manipulating datatypes $Edit for COBOL-Type Formatting Accept Free-form Numerics Splitting Byte Fields String Functions How do I convert a numeric field to another storage type? Convert positive-signed packed and display fields to neutral-signed? Working with PowerHouse data types and files How do I control the format of Numeric fields when outputing an ASCII file? Changing Field Storage Attributes What does this mean? "New entries were added to the dataset. Suprtool may have ignored some dataset entries." "Error: The input blocksize is greater than 14336 words" "Error: Unable to reset table space. Unable to obtain FCHECK file information"