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
 

 

IDCAMS REPLACE Functionality in SORT for VSAM files.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Thu Jul 19, 2012 9:02 am    Post subject: IDCAMS REPLACE Functionality in SORT for VSAM files.
Reply with quote

Hi,

In SORT as per the manual
RESET - Specifies that SORT processes a VSAM output data set defined with REUSE as a NEW data set.
NORESET - specifies that SORT processes a VSAM output data set defined with REUSE as a MOD data set.

However when I tried to use NORESET option, SORT will fail if the same records(KEY) exists in the OUTPUT VSAM file.

Can you please help me to know if there are any options which can be used to get equivalent functionality of IDCAMS REPRO REPLACE command using SORT in single step?

Regards,
Chandra
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Thu Jul 19, 2012 11:53 am    Post subject: Reply to: IDCAMS REPLACE Functionality in SORT for VSAM file
Reply with quote

Please show your Sort cards, and listcats of your input and output VSAM files.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jul 19, 2012 8:53 pm    Post subject:
Reply with quote

Hello,

I suspect this is intended rather than a problem. The VSAM file will not allow duplicates. . . You can't MOD duplicates onto the end of the VSAM file - they are still duplicates are they not?

I know of no "replace" option n the sort products.

Possibly i misunderstand.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Jul 20, 2012 2:03 am    Post subject: Re: IDCAMS REPLACE Functionality in SORT for VSAM files.
Reply with quote

chandraBE wrote:

Can you please help me to know if there are any options which can be used to get equivalent functionality of IDCAMS REPRO REPLACE command using SORT in single step?

Regards,
Chandra


If you are dealing with KSDS then DFSORT does not have an option to replace.
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Fri Jul 20, 2012 2:33 pm    Post subject:
Reply with quote

Thanks Dick scherrer and Kolusu for confirming this.
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 -> DFSORT/ICETOOL 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