Results 1 to 2 of 2

Thread: Db2 If Loop

  1. #1
    Join Date
    Sep 2007
    Posts
    56

    Unanswered: Db2 If Loop

    Hello,

    i would like to know if this is correct or wrong my if loop condition is as follows
    IF Student IS NULL AND is_error IS NULL THEN
    where Student and is_error is char(20) Data type. the above condition is not true or is it true.

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    "IF" checks for a condition - it is not a loop. Maybe you want to have a loop, look at the FOR, WHILE, and LOOP statements.

    Other than that, I don't understand your question. Syntactically, the condition is correct - you are only missing the code in the THEN branch and an END IF.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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