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: 7315

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: 8118
Location: East Dubuque, Illinois, USA

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: 670
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: 670
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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts getting three output files out of JOI... migusd SYNCSORT 7 Mon Jun 05, 2017 11:30 pm


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