Search found 26 matches

by LearnMainframe
Mon Oct 23, 2023 8:05 pm
Forum: Other Mainframe Topics, Off-Topics, FAQs.
Topic: converting mainframe input to json
Replies: 1
Views: 1445

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: 762

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: 1026

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: 1106

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: 1106

"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 kn...
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: 758

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: 1076

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

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

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

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?
by LearnMainframe
Tue Dec 15, 2015 10:15 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Need help on SQLCODE= -805.
Replies: 4
Views: 895

Re: Need help on SQLCODE= -805.

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,...
by LearnMainframe
Thu Dec 10, 2015 2:30 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Need help on SQLCODE= -805.
Replies: 4
Views: 895

Need help on SQLCODE= -805.

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.
by LearnMainframe
Thu Dec 10, 2015 2:24 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Find view's definition in DB2.
Replies: 4
Views: 758

Re: Find view's definition in DB2.

I need to know the DDL for the view and the description of the columns used in the view definition.
by LearnMainframe
Fri Dec 04, 2015 12:01 am
Forum: IBM DB2 and IMS DB/DC
Topic: Find view's definition in DB2.
Replies: 4
Views: 758

Find view's definition in DB2.

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.
by LearnMainframe
Sat Sep 21, 2013 4:12 pm
Forum: Tip Of the Day.
Topic: DB2 Tips.
Replies: 23
Views: 21638

Re: DB2 Tips.

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

For example:

Code: Select all

SELECT EMPNO, LASTNAME 
FROM EMPLOYEE 
WHERE SALARY * 2.5 > 50000.00 
Should be coded as:

Code: Select all

SELECT EMPNO, LASTNAME 
FROM EMPLOYEE 
WHERE SALARY > 50000.00 / 2.5
by LearnMainframe
Tue Aug 13, 2013 10:44 am
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: How to backup/restore a VSAM file?
Replies: 6
Views: 6909

Re: How to backup\restore a VSAM file?

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...
by LearnMainframe
Tue Aug 13, 2013 10:14 am
Forum: Introduce Yourself and Share Your IT Experience.
Topic: This is me!
Replies: 2
Views: 1408

Re: This is me!

Thanks for the welcome Anuj. :)
by LearnMainframe
Tue Aug 13, 2013 10:13 am
Forum: Thought of the Day, General Talk & Jokes.
Topic: Count to a Million!
Replies: 234
Views: 74062

Re: Count to a Million!

25
by LearnMainframe
Mon Jul 15, 2013 11:12 pm
Forum: Introduce Yourself and Share Your IT Experience.
Topic: This is me!
Replies: 2
Views: 1408

This is me!

I'm working as a Software Developer in Mainframes for 2 years now. Hope to see myself a better contributor here...:)

Go to advanced search