Search found 36 matches

by LearnMainframe
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.
by LearnMainframe
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. 
by LearnMainframe
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? 
by LearnMainframe
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 ...
by LearnMainframe
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.
by LearnMainframe
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?
by LearnMainframe
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.
by LearnMainframe
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
/*
[/color]

Is there something wrong in this?
by LearnMainframe
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?

Code: Select all

Merge fields=Sum fields=NONE
[/color]
by LearnMainframe
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
 
 
by LearnMainframe
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
by LearnMainframe
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! :D
by LearnMainframe
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.
by LearnMainframe
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.
by LearnMainframe
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.
by LearnMainframe
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'
by LearnMainframe
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 ...
by LearnMainframe
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 ...
by LearnMainframe
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 ...
by LearnMainframe
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?

Go to advanced search