MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 17 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Merge two files and sort
erasani

Replies: 5
Views: 772

PostForum: 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: 772

PostForum: 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: 772

PostForum: 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: 772

PostForum: 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: 749

PostForum: 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: 749

PostForum: 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: 1217

PostForum: 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: 1217

PostForum: 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: 1495

PostForum: 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: 1495

PostForum: 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: 2578

PostForum: 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: 2578

PostForum: 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: 1922

PostForum: 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: 1922

PostForum: 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: 1922

PostForum: 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 ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group