Efficient usage of INCLUDE/OMIT condition

Narayanan Annamalai · New User Joined: 20 Jan 2012 Posts: 6 Location: India

Both Include and Omit condition could be used to cater the same purpose for several occasions.

For instance,

A) SORT FIELDS=COPY
INCLUDE COND=(1,5,CH,NE,C'XXXXX')

B) SORT FIELDS=COPY
OMIT COND=(1,5,CH,EQ,C'XXXXX')

Which one is more efficient usage and why ?

vasanthz · Posted: Tue Jan 24, 2012 4:36 pm

publib.boulder.ibm.com/infocenter/zos/v1r12/index.jsp?topic=%2Fcom.ibm.zos.r12.iceg200%2Ftail.htm

"Your choice of an INCLUDE or OMIT statement depends on which is easier and more efficient to write for a given application. You cannot use both statements together."
It appears both are equally effecient in terms of performance perspective. I could be wrong as well.

Bill Woodger · Posted: Tue Jan 24, 2012 4:49 pm

I also don't think performance is affected.

INCLUDE NE is less "natural" than OMIT EQ, in my opinion. I would write the one which is most easy to understand in the particular situation.

Frank Yaeger · Posted: Tue Jan 24, 2012 11:56 pm