6 Sept 2012

How to filter using INCLUDE condition


  • Sort filters the records, based on the include condition when copying to the output dataset.
  • Records having the character(KARTHICK) from 6 position to 12 position will only be copied to the sortout dataset.
  • we have opertions like EQ(EQual), GT(Greater Than), GE(Greater and Equal), LE(Lesser and Equal), LT(Lesser Than), etc., play a vital role in include condition.

//SYSIN DD *
 SORT FIELDS=COPY
 INCLUDE COND=(6,7,CH,EQ,C'KARTHICK')
 /*

No comments:

Post a Comment