Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7314

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: 8214
Location: Dubuque, Iowa, 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: 695
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: 695
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 Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts SORT BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us