Friday 2 March 2012

Use of IN clause

Gen 8.0 introduces IN and BETWEEN clauses for READ and READ EACH statements.

Whilst there may no longer be any performance benefit in converting to this syntax, an IN clause can make a complex READ statement more readable (no pun intended).

Consider the example below:


This can be re-written using IN clauses:


Even better, the improved READ EACH statement above was automatically converted by using a VerifIEr check that detects READ statements that could use an IN clauses and then invokes the integrated genIE fix to convert the READ statement.