| Author |
Message |
Topic: Merging records from two datasets based Primary and secondar |
Suchay
Replies: 5
Views: 1286
|
Forum: Utilities Posted: Wed Nov 12, 2025 2:37 pm Subject: Merging records from two datasets based Primary and secondar |
| Thank you Kolusu |
Topic: Merging records from two datasets based Primary and secondar |
Suchay
Replies: 5
Views: 1286
|
Forum: Utilities Posted: Wed Nov 12, 2025 7:40 am Subject: Merging records from two datasets based Primary and secondar |
Input Datasets are 80 bytes
Output dataset is 88 bytes |
Topic: Merging records from two datasets based Primary and secondar |
Suchay
Replies: 5
Views: 1286
|
Forum: Utilities Posted: Tue Nov 11, 2025 3:10 pm Subject: Merging records from two datasets based Primary and secondar |
Hi Kolusu
My apologies
File1 Actno 1-5, Prev_actno 16-20, plan no 21-25, cntr_no 27-30
1234 copilot 2345 Plan1 Ctr1
4321 Chatgpt plan2 ctr2
3421 copilot1 3452 Plan3 Ctr3
File2 ... |
Topic: Merging records from two datasets based Primary and secondar |
Suchay
Replies: 5
Views: 1286
|
Forum: Utilities Posted: Tue Nov 11, 2025 10:51 am Subject: Merging records from two datasets based Primary and secondar |
Requirement is to match from file1 and file2
Matching criteria for File1 ... |
Topic: Help with INREC Overlapping Columns & SEQNUM for Groupin |
Suchay
Replies: 3
Views: 20517
|
Forum: 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: 20517
|
Forum: 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: 20517
|
Forum: 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: 109903
|
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: 109903
|
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: 18421
|
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: 7277
|
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: 8354
|
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: 8354
|
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: 4981
|
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: 4981
|
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 ... |
| |