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

Select a record and update with the new value in a position


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
subbu1522

New User


Joined: 11 Sep 2008
Posts: 29
Location: USA

PostPosted: Wed Feb 22, 2012 12:15 pm
Reply with quote

Hi, I would request your help.

1/p file: 1040 FB PS file
o/p file: same layout needed

Requirement: I/P file with a millions of records and I know the record with claim-number (pos 1-13) and need to change the date for that record and need to write to o/p file with all the records from I/p to o/p including the modified record.

Please help me.

Thanks,
Subbu.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Wed Feb 22, 2012 12:27 pm
Reply with quote

read about OVERLAY statement in DFSORT with an INCLUDE condition,

BTW changing claim date? I hope nothing unethical is done. :-)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Feb 22, 2012 1:42 pm
Reply with quote

since You told nothing about the position of the <key> and the data to be changed

we can only hint on the general format of the sort statements to be used

Code:
// ... all the usual SORT jcl statements
//SYSIN DD *
  OPTION COPY
  INREC IFTHEN=(WHEN=(position,lenght,format,EQ,<key data>),OVERLAY=(position:<overlay data>))


searching the dfsort forum with the OvERLAY keyword will give You zillions of examples
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Feb 22, 2012 11:18 pm
Reply with quote

Might be a good idea to have a copy of the originals on a seperate tile.
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 How to split large record length file... DFSORT/ICETOOL 10
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top