Search found 11 matches

by rajat_kharbanda
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...
by rajat_kharbanda
Fri Jul 06, 2012 8:12 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

I agree DikDude. That is why I keep coming back. :)
by rajat_kharbanda
Fri Jul 06, 2012 8:09 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

Thanks for this. This was simple, the tricky part comes where I need the count of record sets in the trailer.
by rajat_kharbanda
Fri Jul 06, 2012 7:42 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

Well, I have already apologized for my thinking/perception being wrong.
The point where I talked about different file lengths was just to explain what I thought was concatenation.
I have given all the file details in my original problem. RECFM=VB, LRECL=1000.
by rajat_kharbanda
Thu Jul 05, 2012 5:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

Well if that is the case. Refer to the above problem as a concatenation instead of merge.

Apologies for misleading.
by rajat_kharbanda
Thu Jul 05, 2012 1:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

I think I was wrong on how I depicted the merge in my first reply. To make it more clear, if i have the records in 1st file as:
1
2
5
3

and my second file has records as

6
2
4
8
I would need the final o/p as

1
2
5
3
6
2
4
8
by rajat_kharbanda
Thu Jul 05, 2012 1:23 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Conditional Count using IFTRAIL
Replies: 17
Views: 22418

Well Nic, it's upto a person's perception. From my perceptive, if I have 2 files with 1 containing records of 80 bytes and the other containing records of 120 bytes, I would say on concatenation, I would get a file of 200 bytes.
by rajat_kharbanda
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...
by rajat_kharbanda
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 . ....
by rajat_kharbanda
Tue Feb 28, 2012 3:06 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing 2 files on the basis of Date
Replies: 6
Views: 9267

Brilliant. I knew I could do it with SYMNAMES but just missed on how to go about it. Thanks Frank. :)
by rajat_kharbanda
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 ...