In JDBC Query Consumer, in Incremental mode, this error indicates that the specified column name must be included in the WHERE clause and it must also be included in the ORDER BY clause. In the ORDER BY clause it should be the first column specified, so that it is the column that sets the order for the returned rows.
JDBC_29 - Query must include (column) in WHERE clause and in ORDER BY clause before other columns.
Userlevel 1
Be the first to reply!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.