I have two files.
Ist file has record length as 512
2nd file has record length as 323
The first file has START DATE and END DATE ,starting at pos (33,16)
The second file also has DATE starting at pos (16,8).
I need all the records from the second file ,if its DATE is falling between
START DATE and END DATE of first file.
i.e START DATE<= DATE in second file<=END DATE.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
manjulaa,
What is the RECFM and LRECL of each input file?
Show an example of the records in each input file and what you expect for output. If there can be duplicates within file1, show that in the example. If there can be duplicates within file2, show that in the example.
xxxxxxxxxxxxxxx yyyyyyy G 7989978279899685
In the second file the date is present as COMP-3 format of 9's compliment of the date,and it can have duplicates w.r.t
dates also.It is starting at Pos 24.( PIC 9(08) COMP-3).
I would leave final decision on Admin but I think you should remove the attachment from your post. You forgot to remove your company's name at the left bottom corner and also by forum rules, I don't think you are allowed to attach documents in the post.
Copyright
You should not use our forums to post/attach/link any material which is knowingly false and/or defamatory, inaccurate, sexually oriented, abusive, harassing or threatening, contains viruses or other contaminating or destructive features, violates the rights of others, such as Content which infringes any copyright, trademark, patent, trade secret or violates any right of privacy or publicity, or otherwise violates any applicable law.. Feel free to ask the moderators before posting the downloaded materials from other sites.
For example if your input file2 had the following PD values starting in 24:
78888888
80000000
79899782
79899685
79899700
The 3rd, 4th and 5th records would be kept since they are between 79899782 and 79899685. I assumed equal to was included in "between" but you can change the INCLUDE statement to whatever you need.