Download User Manual

Notes on QSHOW Output .......................................................................................... 88 The Quiz Report ......................................................................................................... 89 Quiz: Generating Suprtool Commands ...................................................................... 90 Generating Suprtool Commands from Quick............................................................. 90 Suprtool and Application Systems............................................................................................ 91 Third-Party Indexing .................................................................................................. 91 Z-type TPI-keys.......................................................................................................... 91 Omnidex without TPI ................................................................................................. 92 OmniQuest ................................................................................................................. 93 Suprtool with TRANSACT ........................................................................................ 93 XSORT and RPG ....................................................................................................... 94 QUERY Program ....................................................................................................... 94 SRN Chronos Dates ................................................................................................... 95 Year 2000 Solutions with Suprtool........................................................................................... 95 What If I Have Four-Digit Years? .............................................................................. 95 What does Set Date Cutoff do? .................................................................................. 96 Stddate and Set Date Cutoff ....................................................................................... 96 What does Set Date ForceCentury do? ...................................................................... 96 What If I Have Two-Digit Years? .............................................................................. 96 What Is Wrong with Two-Digit Years? ..................................................................... 97 How Do $Today and $Date Work? ............................................................................ 97 Will Suprtool Generate an Error for Two-Digit Year Dates? .................................... 98 How Do I Use $Today and $Date with yymmdd Dates? ........................................... 98 aammdd Date Format ................................................................................................. 98 Invalid Dates .............................................................................................................. 99 Can Suprtool Convert Two-Digit Years to Four Digits? ........................................... 99 Case 1: Converting a J2 Date from yymmdd to ccyymmdd ..................................... 99 Case 2: X6 yymmdd Data to X8 ccyymmdd ........................................................... 101 Case 3: Different Date Formats X6 MMDDYY Data to X6 YYMMDD ............... 102 Year 2000 Testing .................................................................................................... 103 Performance Issues ................................................................................................................. 104 Native Mode and Compatibility Mode .................................................................... 104 CPU-Bound? ............................................................................................................ 104 Sort Speed ................................................................................................................ 105 Analyzing Performance Data ................................................................................... 105 Suprtool Performance Hints ..................................................................................... 106 Obtaining Accurate Measurements .......................................................................... 106 Performance Summary ............................................................................................. 107 Suprtool Functions .................................................................................................................. 107 UC4/Scripting and Functions ................................................................................................. 107 String/Byte Functions ............................................................................................................. 108 $TRIM (Works on byte type fields) ....................................................................................... 108 If Usage: ................................................................................................................... 108 Extract Usage (target: Byte type fields) ................................................................... 108 Example:................................................................................................................... 108 Data Examples Before and After: ............................................................................ 109 $LTRIM (Works on Byte type fields) .................................................................................... 109 If Usage: ................................................................................................................... 109 Extract Usage (target: Byte type fields) ................................................................... 109 Example:................................................................................................................... 109 Data Examples before and after: .............................................................................. 109 $RTRIM (Works on Byte type fields) .................................................................................... 109 If Usage: ................................................................................................................... 110 Extract Usage (target: Byte type fields) ................................................................... 110 Example:................................................................................................................... 110 Data Examples: ........................................................................................................ 110 Table of Contents
Suprtool 5.7 for MPE• 7