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
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: pls tell me the logic fo the prog which has got two seq file
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: 8593
Location: Back in jolly old England

PostPosted: Wed Jul 27, 2011 4:12 pm    Post subject:
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: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Jul 27, 2011 4:26 pm    Post subject:
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    Post subject: Reply to: pls tell me the logic fo the prog which has got tw
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Jul 27, 2011 7:43 pm    Post subject: Reply to: pls tell me the logic fo the prog which has got tw
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
http://www.ibmmainframes.com/viewtopic.php?t=22649
Back to top
View user's profile Send private message
superk

Moderator Team Head


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

PostPosted: Wed Jul 27, 2011 7:55 pm    Post subject: Re: Reply to: pls tell me the logic fo the prog which has go
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    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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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