Search found 3 matches
- Thu Feb 26, 2015 4:55 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Merge two files data nd update trailer count
- Replies: 1
- Views: 3086
Merge two files data nd update trailer count
Hi , I have a requirement to combine records of two input files and write into one single file.In addition to this i need to update the trailer count. The two input files AAA and BBB are of record length 799 and FB. The output file is also of same format and length AAA file will have 1-n records .It...
- Thu Jan 31, 2013 11:59 am
- Forum: JCL
- Topic: SORT - Sum based on similar fields
- Replies: 1
- Views: 2845
SORT - Sum based on similar fields
Hi, I have a requirement to sum the AMOUNT field if there are records for which the combination of Fields - ACCNO,SEC,DATE1,DATE2,PRICE are same but the TRAN field value is different and write it to the output file1 as a single record.The output file 2 should have both the records which satisfy this...
- Tue Jan 15, 2013 8:22 am
- Forum: JCL
- Topic: Compare two files based on key and date range
- Replies: 1
- Views: 3138
Compare two files based on key and date range
Hi, I have a requirement to compare two files based on key account number and also check if effect date in file1 lies between FROM and TO DATE in file2.Date fields are of format YYYYMMDD. Records that match the above criteria are written in file3 and unmatched ones in file4. All files are of record ...