Technical Articles

The Technical Articles section provides a wide variety of detailed technical content covering a wide area of material which has been written by our technical team members.

 


Restoring with "ontape" from a different IDS edition

Abstract

Depending on your IDS version, you may be unable to restore a test instance from production using "ontape" if the edition (Ultimate/Enterprise, Growth/Workgroup or Innovator) is different, even if the version is otherwise the same. This article provides a solution.


Faster alternative to NOT EXISTS using ANSI joins

Abstract

It is sometimes necessary to identify rows in one table for which there is no associated row in another table. An example would be an order for which there are no order detail lines. The conventional approach is to use NOT EXISTS (sub-query), but this can be extremely slow for large data sets. This article demonstrates how an ANSI join can achieve the same result much more efficiently.


Pages