Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2012
    Posts
    3

    Unanswered: What does this mean???

    I'm fairly new to DB2 and I was sent a criteria and I am not positive of what it mean. Would someone be able to tell me what the CODE in ('00', '80') means?

    NAME = ‘QTR’
    CODE in (‘00’. ‘80’)

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    This is basic SQL (not necessarily DB2). It means the expression is true if the value on the left is IN the list on the left.

    Andy

  3. #3
    Join Date
    Sep 2012
    Posts
    3
    So, basically it is saying. the expression is true if (Name is QTR and Code is '00') or (Name is QTR and Code is '80')?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If this is the whole expression:

    Code:
    NAME = ‘QTR’  AND
    CODE in (‘00’. ‘80’)
    Then your assessment is correct.

    Andy

  5. #5
    Join Date
    Sep 2012
    Posts
    3
    Ok.

    Thanks

Posting Permissions

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