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 46 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Help with INREC Overlapping Columns & SEQNUM for Groupin
Suchay

Replies: 3
Views: 17955

PostForum: Utilities   Posted: Mon Sep 15, 2025 3:11 pm   Subject: Help with INREC Overlapping Columns & SEQNUM for Groupin
Thank you so much Kolusu, using INREC gave us duplicates as you have explained above

OUTREC it worked fine.

Thank you
  Topic: Help with INREC Overlapping Columns & SEQNUM for Groupin
Suchay

Replies: 3
Views: 17955

PostForum: Utilities   Posted: Thu Sep 11, 2025 3:37 pm   Subject: Help with INREC Overlapping Columns & SEQNUM for Groupin
Kolusu,
Please delete the duplicate messages posted on the same subject, due to PHP issue it happened

We modified the code and it worked fine, please advise


SORT FIELDS=(3,12,CH,A,15,05, ...
  Topic: Help with INREC Overlapping Columns & SEQNUM for Groupin
Suchay

Replies: 3
Views: 17955

PostForum: Utilities   Posted: Thu Sep 11, 2025 12:27 pm   Subject: Help with INREC Overlapping Columns & SEQNUM for Groupin
I'm working with a 260-byte fixed-length input file and need to identify the least record (based on a group of key fields). The goal is to split the file into two outputs:

One with the least record ...
  Topic: Format of IMS X'99' Log record
Suchay

Replies: 2
Views: 103653

PostForum: IMS   Posted: Thu Feb 08, 2024 11:01 pm   Subject: Format of IMS X'99' Log record
Thank you kolusu
  Topic: Format of IMS X'99' Log record
Suchay

Replies: 2
Views: 103653

PostForum: IMS   Posted: Wed Feb 07, 2024 11:28 am   Subject: Format of IMS X'99' Log record
Hello,

We are working on capturing data changes in IMS DB. We have to read IMS X'99' Logs for extracting the changes. We are looking for the sample format of X'99' record to understand layout, sin ...
  Topic: SFTP transfer from PSAP to mainframe
Suchay

Replies: 1
Views: 16246

PostForum: TSO and ISPF   Posted: Mon Sep 12, 2022 10:59 am   Subject: SFTP transfer from PSAP to mainframe
Hi, SAP is trying to send files directly to mainframes thry SFTP, we have created a generic id for mainframe login for PSAp to sftp the files. WHile PSAP team tries to sftp the files they go to the u ...
  Topic: Getting File from Unix(SAP) to mainframe and parse thru Sort
Suchay

Replies: 7
Views: 6991

PostForum: Utilities   Posted: Fri Feb 16, 2018 12:08 pm   Subject: Getting File from Unix(SAP) to mainframe and parse thru Sort
We are receiving the file from SAP (Unix server). It is a report in a.TXT file. When we received the file to mainframes, it could not recognize the End of Line character (X’25’) from un ...
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Mon Dec 04, 2017 3:37 pm   Subject: Summing up a particular group of records into a single row?
Kolusu,

Thank you for the help. SORT card worked good and we got the results, working on symbols and CHANGE command.

regards,
Suchay
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Mon Nov 27, 2017 12:07 pm   Subject: Summing up a particular group of records into a single row?
Kolusu,

I have fixed the report and the sortcard


1REPT01 Report main Header PAGE 175
0FOR: NOVEM ...
  Topic: Need Help with Join Keys
Suchay

Replies: 9
Views: 4688

PostForum: Utilities   Posted: Fri Nov 17, 2017 11:42 am   Subject: Need Help with Join Keys
Thank you Kolusu.
  Topic: Need Help with Join Keys
Suchay

Replies: 9
Views: 4688

PostForum: Utilities   Posted: Thu Nov 16, 2017 4:49 pm   Subject: Need Help with Join Keys
Thank you Kolusu, Logic worked , below was the code we developed out of steps provided


//STEP02 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD *
1 ...
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Wed Nov 15, 2017 5:27 pm   Subject: Summing up a particular group of records into a single row?
Please use the below one

1REPT01 Report main Header PAGE 175
0FOR: NOVEMBER 10 2017 ...
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Wed Nov 15, 2017 5:25 pm   Subject: Summing up a particular group of records into a single row?
Kolusu,


Why are you complicating a simple request? Why do you need to change the SORT card for every year, you can process ALL years or a Single year without ever bothering to change the sort car ...
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Wed Nov 15, 2017 1:41 pm   Subject: Summing up a particular group of records into a single row?
Same build would be repeated but SOR T would differ for each newyor
  Topic: Summing up a particular group of records into a single row?
Suchay

Replies: 14
Views: 7709

PostForum: Utilities   Posted: Wed Nov 15, 2017 1:40 pm   Subject: Summing up a particular group of records into a single row?
Kolusu,


Why do you need another step to create sum the 3 instances?


We need to pick these three rows 91-120, 121-150,OVER-150 and
total the count,amount, so we created each row with SOR T ...
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group