Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    16

    Unanswered: Urgent Help Required

    Hi,

    Can any one help me to how to write if then else in select..



    Thanks in advance.



    Pravas

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You probably want a CASE statement, unless you have a Stored Procedure, Trigger or UDF. Check out the SQL Reference Vol 1 for how a CASE statement works.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •