Mainframe, MVS and zOS Discussion

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]

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

 

Hi,

Anyone worked on converting mainframe input to json to feed api .. please let me know . I need some input to resolve my issue

That's infy for you!

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.

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.

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 kn...

This SQL query has worked for me:

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 compan...

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 PlaySta...

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 understand yo...

Hi,

Can we create hyperlink in mainframe using COBOL or TSO? Is it possible and can we do it by any chance?

You get SQLCODE=-805 when the package corresponding to an SQL statement execution request was not found. When you compile and bind a program, you get the following: the load module and the other is the DB2 package. DBRMLIB, but for this discussion this is not relevant. Now when you run the program,...

Hi,

Can anyone of you please explain about SQLCODE=-805. I made a search in the forum but I did not get a proper answer. Please help.

I need to know the DDL for the view and the description of the columns used in the view definition.

Hi,

Does someone know of a possible way to find the definition of a view? I did check in the sysibm.sysviews table and there I was not able to get a meaningful definition.

7. On similar lines, one should avoid using all mathematics coded on columns in predicates.

For example: Should be coded as:

For first JCL you ask for try this, but have you made some JCL yourself too? //STEP01 EXEC PGM=IEFBR14 //SYSUT1 DD DSN=USER.TEST.VSAM.BKUP, // DISP=(MOD,CATLG,DELETE), // UNIT=SYSDA,RECFM=FB,LRECL=80, // SPACE=(CYL,(1,1),RLSE) //* //STEP02 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //DD1 DD DSN=USER.TES...

Thanks for the welcome Anuj.

25