 |
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 43 matches |
| Author | Message |
|---|---|
 Topic: Format of IMS X'99' Log record |
|
| Suchay Replies: 2 Views: 1725 |
 Forum: 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: 1725 |
Forum: 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: 1606 |
Forum: 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: 3335 |
Forum: 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: 5430 |
Forum: 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: 5430 |
Forum: 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: 3540 |
Forum: 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: 3540 |
Forum: 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: 5430 |
Forum: 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: 5430 |
Forum: 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: 5430 |
Forum: 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: 5430 |
Forum: 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 ... |
|
| Topic: Summing up a particular group of records into a single row? |
|
| Suchay Replies: 14 Views: 5430 |
Forum: Utilities Posted: Wed Nov 15, 2017 11:45 am Subject: Summing up a particular group of records into a single row? |
| Kolusu,
There is no chance of duplicates, since the input is created from Sort step out of mainframe report and we create 3 instances for T52, T61 and other rows will have only one instance . We ne ... |
|
| Topic: Summing up a particular group of records into a single row? |
|
| Suchay Replies: 14 Views: 5430 |
Forum: Utilities Posted: Mon Nov 13, 2017 4:38 pm Subject: Summing up a particular group of records into a single row? |
| Kolusu,
Incase we have all zeroes for T61, we need the zero displayed, We need to sum up the values in columns 10,7 ,only for the rows appearing thrice ----+----1----+----2----+----3----+-- ... |
|
| Topic: How to get PST TSO TIME using CURDAT sort |
|
| Suchay Replies: 8 Views: 4598 |
Forum: Utilities Posted: Tue Oct 17, 2017 11:18 am Subject: How to get PST TSO TIME using CURDAT sort |
| We are coworkers | |
All times are GMT - 5 Hours |