A query in DB2 with "<>".

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
User avatar
rangab
Active Member
Posts: 56
Joined: Fri Mar 17, 2006 3:21 pm

A query in DB2 with "<>".

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.

User avatar
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

Post Reply

FREE TUTORIALS

Tutorials
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.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others