December 2001
Bob Green, President To: Users of Robelle Software Re: News of the HP e3000 and Robelle, 2001 #8 If you haven't been visiting the Robelle web site, www.robelle.com, at least once a week, here is what you have been missing. Included are many of the stories posted to the web since the last What's Up DOC newsletter in November 2001.If you are reading a PDF or text version of this newsletter, remember that the headline of every story is actually a web link to the full story or more information. If you want to follow a link to get more information, go to the web home of the current newsletter: http://www.robelle.com/library/newsletter/latest.html Table of Contents: |
In the few days since HP's surprising announcement about ending its support of the e3000 in five years, a host of companies are coming forward with announcements of their mission to light the system's windows indefinitely. Many of these companies began their business lives with the system, so there's no lack of expertise on hand -- and more than a few could go toe-to-toe with HP's experts on any day. ... Third-party support is one of the traditions for the HP 3000 market — something that customers will be able to rely upon to give them time to decide how their transition will develop.
The discussion group is at
groups.yahoo.com/group/openmpe
For more info, go to
www.techgroupmd.com/OpenMPE.htm
Date: April 3- 6, 2002
Place: Hyatt Hotel, San Jose, CA
Notes: Use source code SS02PE1 to take advantage of the Early Bird specials
(save up to $100).
* Exclusive Access to Text Files
Qedit for Windows can take advantage of the new Set Text Exclusive feature of the Qedit server.
* Cursor Shape in Overwrite Mode
When working in Overwrite mode, the cursor changes from a vertical bar to a block, making it easier to see.
* Open Option in the Directory Dialog Box
Open options on the Open Host and Directory dialog boxes all have mnemonics Alt+x
. The Force Unnumbered option is available on the Directory dialog box.
If you wish to take advantage of these features, please contact us.
For more Windows tips, visit the permanent location of these articles.
Suprtool is used on both the HP e3000 and on the HP 9000 systems to move data back and forth. Because Suprtool is used on both platforms, Alan can take advantage of Suprtool's proprietary self-describing file format to transfer the data descriptions along with the data. Alliant had tried a comprehensive data replication product to keep the IMAGE and Oracle databases synchronized, but found that it consumed too many system resources. The solution using Suprtool and FTP is extremely efficient and inexpensive.
Click the link above to read the entire case study, including sample Suprtool code.
Is there away in Suprtool to compare two dates on a dataset record and come
up with the number of days between them?
And then user Mike Berkowitz (no relation), replied:
>if $days(ship-date) - $days(order-date) > 10
Use the $days function. It converts a date to a Julian day (days since 4713
BCE). Then use subtraction of if statement
>base sales.db,5,reader {MPE, on HP-UX use >open ..} >get d-invoices {MPE, on HP-UX use >select ..} >if price * quantity < > amount >list standard title "Price * Qty not = Amount" device LP >xeq
For more data validating techniques, including what to do when you find an error, click the link above.
CSY engineer Mark Bixby, who came to the group with a reputation for porting software to the platform, announced there's no change in the Invent3K Server, the public resource HP opened up earlier this year to assist in porting and development. Bixby said in an Internet posting:
"The news regarding the future of the HP e3000 does not change the status of the Invent3K public access machine. We are still accepting registrations for access at http://jazz.external.hp.com/pads/. Attention ISVs -- if you would like to use Invent3K to showcase demo versions of your migration tools, please register at the above URL. "
* Exclusive Access to Text Files
Set Text Exclusive provides better control over text files. When enabled, the original text file is protected from concurrent Qedit access and other applications.
* Enhanced Support for UDC Options
Support for the Recursion and List UDC options has been improved. Both statements can be used anywhere within a UDC.
* Found String Marker
The Find and FindUp commands display a marker pointing to the string starting location.
If you wish to take advantage of these features, please contact us.
PHP is an open-source, server-side, cross-platform scripting language that is used to generate dynamic Web pages or to build browser-based applications. The PHP script can be embedded in the HTML page to generate HTML code that is inserted in the Web page at that point, or the PHP script can generate the entire HTML output. One of PHP's strengths is easy database integration. Another is that it runs on many platforms, including Windows, LINUX and HP-UX, and even on MPE/iX: a Web page at invent3k.external.hp.com/~MGR.FETHERS describes an in-progress port by Campbell Fethers and Troy Jendra, including a TurboIMAGE database interface.
Robelle Solutions Technology Inc. provides the What's Up, DOCumentation? newsletter as a service to our customers. The newsletter is available on the web: in HTML format for browsing and PDF format for printing. Visit www.robelle.com/library/newsletter/
Comments about this issue, as well as ideas for future issues, including news, tips, and suggestions for articles, can be sent to bgreen@robelle.com.
* Robelle Tech: Learn About XML and Suprtool
The Robelle Tech columns in the October issue of The 3000 NewsWire provide an introduction to XML, with example applications and links to voluminous web training material, and they announce a new feature in Suprtool: exporting to XML format.
* Credit Unions: Robelle's Summit/Spectrum Web Page
Robelle has created a new corner of its web site dedicated to users of SPECTRUM, the industry-leading application solution for credit unions from Summit Information Systems.
Hear from Summit/Suprtool users, read a case study, configure Suprtool for Spectrum, and see examples of two Spectrum jobs converted to use Suprtool. If you are a Summit/Suprtool user, send us your experiences, your converted job streams, your spreadsheet exports, or even your Suprtool enhancement requests to benefit Summit users. Spectrum is a trademark of Summit Information Systems.
* Qedit Favorites Organize Project Files
This article by Neil Armstrong describes the new "Favorites" feature in Qedit for Windows. Neil has found it very useful to organize by project the many disparate number and types of files that he edits, even files on different servers and his local PC.
* Robelle-l : A Discussion on Deleting Duplicates
Robelle-l is a quiet little discussion group where people can post questions about Qedit and Suprtool, and receive answers from other users and the Robelle staff. Recently, there was an interesting discussion on recovering from an error that inadvertently created duplicate records in a detail dataset. Read all about it.
* Some useful and interesting web links:
Labmice.net: win2k resources for IT people
DBTune/SQL: Free Utility
3000-L Mailing List: Suprtool and Powerhouse Data Types
Interview with Alfredo Rego of Adager
The world's largest customer-service solution provider (CSSP)
HP e3000 Case Study: License Mgmt Solution (PDF)
These are just some of the informative articles in this issue. Read the complete issue to learn more!
Browse the HTML issues at
http://www.robelle.com/library/newsletter/w2001-07.html
Download the PDF issues at
http://www.robelle.com/library/newsletter/w2001-07.pdf