Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    6

    Post Unanswered: How to use ISNULL in IF condition in DB2(URGENT)

    Hi,

    How to use ISNULL in IF condition in DB2?


    IF varActSetStartDate IS NULL AND varActSetEndDate IS NULL THEN
    SET varCanStartDate = '09/02/2010';
    SET varCanEndDate = '09/02/2010';
    END IF;

    is that above condition is correct? Please advice..

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It should work as written.

    Andy

Posting Permissions

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