View previous topic :: View next topic
|
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 |
|
|
Deepa.m
New User
Joined: 28 Apr 2005 Posts: 99
|
|
|
|
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 Developer
Joined: 15 Feb 2005 Posts: 7129 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:
Use [URL] BBCode for External Links |
|
Back to top |
|
|
|