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

pls tell me the logic fo the prog which has got two seq file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rasitha chandran

New User


Joined: 25 Jan 2008
Posts: 6
Location: chennai

PostPosted: Wed Jul 27, 2011 3:57 pm
Reply with quote

..




First File:
SSN Member Name

1234567890 Ganesh

3444567890 Chandra




Second File:
SSN DOB IID Source System

1234567890 5101984 12345 MEA

1234567890 11101987 12345 HMO

1234567890 101984 12345 DMD

1234567890 12101987 34542 SPA

3444567890 1101987 56546 MEA

3444567890 2101987 56765 HMO

3444567890 3101987 23123 DMD

now the output shud be like if we the ssn in both the files are matching...then say if ssn 1234567890 is matching,.....then we need to retrieve all the rec related to it from both the files into one output file....
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jul 27, 2011 4:12 pm
Reply with quote

Well, with the amount of useful information that you have given us to work with the answer could be anything you want it to be.

What program / utility are we supposed to use.
If a utility, which utility and release level are we talking about.
If a program, one assumes that you are writing it.
File 1 - DSORG, RECFM, LRECL and key positions, lengths and data formats.
File 2 - See request for file 1

Now post again ONLYwhen youhave ALL of the answers to these questions.

And in the meantime, any other West Ham United supporters out there want to join in a chorus of "Bubbles"
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Jul 27, 2011 4:26 pm
Reply with quote

Quote:

And in the meantime, any other West Ham United supporters out there want to join in a chorus of "Bubbles"


Hooligans drink bubbles? Or only the ones that came out of the closet? icon_redface.gif
Back to top
View user's profile Send private message
ridgewalker58

New User


Joined: 26 Sep 2008
Posts: 51
Location: New York

PostPosted: Wed Jul 27, 2011 7:38 pm
Reply with quote

Has this become a site where you fellows write the programs or code the utility parameters and the TS gets paid for your efforts.

Seems like that is what the assumption is as stated in the TS's topic title:

PLS TELL ME THE LOGIC FO THE PROG WHICH HAS GOT TWO SEQ FILE
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Jul 27, 2011 7:43 pm
Reply with quote

check the cobol forum for
2-File Match/Merge sample code

to make it easier for You here is the direct link
www.ibmmainframes.com/viewtopic.php?t=22649
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Wed Jul 27, 2011 7:55 pm
Reply with quote

ridgewalker58 wrote:
Has this become a site where you fellows write the programs or code the utility parameters and the TS gets paid for your efforts.

Seems like that is what the assumption is as stated in the TS's topic title:

PLS TELL ME THE LOGIC FO THE PROG WHICH HAS GOT TWO SEQ FILE


No, and it won't ever be, with the exceptions for directly-supported products that I'm sure you're already aware of.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top