title: Why does Bluemix dashDB operation throws a SqlSyntaxErrorException with SQLCODE=-1667?
body: <p>I'm getting this error even though I am not trying to edit the table/column:</p>
  
  <blockquote>
    <p>com.ibm.db2.jcc.am.SqlSyntaxErrorException: The operation failed because the operation is not supported with the type of the specified table.  Specified table: "DASH103985.wajihs".  Table type: "ORGANIZE BY COLUMN".  Operation: "WITH RS".. SQLCODE=-1667, SQLSTATE=42858</p>
  </blockquote>
  
  <pre><code>@MultipartConfig
  public class DemoServlet extends HttpServlet {
    private static Logger logger = Logger.getLogger(DemoServlet.class.getName());
    private static final long serialVersionUID = 1L;
    @Resource(lookup="jdbc/db2")DataSource dataSource;
  
  private String getDefaultText() {
    TweetsCombined = new String(" ");
    try {
      // Connect to the Database
      Connection con = null;
      try {
        System.out.println("Connecting to the database");
      } catch (SQLException e) {
        TweetsCombined = "first" +e;
      }
  
      // Try out some dynamic SQL Statements
      Statement stmt = null;
  
    try {
      stmt = con.createStatement();
      String tableName = "wajihs";// change table name here to one
                    // chosen in the first website
      String columnName = "msgBody";// msgBody is where the tweets
                                            // are stored
      String query = "SELECT * FROM \"" + tableName + "\"";
      ResultSet rs = stmt.executeQuery(query);
  
      while (rs.next()) {
        content = rs.getString(columnName) + ". ";
        if (content.toLowerCase().contains("RT".toLowerCase())
                || content.toLowerCase().contains("Repost: ".toLowerCase())) {
          // do nothing
        }
        else {
          TweetsCombined.concat(content);
        }
  
      }
      // Close everything off
      // Close the Statement
      stmt.close();
      // close
      con.commit();
      // Close the connection
      con.close();
    } catch (Exception e) {
      TweetsCombined = "second" +e;
      System.out.println(e.getMessage());
    }
  } catch (Exception e) {
    TweetsCombined = "third" + e;
    System.out.println(e);
  }
  return TweetsCombined;
  </code></pre>
  
  <p>}</p>