SUPRTOOL Version 4.0.17 Database Handyman for the HP 3000 Pre-Release Change Notice Installation Instructions Addendum to 4.0 User Manual Suprtool 4.0.17 Dbedit 4.0.17 Suprlink 4.0.17 STExport 4.0.17 Speed Demon 4.0.17 Suprtool2 4.8 Robelle Consulting Ltd. Unit 201, 15399-102A Ave. Surrey, B.C. Canada V3R 7K1 Toll-free: 1-888-ROBELLE (1-888-762-3553) Phone: (604) 582-1700 Fax: (604) 582-1799 E-mail: support@robelle.com Web: www.robelle.com February 11, 1998 Program and Manual Copyright Robelle Consulting Ltd. 1981-2002 Permission is granted to reprint this document (but not for profit), provided that copyright notice is given. QEDIT and SUPRTOOL are trademarks of Robelle Consulting Ltd. Other product and company names mentioned herein may be the trademarks of their respective owners. Introducing Suprtool Version 4.0.17 ü Highlights ü Compatibility ü CPU Serial Number ü Compatibility Mode vs. Native Mode ü Documentation ü Documentation in WinHelp Format Suprtool provides fast access to your data on the HP 3000. With Suprtool, you can perform many necessary DP functions easily, with just a few simple commands. At Robelle we are constantly working on your enhancement requests so that we may include them every year when we release an updated version of Suprtool. This change notice provides you with detailed installation steps and a description of Suprtool's new features. We would appreciate any feedback on any of the new features available in this release of Suprtool. Thanks for agreeing to give this new version of Suprtool a try. Highlights in Version 4.0.17 ü The Item command with the SRNChronos date format now checks the field size. ü A reset table command would fail with an error message unable to reset table space if more than one table was used in a previous operation. Highlights in Version 4.0.16 ü The Form command would now shows all TPI keys if the database had Superdex Level 1 installed. ü A reset table command would fail with an error message unable to reset table space if two tables were held and the Chain command referenced the second table. ü A new Set date ifyy2000error command has been added to control whether or not Suprtool considers dates with two-digit years an error if they go beyond 1999 during a relative operation. Highlights in Version 4.0.15 ü Suprtool would fail with Nested too deep error message when doing 10 activations of Suprtool. ü Numerous documentation fixes were made to the Suprtool manual. Highlights in Version 4.0.14 ü STExport was trimming the first character of some zoned fields. ü STExport was failing when an phdate date type was in an SD file and sign none was specified. ü The Duplicate command now allows an alternate sort level to be specified. ü The Table command is no longer limited to 15 MB of Table spaces. (NM only) ü CPU and Wall time have decreased for If $lookup extracts. Highlights in Version 4.0.13 ü STExport was not properly processing Zoned decimal fields with Zeroes leading. ü Suprtool will now work with Time Machine and the HP utility Setdate. ü The Form command would print Undefined TPI utility with some versions of the Omnidex XL in certain cases. ü The installation of Suprtool now requires you to mount the tape only once instead of twice. Highlights in Version 4.0.12 ü Suprtool now has a readonly mode where all commands that update a database are disabled. ü Suprtool was not processing any commands in the Suprmgr file. Highlights in Version 4.0.11 ü Suprtool now supports the Software Research Northwest Chronos date format. ü Suprtool's if command did not abort when doing a compare against a date beyond 1999 when being entered interactively. ü Suprtool's if command did not produce an error if a relative $date or $today function was specified beyond 1999. ü Suprtool now supports the new Btree features of IMAGE/SQL. ü Suprtool now supports the new Master Dataset Expansion feature of IMAGE/SQL. ü Suprtool now allows use files to be nested. ü Suprtool would intermittently fail on certain sort operations with Data Memory Protection Trap. ü Suprlink would not properly link files with a Quad integer key (I4) ü STExport did not properly set the Delimiter option when using HTML Table command in all cases. ü STExport did not always build an output file with the proper record size when the Heading Column option was used. ü Suprtool/V did not print an error message if the Select command was entered. Highlights in Version 4.0.10 ü Suprtool now uses the procinfo intrinsic instead of getprocinfo to check to see whether or not Suprlink or STExport are still alive as son processes. Compatibility Suprtool, Speed Demon, and Suprlink are compatible with Q-Delta-2, R-MIT, T-MIT, U-MIT, V-MIT, MPE XL, and MPE/iX, including MPE/iX 5.5. There are no changes that affect compatibility with Suprtool 4.0 at this time. CPU Serial Number (HPSUSAN) This program runs only on CPUs whose serial numbers have been encoded ("showvar hpsusan" on MPE/iX). If it fails to run and you get an "invalid HPSUSAN" error message, call Robelle for assistance. Compatibility Mode vs. Native Mode Throughout this change notice and in all of the Suprtool documentation, there are references to compatibility mode and native mode. If you are on a Classic HP 3000 (i.e., not MPE/iX), you can use the compatibility-mode version of Suprtool. Our job streams automatically install the correct version for your machine. We use the terms MPE XL and MPE/iX interchangeably in our documentation. Documentation This release includes updated user manuals for Suprtool and its components. To print these manuals, use the Printdoc program: :run printdoc.pub.robelle This is the list of documentation files for Suprtool. NOTE: These filenames assume that Install.Suprjnew has already been done. suprtool.doc.robelle {Suprtool user manual} stexport.doc.robelle {STExport user manual} suprlink.doc.robelle {Suprlink user manual} dbedit.doc.robelle {Dbedit user manual} demon.doc.robelle {Speed Demon user manual} suprcall.doc.robelle {Calling Suprtool user manual} suprtool.docchg.robelle {this change notice} If you know the filenames of other Robelle documents, you can print them with Printdoc or you can include the filename in the :Run command. For example, to print this change notice, type :run printdoc.pub.robelle;info="suprtool.docchg.robelle" Documentation in WinHelp Format The user manuals for Suprtool and its components are all available in the popular WinHelp file format of Microsoft Windows. Your tape includes a WinHelp file, which is a self-extracting compressed file that contains all five Help files and a Setup program. Use the installation instructions in this change notice to install the WinHelp files on your PC. Bugs Fixed in New Features Reset Table. A reset table command would fail with an error message of "Unable to reset table space" if two tables were held and the Chain command referenced the second table. [4.0.16] STExport. STExport was trimming the first character in some zoned-decimal fields. [4.0.13] Use Command. Suprtool would fail with Nested too deep error message after 10 activations of Suprtool. [4.0.15] Installation of 4.0.16 The following instructions apply to existing Suprtool users who are installing a new version. Please use the instructions from this change notice instead of the user manual because the change notice always has the latest version. The whole process should take about 30 minutes, assuming that no one uses Suprtool or its components during the installation. Follow these steps to install this update of Suprtool: 1. Restore the new files from tape. 2. Upgrade the structure of the Robelle account. 3. Install the proper program files (NM or Classic). 4. Install Speed Demon in the system SL (only Classic). 5. Install the Suprtool2 interface in the system SL (only Classic). 6. Limit Suprtool's runtime priority (optional). 7. Install WinHelp documentation files (optional). 8. Purge the installation files (optional). This Tape Will Expire All Robelle pre-release software has an expiration date, because you should be replacing your pre-release software with our official major releases. Pre-release tapes usually expire one-and-a-half years after they are made. The software will warn you when you are within sixty days of the expiry date. Installation Assistance If you have any questions or run into any problems, please call us. Technical support is available on weekdays from 7 a.m. to 4 p.m. Pacific time at 1-888-ROBELLE (1-888-762-3553). You can also receive emergency support outside of these hours by calling our regular phone number and asking the operator to page a support person for you. Important Note About Passwords None of the jobs that we supply have passwords in them. Before streaming a job, you may have to add your system's passwords to the first line. Users of MPE XL 3.0 and later do not have to do this because the operating system prompts for missing passwords. The same is true for some MPE V users who have security software that inserts passwords. Most MPE V users have to edit the jobs. For example, if the system manager logon password is Qwerty, you would do the following: :editor HP32201A.07.22 EDIT/3000 /text robelle.pub.sys FILE UNNUMBERED /modify 1 MODIFY 1 !job robelle,manager.sys,pub;hipri;jobq=SUPRTOOL i/qwerty !job robelle,manager.sys/qwerty,pub;hipri;jobq=SUPRTOOL /keep robtemp /exit END OF SUBSYSTEM :stream robtemp :purge robtemp STREAMX Users Users of STREAMX, a part of SECURITY/3000 from VESOFT Inc., must set a Job Control Word before streaming jobs. This prevents STREAMX from generating an error if the Robelle account does not yet exist. For example, :setjcw streamxtempnonest 1 :stream robelle.pub.sys Step 1: Restore the Files You begin by restoring all the files from the tape. :hello manager.sys :file rtape; dev=tape {use appropriate device} :restore *rtape; @.@.robelle; create {restore everything} The Suprtool program files are located in the Pubnew group of the Robelle account. These are the names of the various files: suprcm.pubnew suprnm.pubnew {Suprtool} linkcm.pubnew linknm.pubnew {Suprlink} stexpcm.pubnew stexpnm.pubnew {STExport} demoncm.pubnew demonnm.pubnew {Demon Program} demonusl.pubnew {SPDE USL File} demonxl.pubnew {SPDE XL File} st2usl.pubnew {ST2 USL File} st2xl.pubnew {ST2 XL File} Step 2: Set Up the Robelle Account Even if you already have the Robelle account, you must stream the Robelle job to ensure that the Robelle account and all its groups have the proper security and capabilities. :stream robelle.job.robelle When the job stream is finished, it will send you a message. The job removes the password from the Robelle account. Stay logged on as Manager.Sys and put a password on the Robelle account. If you are upgrading your Robelle account, use the old password. :altacct robelle;pass=hardpass {hard to guess} Please note that during installation we add OP capability to the Robelle account. When the Suprtool installation is finished, you have the option to remove OP capability. Step 3: Install Suprtool into Production Our installation job installs Suprtool, STExport, Suprlink, Speed Demon, and the Suprtool2 interface. No one can use these programs during the installation. Before you stream this installation job, warn people not to use these programs for a while. :hello mgr.robelle :warn @;please exit from Suprtool and Suprlink NOW! :stream install.Suprjnew Once Suprtool has been installed, check the installation job $stdlist. If anyone was either using Suprtool, STExport, Suprlink, or Speed Demon, or attempting to back them up, the installation job will fail. Chase away any users, ensure that a backup is not in progress, then stream the installation job again. The installation job renames your current versions of Suprtool and its components to the PubOld group of the Robelle account. If you need to move these versions back into production, use the Previous.Suprjnew job stream. You can now access Suprtool by entering :run suprtool.pub.robelle Optional Installation Steps On MPE/iX your installation should be complete. If you have a copy of Speed Demon or the Suprtool2 interface in your own XL files, you will have to update them with the new versions (use the instructions in the Speed Demon and Calling Suprtool user manuals). To use the new versions on MPE V, you still need to install Speed Demon and Suprtool2 in the system SL. MPE/iX users must also do this if they are calling Speed Demon or Suprtool2 from compatibility-mode programs. With so few changes to Speed Demon and Suprtool2, you can safely ignore them for this version of Suprtool. If you have a Windows PC, you can install all the Suprtool documentation on it in the popular WinHelp format of Microsoft Windows. Step 4: Speed Demon/V Installation (optional) To use the new features of Speed Demon/V, you must install the latest version in the system SL. You should follow the installation instructions in the Speed Demon user manual. These instructions assume that you have used the Install.Suprjnew job stream to move Suprtool and its components into the Pub group of the Robelle account. :stream demon.Suprjnew.robelle Step 5: Suprtool2 Interface Installation (only Classic) The Suprtool2 interface has been revised. On MPE V you must re-install the interface. If you do not have the latest Suprtool2 interface, programs that attempt to use totals from Suprtool2 will fail. You can install this interface without recompiling any of your existing programs. System SL Installation To install the latest Suprtool2 interface in the system SL, use our standard installation job: :stream suprcall.Suprjnew.robelle User SL or XL Files If you have a copy of the Suprtool2 interface in your own SL or XL, you will need to update it. For instructions on how to do this, consult the user manual for Calling Suprtool. Step 6: Limit Suprtool's Runtime Priority (optional) Some system managers like to restrict the amount of resources that Suprtool consumes. One way to do this is by running Suprtool in the D queue, which lets you use HP's Linkedit program. :linkedit >altprog suprtool;maxpri=ds >exit By forcing Suprtool to always run in the lower queue (even when Suprtool runs on-line), it competes less with on-line users because most users run in the C queue. System managers should only restrict the priority of Suprtool if they are familiar with MPE process queues and the Tune command. Step 7: Install WinHelp Documentation Files (optional) All of the Suprtool documentation is now available in the WinHelp format for Microsoft Windows. You can only use these files if you have a Windows PC. Make a Temporary Directory for the Setup Program Create a new directory for the installation files on your PC. You can remove this directory after the WinHelp files have been installed. From the DOS prompt for example, type mkdir \robtemp Download the Compressed File In the next step, download the self-extracting Zip file to your PC with Reflection. The file on the HP 3000 is called Suprhelp.Whelp.Robelle. You should be logged on as Mgr.Robelle. Press Alt-Y to go to the Reflection Command Line window. Make sure that you use the binary transfer. receive c:\robtemp\suprhelp.exe from suprhelp.whelp.robelle binary Expand the Compressed File You need only the following commands to extract the files because we provide the Setup program and the Help files in one self-extracting Zip file. From the DOS prompt, type cd \robtemp {go to the new Robtemp directory} suprhelp.exe {extract the Help files} Run the Setup Program Now you can run the Setup program. In Windows 95, select Run from the Start menu and enter c:\robtemp\setup in the Run window. Follow the instructions in the Setup program. Once the Setup program is finished, you can access all of the Suprtool documentation by selecting any of the "Robelle Help" icons. Remove the Robtemp Directory Delete all of the files in the Robtemp directory either from Explorer in Windows 95 or with the following DOS commands: cd \robtemp del *.* {delete all the files} cd .. rmdir robtemp {remove the Robtemp directory} You can also copy the files in Robtemp to a diskette and distribute them to other Suprtool users. Step 8: Purge Installation Files (optional) The easiest way to clean up after an installation is to stream the Cleanup.Purgejob.Robelle job. This job saves you disc space by purging the installation files. It does not purge the files that are necessary to run the software. Enhancements The following are enhancements made to Suprtool since the last major release. Btree Support [4.0.11] HP added a generic search and partial key retrieval feature to IMAGE/SQL by attaching Btrees to a given master dataset key item. This feature is available in versions of IMAGE/SQL C.07.03 and later. To determine the version number of IMAGE, run Query (:Run Query.Pub.Sys) and enter the Version command. :run query.pub.sys >version Similarly, you can also run Dbutil.Pub.Sys, type Help and look for the Addindex command. Btrees are allowed to be built only on the key item of a given manual or automatic master dataset. However, if the path into a given detail dataset has an attached Btree, you can implicitly take advantage of the Btree and a partial key lookup will work on the associated detail. Suprtool has been enhanced to take advantage of these Btrees via the Chain command. Suprtool also shows any Btrees that it can utilize through the Form command. Chain Command [4.0.11] The Chain command only takes advantage of these if the BtreeMode1 setting is turned on at the root level. This setting means that all DBFIND mode-1 calls will utilize the Btree. You can turn BtreeMode1 on by doing the following: :run dbutil.pub.sys >>set BtreeMode1=on The Chain command has been enhanced to allow the partial key retrieval on X and U items on the master dataset, and implicitly on any associated detail dataset. For example, >base cd.db.data,5,reader >chain a-songs,song-title="w@" >list >xeq Warning: Using DBGET for the input records >GET A-SONGS (289) >OUT $NULL (0) SONG-TITLE = we only come out at night >GET A-SONGS (56) >OUT $NULL (1) SONG-TITLE = where boys fear to tread IN=2, OUT=2. CPU-Sec=1. Wall-Sec=1. As previously mentioned, we can search a detail dataset by using the implicit Btree or the search item that has a Btree attached to the associated master. >chain d-songs,song-title="w@" >list >xeq Warning: Using DBGET for the input records >GET D-SONGS (37) >OUT $NULL (0) CD-NO = 2 CD-TITLE = Mellon Collie ARTIST = Smashing Pumpkins SONG-NO = 10 SONG-TITLE = we only come out at night >GET D-SONGS (28) >OUT $NULL (1) CD-NO = 2 CD-TITLE = Mellon Collie ARTIST = Smashing Pumpkins SONG-NO = 1 SONG-TITLE = where boys fear to tread IN=2, OUT=2. CPU-Sec=1. Wall-Sec=1. Form Command [4.0.11] The Form command has been enhanced to show whether there are Btrees that the Suprtool Chain command can utilize. Currently the Chain command utilizes only those Btrees that are type X or U. The Form command does not show Btrees that it cannot utilize, even if the Btree does exist. The Form command also reports a damaged Btree. >form sets Database: CD.DB.DATA BtreeMode1 = ON Wildcard character : @ Set Item Entry Load Entry Sets: Num Type Count Capacity Count Factor Length B/F M-ARTIST 1 M i 2 211 3 1 % 75 4 A-SONGS 2 A i 1 307 41 13 % 20 16 A-CD-TITLE 3 A i 1 211 3 1 % 20 16 D-SONGS 4 D 6 1004 41 4 % 78 4 >form m-artist Database: CD.DB.DATA BtreeMode1 = ON Wildcard character : @ M-ARTIST Master Indexed Set 1 Entry: Offset ARTIST X30 1 <> NOTES 2X60 31 Capacity: 211 (4) Entries: 3 Bytes: 150 >form d-songs Database: CD.DB.DATA BtreeMode1 = ON Wildcard character : @ D-SONGS Detail Set 4 Entry: Offset CD-NO J2 1 CD-TITLE X40 5 (!A-CD-TITLE) <> SUB-TITLE X40 45 ARTIST X30 85 (M-ARTIST) <> SONG-NO J1 115 SONG-TITLE X40 117 (A-SONGS) <> Capacity: 1004 (4) Entries: 41 Highwater: 41 Bytes: 156 Master Dataset Expansion (MDX) In a soon to be released version of IMAGE/SQL, master datasets will be able to expand while records are being put into the database. This new capability is similar to the Detail Dataset Expansion (DDX), which was made available with MPE/iX 5.0. Form Command [4.0.11] The Form Sets command indicates which datasets have MDX enabled. A Form command on these datasets shows details of their expansion setting. >form sets Database: STORE.MDX.DATA Set Item Entry Load Entry Sets: Num Type Count Capacity Count Factor Length B/F M-CUSTOMER 1 MDX 9 2009 401 20 % 55 7 M-PRODUCT 2 MDX 3 3012 0 0 % 24 12 M-SUPPLIER 3 MDX 6 2008 0 0 % 49 8 D-INVENTORY 4 D 6 462 0 0 % 15 22 D-SALES 5 D 8 6006 0 0 % 19 14 >form m-customer Database: STORE.SUPRMDX.GREEN M-CUSTOMER Master Set 1 Entry: Offset CITY X12 1 CREDIT-RATING J2 13 CUST-ACCOUNT Z8 17 <> CUST-STATUS X2 25 NAME-FIRST X10 27 NAME-LAST X16 37 STATE-CODE X2 53 STREET-ADDRESS 2X25 55 POSTAL-CODE X6 105 Capacity: 469 (7), 217, 252, 2009 Entries: 401 Highwater: 401 As you can see, the master dataset summary information for the Capacity shows the Current Capacity (469), the Blocking Factor (7), the Initial Capacity (217), the Increment (252) and finally the Maximum Capacity (2009). The Increment is the number of entries by which the master dataset increases from the current capacity. Unlike DDX, the percentage at which an expansion is triggered is not documented (nor shown) and may change between versions of IMAGE. Duplicate Command [4.0.14] The Keys Num option determines the level at which Suprtool compares sort keys. This option controls which duplicate records get included in (or excluded from) the output file. In the following example we sort by agent and by bill-date (in descending order), but only check for duplicates at the agent level. >sort agent {sort by agent} >sort bill-date,desc {sort by date } >duplicate none keys 1 {only check for duplicate agents} >output agents {create roster of agents} Item Command [4.0.11] Software packages from Software Research Northwest use a date format known as Chronos, which stores the date and time in a compressed 6-byte format. In Suprtool, you specify this format by using the Srnchronos date attribute. >item box-timestamp,date,srnchronos Once you have used the Item command to identify these dates, you can do the following: 1. Select on these dates using the $date and $today functions. For example, to select records with a timestamp before today: >if box-timestamp < $today 2. Extract these dates using $date and $today. 3. See the date attribute in the Form command. 4. Pass the date attribute to STExport by using the Link option of the Output command. 5. Format these dates into a readable value by using STExport. Item Command Abbreviations [4.0.11] If you specify the Date keyword, you can now use a leading subset for the date attribute. In previous versions of Suprtool, you had to always fully specify the date attribute. Nested Use Files [4.0.11] Suprtool now allows usefiles to be nested; in other words, one usefile can contain references to another usefile. You can nest the usefiles up to ten levels. For example, if the contents of the Usedef usefile had a reference to Useext, both usefiles would be executed: >base store.suprtool >get d-sales >use usedef define delivered,deliv_date define purchased,purch_date item delivered ,date ,yymmdd item purchased ,date ,yymmdd use useext ext cust-account ext deliv-date ext product-no ext product-price ext purch-date ext sales-qty ext sales-tax ext sales-total >xeq Care must be taken when entering Use commands with a stacked command after the usefile reference. For example, if you enter use usedef;def j,1,6,byte the Define command will not be executed until after the Usedef and any other nested Use commands are finished. Set Date Ifyy2000Error On | Off [4.0.16] By default Suprtool considers Dates with a two-digit century from the $date and $today functions to be invalid when they resolve to be greater than 1999 and the if operation is a relative operation. (ie. greater than or equal to) You can control whether or not Suprtool considers this an error or not by making the following Set command: >set Date Ifyy2000Error Off Following is an example of what is considered to be and error by the if command and how the Set command can turn off the error check: >def a,1,6 >item a,date,yymmdd >if a >= $today(+2000) ^ Error: Cannot use a date beyond 1999 for this format >set date ifyy2000error off >if a >= $date(2000/01/03) We have chosen this to be an error by default because if a date that is in yymmdd format and resolves to be 000102 from the $date function in the if command is likely to resolve to be all of the records for a given dataset. This is of course, logically incorrect and if you include a delete command in this task you can potentially remove all of your records. Set Limits ReadOnly On [4.0.12] Suprtool normally allows any user with the proper access capabilities to add, update and delete records to a database. To prevent users from accidentally updating their database, we provide the following setting within Suprtool: >set limits ReadOnly On The ReadOnly setting, once turned on, cannot be turned off for the current run of Suprtool, which disallows all commands that potentially change data for a given database. If Set Limits ReadOnly is enabled, the following commands from within Suprtool and Dbedit will not be processed and will return an error: Suprtool Delete Put Update Dbedit Add Change Delete Modify You can enable Set Limits ReadOnly from the command line by using the Info String and Parm option. For example, the following command file can be used to restrict who has write access to a given database. In this example only the Mgr user is allowed write access: IF HPUSER = "MGR" THEN Run Suprtool.pub.robelle else Run suprtool.pub.robelle;parm=8;info='set limits readonly on' endif Set Limits Tablesize num [4.0.14] Suprtool previously allowed a total of 15 megabytes for all tables. Now Suprtool allows each of the ten tables up to 2 GB. >set limits Tablesize 200 The default size of a table is 2,047 megabytes. Tables [4.0.14] The Table command is no longer limited to 15 megabytes for all ten tables, but is now limited to 2,047 megabytes per table. If $Lookup CPU and Wall time has been reduced in table $lookup functions. Our tests have shown that the CPU and Wall has been cut in half on tests with a single table of approximately 10 megabytes. The performance improvement is less for extracts with multiple tables. Your performance may vary because it is dependant on numerous factors, of which memory is the most important. Notes We have tested loading and utilizing a table five (5) times bigger than the available memory. Specifically, we have loaded a table with 630 megabytes of information on a system with 112 megabytes of memory. We do not recommend loading a table with the File option if the total size of the table is greater than 50% of the total memory on your system. We recommend that you sort the file with Suprtool before loading the table with the Table command. We are interested in getting feedback on both functional and performance data in regards to table functions in the NM version of Suprtool. Year 2000 Testing Testing software to see if it works in the year 2000 and beyond is difficult. Currently there are three software tools that change the software date for specific sessions or applications, making it easier to test software for year 2000 compliance. The three tools are: 1. Hourglass from Allegro Consultants, Inc. 2. Time Machine from SolutionSoft Systems, Inc. 3. Setdate from the HP Jazz machine on the Web. Previous versions of Suprtool would only work with Hourglass. This new version of Suprtool now works with both Time Machine and Setdate. Note that this change only applies to non-expiring versions of Suprtool. Expiring versions of Suprtool (such as trials, pre-releases, and products obtained through VARs) do not work with Time Machine or Setdate. [4.0.13] Bugs Fixed Export Command. The Export command in Suprtool now uses the procinfo intrinsic instead of the getprocinfo intrinsic in order to determine if the process is still alive. This is to workaround a problem in the getprocinfo intrinsic, which intermittently caused STExport to hang. Export Command. The following problems in STExport have been fixed: 1. STExport would not properly set the Delimiter to None on a second task when setting the HTML option to Table. [4.0.11] 2. STExport would fail if the total length of the Heading Column commands exceeded the total size of the fields. [4.0.11] 3. STExport would not handle zoned-decimal fields properly when zero was set to leading. [4.0.13] 4. STExport was failing with invalid write-length error if a phdate field was in the SD file and sign none option was specified. [4.0.14] Form Command. The Form command from within Suprtool would print Undefined TPI Utility if run with xl="xl.pub.disc" and the database did not have any Omnidex indexes configured. [4.0.13] Form Command. The Form command would not print all TPI indexes when using Superdex Level One. [4.0.16] If Command. The If command did not produce an error if a relative $date or $today function were specified beyond 1999. [4.0.10] Link Command. The Link command from within Suprtool now uses the procinfo intrinsic instead of the getprocinfo intrinsic in order to determine if the process is still alive. This is to workaround a problem in the getprocinfo intrinsic which intermittently caused Suprlink to hang. Link Command. Suprlink would not properly link files by a Quad integer key. (I4 or J4). [4.0.11] Select Command. Suprtool/V did print an error message when the Select command was entered. [4.0.11] Suprmgr File. Suprtool 4.0.11 did not process any of the commands in the Suprmgr file. [4.0.12]