Powered by QM on a Linux server
Help and Support

KnowledgeBase 00105: Non-Transactional Updates

Last updated: 27 Dec 2018
Applies to: All versions
Top level index       Full Index Search Tips
Previous article     Next article

Historically, few multivalue applications have made use of the transaction processing capabilities of the underlying database. Those that do sometimes encounter the need to apply an immediate update to a file within the scope of a transaction.

Opening a File for Non-Transactional Update

The QMBasic OPEN and OPENPATH statements both have an optional NON.TRANSACTIONAL qualifier. Any updates applied using the file variable returned from these operations will be applied immediately and do not form part of any currently active transaction.

Because the updates become non-transactional, rolling back the transaction will not undo the changes.

Related Articles


Please tell us if this article was helpful
Very     Slightly     Not at all
Email (optional)