Author |
Message |
Topic: Merge two files and sort |
erasani
Replies: 5
Views: 2145
|
Forum: Utilities Posted: Wed Nov 01, 2023 6:51 pm Subject: Merge two files and sort |
Thanks kolusu for your help |
Topic: Merge two files and sort |
erasani
Replies: 5
Views: 2145
|
Forum: Utilities Posted: Mon Oct 30, 2023 8:08 am Subject: Merge two files and sort |
Hi Kolusu,
Sorry for the confusion. I was trying to simplify the lengths and made a mess.
Just to summarize,
1) File 1 length is 147. This file will have one record per key. I am adding 1370 s ... |
Topic: Merge two files and sort |
erasani
Replies: 5
Views: 2145
|
Forum: Utilities Posted: Sun Oct 29, 2023 2:59 pm Subject: Merge two files and sort |
Hi All,
I have shown the Input files and the Desired output. Currently i am achieving the desired output in 3 steps. Shown them above. Please let me know if all these steps can be combined in one?
... |
Topic: Merge two files and sort |
erasani
Replies: 5
Views: 2145
|
Forum: Utilities Posted: Sun Oct 29, 2023 1:33 pm Subject: Merge two files and sort |
Input File1(Key is 1st 6 positions):
KEY001FILE1............
KEY002FILE1............
KEY003FILE1............
Input File2(Key is 1st 6 positions):
KEY001FILE2.......................... ... |
Topic: padding of $$ |
erasani
Replies: 2
Views: 1729
|
Forum: Utilities Posted: Wed Aug 16, 2023 1:00 pm Subject: padding of $$ |
Thanks a lot kolusu for your help. |
Topic: padding of $$ |
erasani
Replies: 2
Views: 1729
|
Forum: Utilities Posted: Tue Aug 15, 2023 1:59 pm Subject: padding of $$ |
Hi,
We have a space delimited file as below. Based on the length of the field it needs to pad appropriate number of '$'. In some cases its left padding and in other cases its right. Any inputs on h ... |
Topic: Overlay data |
erasani
Replies: 2
Views: 2194
|
Forum: Utilities Posted: Tue Jul 12, 2022 8:56 pm Subject: Overlay data |
As usual, you're the best..Thanks Kolusu |
Topic: Overlay data |
erasani
Replies: 2
Views: 2194
|
Forum: Utilities Posted: Tue Jul 12, 2022 5:06 pm Subject: Overlay data |
Hi,
Can some one please help me with the bleow. Record 1(Positions 4-8) in first file should be overlaid with second file(Positions 1-5) and write into output file. There is no matching criteria ... |
Topic: Matching Files using DFSORT |
erasani
Replies: 3
Views: 1891
|
Forum: Utilities Posted: Thu Nov 18, 2021 6:44 am Subject: Matching Files using DFSORT |
Thanks kolusu. Went thru DFSort tricks doc. Below code gave me the expected results.
OPTION COPY
JOINKEYS F1=SORTJNF1,FIELDS=(1,53,A) ... |
Topic: Matching Files using DFSORT |
erasani
Replies: 3
Views: 1891
|
Forum: Utilities Posted: Wed Nov 17, 2021 11:01 am Subject: Matching Files using DFSORT |
Hi Team,
We have the below requirement. There are two input files. Please let me know if this can be achieved using DFSORT/ICETOOL.
- Input File1 has unique records in sorted order. First 20 by ... |
Topic: Sort subset of records within a file |
erasani
Replies: 2
Views: 2882
|
Forum: Utilities Posted: Thu Nov 11, 2021 10:54 am Subject: Sort subset of records within a file |
Thanks a lot once again kolusu. |
Topic: Sort subset of records within a file |
erasani
Replies: 2
Views: 2882
|
Forum: Utilities Posted: Thu Nov 11, 2021 6:45 am Subject: Sort subset of records within a file |
Hi All,
We have a requirement where we have to sort the I621* and I618* record types. These records can occur between BH(batch header) and (BT)Batch Trailer records.
Currently, the records are ... |
Topic: Format Numeric fields with leading zeros |
erasani
Replies: 3
Views: 2315
|
Forum: Utilities Posted: Thu Nov 11, 2021 6:03 am Subject: Format Numeric fields with leading zeros |
Thanks Kolusu for your help. Works perfectly |
Topic: Format Numeric fields with leading zeros |
erasani
Replies: 3
Views: 2315
|
Forum: Utilities Posted: Wed Nov 10, 2021 8:46 am Subject: Format Numeric fields with leading zeros |
I have tried with the below SORT card. Got the output as 000000000001. However, i need the Output as 00000000000A.
SORT FIELDS=COPY
OUTREC FIELDS=(63,12,SFF,TO=ZD)
Input
... |
Topic: Format Numeric fields with leading zeros |
erasani
Replies: 3
Views: 2315
|
Forum: Utilities Posted: Wed Nov 10, 2021 8:28 am Subject: Format Numeric fields with leading zeros |
Hi All,
I am trying to create a file using DFSORT which will be input to a COBOL Program. There are some numeric fields with leading spaces, which need to be formatted as S9(10)V99. I tried convert ... |
|