 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 17 matches |
| 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 ... |
|
All times are GMT - 5 Hours |