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
 

 

DFSORT card intead of Super C

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Thu Sep 13, 2012 12:53 pm    Post subject: DFSORT card intead of Super C
Reply with quote

Hi,

I have corrected the 6 characters of each file at position 1904 and 1910 of a FB file. Both files of same record length as 1950 and having same no.of records.This is based on conditin if space is found in any of 6 characters of these two columns. As a result 10 records are found with space and replaced with a value. The I/P file is having some 1 million records.

Now, I will have to compare my file- before correction and new file -with correction and show only the records which were having spaces are corrected.

I tried to do this with Super C, but want output in a different file. Please advice..
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7309

PostPosted: Thu Sep 13, 2012 1:11 pm    Post subject: Reply to: DFSORT card intead of Super C
Reply with quote

JOINKEYS with whole record as key (if data is in ascending order) or appended sequence number as key,

With former, just use the match marker ?

With the latter, arrange a comparison of the two records stored in a REFORMAT record.
Back to top
View user's profile Send private message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Thu Sep 13, 2012 1:23 pm    Post subject:
Reply with quote

Bill,

Data is sorted, I am not clear about your question "With former, just use the match marker ? "
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Thu Sep 13, 2012 1:30 pm    Post subject: Reply to: DFSORT card intead of Super C
Reply with quote

topic locked as a continuation of

http://www.ibmmainframes.com/viewtopic.php?t=59438&highlight=

the TS looks like a person who wear pants with belt and suspenders
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7309

PostPosted: Thu Sep 13, 2012 2:11 pm    Post subject: Reply to: DFSORT card intead of Super C
Reply with quote

This is now a match of the data once fixed.

Simpler as a new topic, I think.

Code:
  JOIN UNPAIRED,F2,ONLY


Is even simpler, assuming F2 is the "new" file, and with the key for the JOINKEYS being the entire record.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm


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