home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.robelle3000.ai 2014
/
2014.06.ftp.robelle3000.ai.tar
/
ftp.robelle3000.ai
/
changes
/
supr4p1ix.txt
< prev
next >
Wrap
Text File
|
2002-07-29
|
41KB
|
1,058 lines
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 <<Search Field>>
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) <<Indexed>>
SUB-TITLE X40 45
ARTIST X30 85 (M-ARTIST) <<Indexed>>
SONG-NO J1 115
SONG-TITLE X40 117 (A-SONGS) <<Indexed>>
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 <<Search Field>>
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]