View previous topic :: View next topic
|
Author |
Message |
useit
Active User
Joined: 05 Oct 2006 Posts: 152
|
|
|
|
i have two files. file1 and file2
file1 will have only date field in it.my requirement is to fetch only those records from file2 which are greater than or equal to the date field from file1.
say fo example
file1 :
file2:(lrecl=13)
Code: |
abc2012-10-08
abc2012-10-09
abc2012-10-10
abc2012-10-11
abc2012-10-12
abc2012-10-13 |
my output should be:
Code: |
abc2012-10-10
abc2012-10-11
abc2012-10-12
abc2012-10-13 |
i think if we can append the date field from file1 to the end of each record of second file. then we can fetch using include condition .but i dont konw how to append the record from the file1 at the end of each record of second file.
please help me in this regard,or any other simple way of doing it
Regds,
useit |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Search this forum on Symnames |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
Back to top |
|
|
|