IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sort only those records which contain LF90 and Lp90
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Bandita Bahubalendra

New User


Joined: 08 May 2008
Posts: 15
Location: Bangalore
PostPosted: Fri Jul 31, 2009 12:59 pm
 Reply with quote
Hi Everbody,

I hv one requirement,
my input record contain many lpar related information like LF90,LP90,LC90,7S01......etc.
In my output i want only those records which contain LF90 and Lp90.
i m giving the sort like this
SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=1,INCLUDE=(47,04,CH,EQ,C'LF90') ,here i m getting olny those records which contain LF90,while including some AND operator,getting some error.

Can anybody suggest wht would be the correct syntax to get all the information related to LP90 and LF90
Thanks in advance!
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
PostPosted: Fri Jul 31, 2009 1:30 pm
 Reply with quote
Code:

//SYSIN DD *
 SORT FIELDS=COPY
 OUTFIL FILES=1,INCLUDE=(47,04,CH,EQ,C'LF90',OR,
                47,04,CH,EQ,C'LP90')
Back to top
View user's profile Send private message
Bandita Bahubalendra

New User


Joined: 08 May 2008
Posts: 15
Location: Bangalore
PostPosted: Fri Jul 31, 2009 2:37 pm
 Reply with quote
Thanks,now it is working fine icon_smile.gif
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Fri Jul 31, 2009 8:21 pm
 Reply with quote
Bandita,

Alternatively, you could use:

Code:

/SYSIN    DD    *                                   
  SORT FIELDS=COPY                                     
  OUTFIL FILES=1,INCLUDE=(47,04,SS,EQ,C'LF90,LP90')   


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/support/docview.wss?rs=0&uid=isg3T7000080
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us