Search found 33 matches

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: 896
India

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: 22246
India

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: 7583
India

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: 1481
India

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: 77300
India

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: 1481
India

This is me!

I'm working as a Software Developer in Mainframes for 2 years now. Hope to see myself a better contributor here...:)
by LearnMainframe
Mon Jul 15, 2013 11:09 pm
Forum: Thought of the Day, General Talk & Jokes.
Topic: What is the best job you ever had?
Replies: 10
Views: 1958
India

Re: What is the best job you ever had?

This is indeed a tough question.
by LearnMainframe
Mon Jul 15, 2013 11:07 pm
Forum: Suggestions & Feedback : About the website.
Topic: love the the forum
Replies: 13
Views: 4296
India

Re: love the the forum

Layout is attractive and I see, Robert is quite helpful...
by LearnMainframe
Mon Jul 15, 2013 11:06 pm
Forum: Thought of the Day, General Talk & Jokes.
Topic: Torrent sites.
Replies: 4
Views: 4405
India

Re: Torrent sites.

DB2 Guy wrote:kickass is mine
Ditto!
by LearnMainframe
Mon Jul 15, 2013 11:06 pm
Forum: Thought of the Day, General Talk & Jokes.
Topic: Count to a Million!
Replies: 234
Views: 77300
India

Re: Count to a Million!

2

:D
by LearnMainframe
Mon Jul 15, 2013 11:00 pm
Forum: File-AID and IBM File Manager.
Topic: Insert a child segment using File-Aid.
Replies: 3
Views: 2103
India

Re: Insert a child segment using File-Aid.

Thanks, this did the trick.
by LearnMainframe
Fri Jul 05, 2013 7:05 pm
Forum: File-AID and IBM File Manager.
Topic: Insert a child segment using File-Aid.
Replies: 3
Views: 2103
India

Insert a child segment using File-Aid.

Hi, I need to insert a Child-Segment in IMS using Fileaid edit mode. Actually, there is no existing child segment for any of the parent segment in the database. Usually, we used to type RA(repeat all) in front of any parent segment and it will create a new parent and child segment. I tried to search...

Go to advanced search