|
|
| Author |
Message |
am
New User
Joined: 25 May 2005
Posts: 1
|
|
|
|
| I have to select certain records from a dataset with a certain field #= 'X'. Would it be better to write an Easytrieve or a JCL to do this? I would need help on the code to get started. Thank you in advance. |
|
| Back to top |
|
 |
References
|
 Posted: Wed May 25, 2005 9:06 am Post subject: Re: Selecting certain specific records from a mainframe dataset |
|
|
|
|
Deepa.m
Warnings : 1
Active User
Joined: 28 Apr 2005
Posts: 88
|
|
|
|
JCL can do this easily using sort utility
OUTFIL FNAMES=FILE1,INCLUDE=(6,1,CH,EQ,C'X')
all the records with charater 'X' in position 6 will be copied to File1.
likewise u can specify many conditions. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4236
Location: San Jose, CA
|
|
|
|
am,
You don't need to use OUTFIL INCLUDE to do this. You can just use an INCLUDE statement. An INCLUDE statement is generally more efficient than an OUTFIL INCLUDE statement. Here's the DFSORT job:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
INCLUDE COND=(p,1,CH,EQ,C'X')
/*
|
where p is the position of the field you want to check.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html |
|
| Back to top |
|
|
|
|
