Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.
Moderators: Kalicharan, Moderator Group
-
rangab
- Active Member
- Posts: 56
- Joined: Fri Mar 17, 2006 3:21 pm
Post
by rangab » Fri Mar 02, 2007 6:15 pm
Hi,
I would like to execute the below shown query on a DB2 table using SPUFI.
I am not able to understand how does this perform. Would you please explain in detail?
SELECT ORD_NBR,EVN_CD
FROM XXXXXX1.XXX_EVN_IST
WHERE EVN_CD <> '67XX'
WITH UR;
TIA.
========
Ranga...:-0)
========
Learn Which You Don't Know - Teach Others Which They Don't Know.
-
Sheela
- Member
- Posts: 14
- Joined: Mon Feb 26, 2007 8:17 am
- Location: Chennai
Post
by Sheela » Fri Mar 02, 2007 11:53 pm
Hi Rangab,
Do you want us to explain the query. or you are talking about
performance tuning.
About query, it will display all records where EVN_CD not equals to
67XX.
Regards,
Sheela
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts.
- Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3.
- DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming.
- SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples
- CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions
Mainframe Tools and others