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.
Search found 33 matches
- 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
- Sat Sep 21, 2013 4:12 pm
- Forum: Tip Of the Day.
- Topic: DB2 Tips.
- Replies: 23
- Views: 22246
Re: DB2 Tips.
7. On similar lines, one should avoid using all mathematics coded on columns in predicates.
For example:
Should be coded as:
For example:
Code: Select all
SELECT EMPNO, LASTNAME
FROM EMPLOYEE
WHERE SALARY * 2.5 > 50000.00
Code: Select all
SELECT EMPNO, LASTNAME
FROM EMPLOYEE
WHERE SALARY > 50000.00 / 2.5
- 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
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...
- Tue Aug 13, 2013 10:14 am
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: This is me!
- Replies: 2
- Views: 1481
Re: This is me!
Thanks for the welcome Anuj.
- Tue Aug 13, 2013 10:13 am
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Count to a Million!
- Replies: 234
- Views: 77300
- Mon Jul 15, 2013 11:12 pm
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: This is me!
- Replies: 2
- Views: 1481
This is me!
I'm working as a Software Developer in Mainframes for 2 years now. Hope to see myself a better contributor here...
- Mon Jul 15, 2013 11:10 pm
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: What's the oldest operating system you have currently active
- Replies: 24
- Views: 3457
- 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
Re: What is the best job you ever had?
This is indeed a tough question.
- Mon Jul 15, 2013 11:07 pm
- Forum: Suggestions & Feedback : About the website.
- Topic: love the the forum
- Replies: 13
- Views: 4296
Re: love the the forum
Layout is attractive and I see, Robert is quite helpful...
- Mon Jul 15, 2013 11:06 pm
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Torrent sites.
- Replies: 4
- Views: 4405
Re: Torrent sites.
Ditto!DB2 Guy wrote:kickass is mine
- Mon Jul 15, 2013 11:06 pm
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Count to a Million!
- Replies: 234
- Views: 77300
- 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
Re: Insert a child segment using File-Aid.
Thanks, this did the trick.
- 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
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...