 |
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 140 matches |
| Author | Message |
|---|---|
 Topic: Merging two files into one file at different positions |
|
| psmadhusudhan Replies: 3 Views: 2742 |
 Forum: Utilities Posted: Fri Jul 02, 2021 2:15 am Subject: Merging two files into one file at different positions |
| I am sorry Kolusu if my wordings didn't explain my requirments clearly.
So I am writing control cards below through which I haave achieved the results but in 3 steps, these can give an idea about m ... |
|
| Topic: Merging two files into one file at different positions |
|
| psmadhusudhan Replies: 3 Views: 2742 |
Forum: Utilities Posted: Thu Jul 01, 2021 11:31 am Subject: Merging two files into one file at different positions |
| Hi All,
I have two files as below File1: Rec len - 300 key1 - 1,5 File2; Rec len - 200 key2 - 6,5 I want to have single file as below. no matching need to be done. Ou ... |
|
| Topic: Unstring using SORT or any other utility |
|
| psmadhusudhan Replies: 3 Views: 3383 |
Forum: Utilities Posted: Mon Jun 21, 2021 11:39 am Subject: Unstring using SORT or any other utility |
| Sorry kolusu. My apologies. I couldn't recall the key word PARSE and ended up posting the question. It had been 10 years since my previous question so forgot about it completely. thanks for being kind ... | |
| Topic: Unstring using SORT or any other utility |
|
| psmadhusudhan Replies: 3 Views: 3383 |
Forum: Utilities Posted: Mon Jun 21, 2021 4:10 am Subject: Unstring using SORT or any other utility |
| Hi All,
I would like to know whether we can do unstring using SORT or any other utility. My requirement is as below Input file is have pipe delimited data as below BARTHOLOMEW|XXXX|UNK|UNK ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Tue Sep 15, 2020 6:46 pm Subject: Comparing two files and update one for specific records only |
| Yes Kolusu,I just want to convey that above control cards worked fine when file format is FB and there was no issue in positions.
I have adjusted 1 byte for FBA too and ran it, it worked fine. T ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Tue Sep 15, 2020 6:23 am Subject: Comparing two files and update one for specific records only |
| 1. Did you check if the input file is a VB/FBA/VBA file? If so you need to account for RDW/carriage control characters
The file format is FBA. Thanks for pointing it out. I have copied file to anot ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Mon Sep 14, 2020 1:11 am Subject: Comparing two files and update one for specific records only |
| Sorry my typo mistake, Key starts from position 16 as mentioned in control card | |
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Sat Sep 12, 2020 3:54 am Subject: Comparing two files and update one for specific records only |
| Hi kolusu,
my input file F1 got modified with new positions and one additional field. F1- Key position 11,9 Field1 position 192,9 Field2 position 230,10 Field3(new) position 219,10 F2 fil ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Thu Jul 30, 2020 9:18 am Subject: Comparing two files and update one for specific records only |
Thanks Kolusu. It worked awesome.  |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Thu Jul 30, 2020 1:58 am Subject: Comparing two files and update one for specific records only |
| Thanks kolusu for full jcl.
Sort job ran fine. Matching and updation occured correctly. But one issue is there. All C1305 records came at the end of file. For example before run: C1301 C1302 ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Wed Jul 29, 2020 10:06 am Subject: Comparing two files and update one for specific records only |
| Thank Kolusu for quick reply.
even though I had doubt in field positions in your code I straight away tried it and getting below error ICE414A 0 INA (F1) KEY FIELD END AT 301 IS BEYO ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Wed Jul 29, 2020 4:20 am Subject: Comparing two files and update one for specific records only |
| Also tried using JOINKEYS of SORT as below
//STEP0100 EXEC PGM=SORT //DFSMSG DD SYSOUT=* //TOOLMSG DD SYSOU ... |
|
| Topic: Comparing two files and update one for specific records only |
|
| psmadhusudhan Replies: 14 Views: 9323 |
Forum: Utilities Posted: Wed Jul 29, 2020 4:15 am Subject: Comparing two files and update one for specific records only |
| Hi all,
I am trying to match two input files F1, F2 based on 1 Key and update two fields from F1 in F2 at certain positions for Key matched records with other field matching condition in F2. F1 ... |
|
| Topic: UTF-8 TO EBCDIC conversion |
|
| psmadhusudhan Replies: 1 Views: 3916 |
Forum: Application Programming Posted: Mon Feb 24, 2020 7:12 pm Subject: UTF-8 TO EBCDIC conversion |
| Hi,
Is it possible to convert UTF-8 format input data to EBCDIC format in Cobol program. If possible could somebody please share syntax for the conversion. If not could you please suggest throug ... |
|
| Topic: Blank record out of sort |
|
| psmadhusudhan Replies: 2 Views: 3068 |
Forum: Utilities Posted: Wed Oct 30, 2019 1:03 am Subject: Blank record out of sort |
| Thanks Kolusu. INCLUDE COND worked fine and blank record is not coming in output.
Sorry for delay in reply as just now back from Diwali holidays. |
|
All times are GMT - 5 Hours |