View previous topic :: View next topic
|
Author |
Message |
rasitha chandran
New User
Joined: 25 Jan 2008 Posts: 6 Location: chennai
|
|
|
|
..
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
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? |
|
Back to top |
|
|
ridgewalker58
New User
Joined: 26 Sep 2008 Posts: 51 Location: New York
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
|