Usage of CASE in SQL QUERY

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
technokrat
Member
Posts: 6
Joined: Wed Jun 17, 2009 11:56 am
Location: Bangalore

Usage of CASE in SQL QUERY

Post by technokrat » Fri Jun 19, 2009 12:35 pm

can anyone suggest me the usage of CASE statement in an sql query????


Thanks in advance..... :)

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Fri Jun 19, 2009 12:39 pm

depends on if you are referring to a CASE Expression or a CASE Statement
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

technokrat
Member
Posts: 6
Joined: Wed Jun 17, 2009 11:56 am
Location: Bangalore

Post by technokrat » Fri Jun 19, 2009 1:31 pm

Thanks for help :)

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