Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

QM 2.8-9 released Options

QM release 2.8-9 is now available for download from the OpenQM web site.

Conference Schedule

Phoenix 2019 - April 8th-11th
More Info



Release Date: Monday, March 2, 2009

QM release 2.8-9 is now available for download from the OpenQM web site.

The main contents of this release are summarised below.


Alternate key indices may now be defined as being case insensitive when they are created using CREATE.INDEX or MAKE.INDEX. The internal sorting of a case insensitive index is based on an uppercase version of the data but operations such as SELECTINDEX will find data regardless of casing. Note that because indices are stored in sorted order, a case sensitive index cannot be used in a query that uses case insensitive comparisons or vice versa.

The column widths of the FSTAT command have been increased to allow for the high performance of MFT drives.

The options to the LIST.FILES command have been modified such that the default action is to show the statistical counts and the pathnames of open files. The BRIEF option suppresses the pathname display. The DETAIL option extends the report to show the user numbers and user names of the users with each file open. A file name can also be provided to show only users with that file open. The USER option can be used to show only files open to a specific user.

When a print unit is directed to a file, a check is made to see if there is a catalogued subroutine named HOLD.FILE.LOGGER and, if there is, this is called when the file is opened and again when it is closed. This subroutine can be used, for example, to build a log of hold file entries or to take some action after the file has been closed.

The QUERY.MERGE.PRINT mode of the OPTION command causes a query report directed to a printer to merge the output as a continuation of the active print job if the printer is already active, leaving the printer active on completion of the report. Without this option, the printer is closed at the end of the report.

The REBUILD.ALL.INDICES command rebuilds the alternate key indices of all files referenced by F-type VOC pointers in the account from which it is executed. This may be of use following a system power failure where some data may not have been written to disk, ensuring that the indices correctly reflect the data stored in the files.

The SETPTR command now has an EJECT option to force insertion of a form feed at the end of the job.

The query processor now supports Pick style explosion limiters on BY.EXP and BY.EXP.DSND if the QUALIFIED.DISPLAY mode of the OPTION command is enabled.

The STACKLIST option of the QMBasic EXECUTE statement causes QM to save the current state of the default select list (list 0) prior to executing the command and then restore it on return to the program. This allows the executed command to use the default select list internally.

Key value 1021 (FL$WHO) to the QMBasic FILEINFO() function returns a field mark delimited list of the QM user numbers of user that have the file open.

The QMBasic MD5() function encodes a string to its MD5 message digest value.

The QMBasic OPEN and OPENPATH statements now support a NON.TRANSACTIONAL option to indicate that updates to the file are not to be treated as part of any transaction in which they occur.

The QMBasic SYSTEM() function has been extended to add key value 1036 to return the delay period for a login that had to wait for a spare user to become available when using the LGNWAIT configuration parameter. Applications can use this data to perform statistical analysis for determining whether a larger licence is required.

Key value 1037 of the QMBasic SYSTEM() function returns a list of all QM files open in the system and the user numbers of the users with them open.

The full screen mode of the QMBasic debugger has been extended to add the /* command to view all variables in the program.

The PDA version of QM now supports limited capabilities for incoming telnet connections.

The terminfo database now supports the stylus and pdakeys capabilities for the PDA version of QM.



# # #          # # #          # # #


About Ladybridge Systems Ltd

Ladybridge Systems was founded in 1992 by former Prime Computer personnel and is headquartered in Hardingstone, Northampton, England. The primary activity of the company is the OpenQM multivalue database for which Zumasys were appointed as worldwide sales and marketing partner in January 2015. Ladybridge Systems also provide training, consultancy, development, and maintenance services to MultiValue databases in the UK and worldwide. Ladybridge Systems remains a small privately owned company, offering a personal level of service to clients around the world.

For more information, visit http:/​/​www.ladybridge.com

About OpenQM

Effective 1/1/15 Zumasys is the Worldwide Distributor for OpenQM. Users with licenses issued prior to 1/1/15 should visit the Ladybridge website.

OpenQM is a high-performance, self-tuning database with an extremely efficient footprint. At less than half the price of comparable databases, OpenQM comes bundled with AccuTerm and provides incredible value for MultiValue resellers and end users alike. Auto-sizing of database files, object oriented programming, class and exception handling, simplified web development and more can be yours with a move to OpenQM.

Why OpenQM

OpenQM has long sought to revolutionize the MultiValue industry, taking MultiValue to new heights of performance and expectation. OpenQM support and maintenance is now available for the first time directly from Zumasys, one of the largest development and engineering teams in the MultiValue market. With technical support engineers located across the United States and England, you'll always be able to reach someone who knows the importance of keeping your MultiValue application up and running.

Their software developers, technical support engineers, infrastructure experts, and cloud engineers will work with you to support, protect, and modernize your OpenQM database-whether on site or in the cloud. Their cloud platform is optimized for MultiValue database applications using industry-leading technologies from VMware, NetApp, and Cisco, and housed in the world's most secure data center, The SuperNAP, managed by expert engineers who understand your business. They take care of everything including backups, system administration, and monitoring so you can focus resources on your core business while maintaining complete control of your data and applications.

OpenQM In The Cloud

The Zumasys cloud platform has been optimized with Flash memory at multiple tiers to address the disk I/O requirements of OpenQM and other MultiValue databases. If you're interested in leveraging the efficiency, security, and performance of MultiValue in the cloud, Zumasys can help.

Since 2006, Zumasys has provided enterprise-class cloud hosting for Oracle, SQL and Pick MultiValue applications. They have the depth and experience to keep your systems running. Visit www.zumasys.com/cloud for more information on their architecture, monitoring and customer references.

OpenQM At A Glance

OpenQM began in 1993 as an embedded database from Ladybridge Systems. It was released in its own right in mid-2001 on Windows systems and extended to Linux in 2003 and FreeBSD in 2004. In 2015, OpenQM announced a partnership with Zumasys to provide worldwide distribution, to create a comprehensive telephone support/maintenance program and to multi-tenant OpenQM on the Zumasys Cloud. This allows customers to quickly provision OpenQM servers in the cloud and benefit from a convenient, affordable monthly fee for the database, operating system and underlying infrastructure.

Zumasys helps companies of every size transition their infrastructure and applications to the cloud. With Zumasys cloud services, customers can easily access the latest software and hardware technologies over the Web, allowing them to focus on growing their core business instead of managing their IT infrastructures. Zumasys delivers personalized service, integrated disaster recovery and the confidence companies need to outsource the hosting of all their databases including SQL, Oracle and Pick MultiValue systems.

For OpenQM inquiries please visit: http://www.openqm-zumasys.com/ Users with licenses issued before 1/1/15 please visit: www.ladybridge.com

For more information, visit http:/​/​www.openqm.com

Related Articles:

Return to top