Search found 36 matches
- Tue Mar 24, 2026 1:20 pm
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: Question on MERGE in SORT.
- Replies: 4
- Views: 26324
Re: Question on MERGE in SORT.
I know this is old, though could you please guide.
- Tue Mar 24, 2026 12:56 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Modify only the specific ROWs in DB2 table.
- Replies: 2
- Views: 45394
Re: Modify only the specific ROWs in DB2 table.
Thanks. I used QMF to update the table. Thank you for your reply.
- Tue Mar 24, 2026 12:49 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: Claude and Mainframes
- Replies: 1
- Views: 11189
Claude and Mainframes
Hi,
There had been a lot of noise about Claude and it's possible threat to mainframe modernization. Is it really a threat to mainframes ecosystem?
There had been a lot of noise about Claude and it's possible threat to mainframe modernization. Is it really a threat to mainframes ecosystem?
- Mon Oct 07, 2024 12:30 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Modify only the specific ROWs in DB2 table.
- Replies: 2
- Views: 45394
Modify only the specific ROWs in DB2 table.
Hello,Keeping in mind that LOAD REPLACE overwrites the entire table, and LOAD RESUME appends the data. Keeping this in mind, consider the scenario:Imagine a table with 100 rows, and I need to update 30 of them. My approach:
Unload the entire table.
Remove the rows that don’t need to be updated ...
Unload the entire table.
Remove the rows that don’t need to be updated ...
- Tue Jul 02, 2024 12:53 pm
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: how many records we can filter out using joinkeys?
- Replies: 4
- Views: 13560
Re: how many records we can filter out using joinkeys?
We could process 5 million records without any error. Thanks everyone who helped.
- Mon Jun 03, 2024 1:54 pm
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: how many records we can filter out using joinkeys?
- Replies: 4
- Views: 13560
how many records we can filter out using joinkeys?
Hi,
Anyone know how many records we can filter out using joinkeys?
Anyone know how many records we can filter out using joinkeys?
- Mon Jun 03, 2024 10:36 am
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: converting mainframe input to json
- Replies: 2
- Views: 12447
Re: converting mainframe input to json
Thank you Anuj for the detailed explanation We're slowly working on it.
- Mon Jun 03, 2024 10:31 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: Question on MERGE in SORT.
- Replies: 4
- Views: 26324
Re: Question on MERGE in SORT.
Code: Select all
Sysin dd *
Merge fields=(1,10,CH,A,1,10,CH,A,1,10,CH,A)
Sum fields=None
/*Is there something wrong in this?
- Tue May 21, 2024 8:57 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: Question on MERGE in SORT.
- Replies: 4
- Views: 26324
Question on MERGE in SORT.
Hi All,
I have query I want to merge 3 files and remove the duplicate in Sort jcl . I am using merge fields with sum field but it's giving me syntax error. Am I doing right for this requirement?
[/color]
I have query I want to merge 3 files and remove the duplicate in Sort jcl . I am using merge fields with sum field but it's giving me syntax error. Am I doing right for this requirement?
Code: Select all
Merge fields=Sum fields=NONE- Mon May 20, 2024 5:29 pm
- Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
- Topic: how to copy matched records
- Replies: 2
- Views: 11332
Re: how to copy matched records
ramiroflores wrote: Mon May 20, 2024 3:33 pm how to copy matched records from two input files into 3rd output file using cobol program
You can also do that using SORT:
https://zmainframes.com/zlog/compare-tw ... -syncsort/
https://zmainframes.com/zlog/compare-tw ... me-dfsort/
https://zmainframes.com/zlog/compare-tw ... -syncsort/
https://zmainframes.com/zlog/compare-tw ... me-dfsort/
- Mon Oct 23, 2023 8:05 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: converting mainframe input to json
- Replies: 2
- Views: 12447
converting mainframe input to json
Hi,
Anyone worked on converting mainframe input to json to feed api .. please let me know . I need some input to resolve my issue
Anyone worked on converting mainframe input to json to feed api .. please let me know . I need some input to resolve my issue
- Mon Oct 23, 2023 8:04 pm
- Forum: Ask for Job Guidance and referrals here.
- Topic: That's how life is!
- Replies: 2
- Views: 12801
Re: That's how life is!
That's infy for you! 
- Tue Oct 27, 2020 12:59 pm
- Forum: JCL - Job Control Language.
- Topic: Removing SPACES from VB file.
- Replies: 1
- Views: 2016
Removing SPACES from VB file.
Hi,
I have a VB file as input. In this file I need to strip off the spaces at the end of each record. Is there a way to do it and can anyone please suggest how to do it? Thank you.
I have a VB file as input. In this file I need to strip off the spaces at the end of each record. Is there a way to do it and can anyone please suggest how to do it? Thank you.
- Fri Jan 20, 2017 6:36 pm
- Forum: CICS, Middleware and MQ Series.
- Topic: "RoR" in CICS?
- Replies: 4
- Views: 2776
Re: "RoR" in CICS?
Thanks Robert. You mentioned about DB2, so if DB2 is not there RoR is not required, is it?
Can you please direct me to a link where I can study about RoR more? Unfortunately I could not find a good document on it.
Can you please direct me to a link where I can study about RoR more? Unfortunately I could not find a good document on it.
- Wed Jan 18, 2017 1:41 pm
- Forum: CICS, Middleware and MQ Series.
- Topic: "RoR" in CICS?
- Replies: 4
- Views: 2776
"RoR" in CICS?
HI,
Is there something called as "RoR" in CICS? I could not find a reference about it in the google though one of the client, who is not directly connected to us, has used this in his conversation. I know, AoR, ToR and DoR but not RoR. If someone has some insight about it, please let me know.
Is there something called as "RoR" in CICS? I could not find a reference about it in the google though one of the client, who is not directly connected to us, has used this in his conversation. I know, AoR, ToR and DoR but not RoR. If someone has some insight about it, please let me know.
- Tue Mar 08, 2016 12:28 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Find view's definition in DB2.
- Replies: 4
- Views: 2771
Re: Find view's definition in DB2.
This SQL query has worked for me:
Code: Select all
SELECT * FROM SYSIBM.SYSVIEWS
WHERE NAME LIKE '%Z4_UID%'
AND CREATOR = 'CAPN'- Tue Mar 08, 2016 12:21 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Create hyperlink in mainframe.
- Replies: 5
- Views: 3541
Re: Create hyperlink in mainframe.
IBM supports HTTP Server on the system z, which allows Unix System Services files to be accessed as web pages from a browser. Hyperlinks and the usual HTML code are all supported. In z/OS 2.2, HTTP Server is no longer available as it is being replaced by Apache on the system z. At a previous ...
- Mon Mar 07, 2016 3:18 pm
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Mainframe quotes and humor .
- Replies: 22
- Views: 11872
Re: Mainframe quotes and jokes.
Today, your cell phone has more computer power than all of NASA back in 1969, when it placed two astronauts on the moon. Video games, which consume enormous amounts of computer power to simulate 3-D situations, use more computer power than mainframe computers of the previous decade. The Sony ...
- Fri Dec 18, 2015 4:57 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Create hyperlink in mainframe.
- Replies: 5
- Views: 3541
Re: Create hyperlink in mainframe.
I am not sure if I have all the answers in a very correct form with me but I'll answer you with as much as I know.
Is the web page on the mainframe as well?
No.
But how a web page can be on mainframes?
Is the mainframe exposed to the Internet or is this an intranet mainframe?
I did not ...
Is the web page on the mainframe as well?
No.
But how a web page can be on mainframes?
Is the mainframe exposed to the Internet or is this an intranet mainframe?
I did not ...
- Tue Dec 15, 2015 10:19 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Create hyperlink in mainframe.
- Replies: 5
- Views: 3541
Create hyperlink in mainframe.
Hi,
Can we create hyperlink in mainframe using COBOL or TSO? Is it possible and can we do it by any chance?
Can we create hyperlink in mainframe using COBOL or TSO? Is it possible and can we do it by any chance?