7 Replies Latest reply: Nov 28, 2016 3:07 PM by Anand Chouhan RSS

    How to use where match statement in load

    jacob meredith

      SQL SELECT "QUESTION_ANSWER_ID",
      MSID,
      "QUESTION_ID",
      ANSWER
      FROM IQREVDB.TBQUESTIONANSWERS

      Where
      "QUESTION__ID" = 358 or
      "QUESTION__ID" = 72 or
      "QUESTION__ID" = 73 or
      "QUESTION__ID" = 75 or
      "QUESTION__ID" = 76 or
      "QUESTION__ID" = 78 or
      "QUESTION__ID" = 79 or
      "QUESTION__ID" = 95 or
      "QUESTION__ID" = 96 or
      "QUESTION__ID" = 97 or
      "QUESTION__ID" = 98 or
      "QUESTION__ID" = 99 or
      "QUESTION__ID" = 100 or
      "QUESTION__ID" = 101 or
      "QUESTION__ID" = 102 or
      "QUESTION__ID" = 103 or
      "QUESTION__ID" = 104 or
      "QUESTION__ID" = 105 or
      "QUESTION__ID" = 106 or
      "QUESTION__ID" = 107 or
      "QUESTION__ID" = 108 or
      "QUESTION__ID" = 109 or
      "QUESTION__ID" = 110 or
      "QUESTION__ID" = 140 or
      "QUESTION__ID" = 141 or
      "QUESTION__ID" = 142 or
      "QUESTION__ID" = 158 or
      "QUESTION__ID" = 161 or
      "QUESTION__ID" = 162 or
      "QUESTION__ID" = 163 or
      "QUESTION__ID" = 164 or
      "QUESTION__ID" = 166 or
      "QUESTION__ID" = 199 or
      "QUESTION__ID" = 200 or
      "QUESTION__ID" = 221 or
      "QUESTION__ID" = 237 or
      "QUESTION__ID" = 239 or
      "QUESTION__ID" = 240 or
      "QUESTION__ID" = 241 or
      "QUESTION__ID" = 242 or
      "QUESTION__ID" = 243 or
      "QUESTION__ID" = 244 or
      "QUESTION__ID" = 249 or
      "QUESTION__ID" = 298 or
      "QUESTION__ID" = 318 or
      "QUESTION__ID" = 319;

       

      Can someone edit my script so that I don't receive the error "invalid identifier"? I am trying to load lines from the field "QUESTION_ID" that correspond to a list like: 75,76,77,78,79,etc.

       

      Thanks