RAMESH KRISHNA REDDY mainframe discussion forum - cobol, db2,cics,jcl,file-aid,changeman,... interview questions, quizs
Online Tutorials   | PREV  | TOP  | NEXT



DRONA SERIES
SORT INCLUDE TUTORIAL


CHAPTER - 2


Validate Numeric Data using SORT INCLUDE - Example



   
 
 Validate Numeric Data in SORT INCLUDE
 


Here the example SORT CARD to validate the numeric data. Include records which has valid numeric data in specified fields. INCLUDE COND=(54,10,FS,EQ,NUM) Example - Input file for SORT JCL 10 suresh 20000 01 20120203 34 20 NARENDRA 40000 06 20120925 AB 30 jacob A 25000 07 20111018 1A 40 RAMESH 34000 03 20120610 2C 50 Kishore 50000 02 20120408 45 INCLUDE COND in SORT JCL //SYSIN DD * SORT FIELDS=COPY INCLUDE COND=(31,2,FS,EQ,NUM) /* //* copyright www.mainframegurukul.com Explanation - Input records will be selected and moved to outputfile, if input record has numeric values at 31st position. Output file from SORT JCL 10 suresh 20000 01 20120203 34 50 Kishore 50000 02 20120408 45 ******************************** Bottom of Data ******** .
    

NEXT CHAPTER TOPIC : Introduction to SORT INREC


                                   




Home | Donations | Online Tutorials | Books | Entertainment | Contactme | privacy |  sql tutorial | jcl interview questions | JCL Tutorial | JCL Tutorial - chapter1 | JCL Tutorial - chapter2 | JCL Tutorial - chapter3 | JCL Tutorial - chapter4 | JCL Tutorial - chapter5 | JCL Tutorial - chapter6 | JCL Tutorial - chapter7 | JCL Tutorial - chapter8 | JCL Tutorial - chapter9 | JCL Tutorial - chapter10 | JCL Tutorial - chapter11