Search found 11 matches
- Fri Jul 06, 2012 8:37 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
Hi dbz, The header (000000) for both the files would be the same, so we can retain any of them. The trailer as well would be same except for the record set count in each file. We may use any one of the trailer and over-ride the count bytes with the new merged count. The format of the count is normal...
- Fri Jul 06, 2012 8:12 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Fri Jul 06, 2012 8:09 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Fri Jul 06, 2012 7:42 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Thu Jul 05, 2012 5:20 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Thu Jul 05, 2012 1:30 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Thu Jul 05, 2012 1:23 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
- Thu Jul 05, 2012 8:05 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
Hi William, Thanks for getting back. No, I mean a direct merge here. Say file 1 has records 1,2,5,3 and File 2 has 6,2,4,8. I would want the output to have records in the order 1,2,5,3,6,2,4,8. I did have this solution on my mind, but was looking for a simpler solution where I do not have to amend a...
- Wed Jul 04, 2012 6:05 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Conditional Count using IFTRAIL
- Replies: 17
- Views: 22418
Conditional Count using IFTRAIL
Hi, I am not sure if anything such as this already exist in one of the posts, but if it does can you direct me to it. I have 2 VB files, 1000 each bytes with similar format. Below is some sample data 000000XXXXXXXXXXXXXXXXX 100000XXXXXXXXXXXXYYYYYY 200000ZZZZZZZZZZZZZZZZZ 300000AAAAAAAAAAAAAAAAA . ....
- Tue Feb 28, 2012 3:06 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comparing 2 files on the basis of Date
- Replies: 6
- Views: 9267
- Mon Feb 27, 2012 7:47 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comparing 2 files on the basis of Date
- Replies: 6
- Views: 9267
Comparing 2 files on the basis of Date
Hi, I've been banging my head on this. It would be great if anyone could help. Note - I have to use ICETOOL/DFSORT to get the below result. I have 2 files - F1 - LRECL=100,RECFM=FB with date field in the form of YYYY-MM-DD(10 bytes) starting at position 15 (15-24). F2 - LRECL=80,RECFM=FB. This is a ...