Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Sort Card using outfil for VSAM files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
subdalal

New User


Joined: 27 Sep 2010
Posts: 21
Location: Boudh

PostPosted: Thu Jan 31, 2013 3:15 pm    Post subject: Sort Card using outfil for VSAM files
Reply with quote

Hi,
I have requirement to extract reords starting with (500,501,600,601) to one VSAM file and the rest other records to another VSAM file.

But I am not getting appropriate results. Please help !!!

The Sort Card is as below:


SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=(1,3,ZD,EQ,500,OR,
1,3,ZD,EQ,501,OR,
1,3,ZD,EQ,600,OR,
1,3,ZD,EQ,601)
OUTFIL FILES=02,INCLUDE=(1,3,ZD,NE,500,AND,
1,3,ZD,NE,501,AND,
1,3,ZD,NE,600,AND,
1,3,ZD,NE,601)
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Thu Jan 31, 2013 4:35 pm    Post subject: Reply to: Sort Card using outfil for VSAM files
Reply with quote

Are you using CA-Sort? Or have you posted in the wrong forum? Can you confirm which product you are using, please?

Can you show sample input and expected output? In the Code Tags.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Thu Jan 31, 2013 5:38 pm    Post subject:
Reply with quote

Quote:
But I am not getting appropriate results. Please help !!!
How can we help when you did not describe a problem? "[N]ot getting appropriate results" could be any of:
- getting an abend
- getting a SORT error message
- getting a SORT warning message
- getting results for file 01 but not file 02
- getting results for file 02 but not file 01
- getting results for file 01 and file 02 but not what you expected in file 01
- getting results for file 01 and file 02 but not what you expected in file 02
- getting results for file 01 and file 02 but neither is what you expected
- something else you have not explained

Since each of these requires different solution, it's hard to say much. In other words, you have not yet even defined what kind of problem you have.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 646
Location: Pennsylvania

PostPosted: Thu Jan 31, 2013 6:18 pm    Post subject:
Reply with quote

Come on guys, isn't Thursday crystal ball day?

The OP has Syncsort, and thinks it is owned by CA (don't they own most everything).

The VSAM file is VB and he must add 4 bytes to his location (1 becomes 5).

The Ravens will beat the 49ers in the Superbowl.
Back to top
View user's profile Send private message
subdalal

New User


Joined: 27 Sep 2010
Posts: 21
Location: Boudh

PostPosted: Thu Jan 31, 2013 6:30 pm    Post subject:
Reply with quote

Thanks @daveporcelan !!!

It worked icon_smile.gif
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 646
Location: Pennsylvania

PostPosted: Thu Jan 31, 2013 6:33 pm    Post subject:
Reply with quote

The Ravens won already? They haven't played the game yet.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us