You can translate the question and the replies:


when i create a view through query with parameter it is giving error but that query is running in database and i think error :- "unknown column 'C001' in where clause" is Invalid . query :- (select * from department where deptno=@input) please tell me what is the problem Finished with error: Error executing query. Total time 0.123 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Unknown column 'C001' in 'where clause''
09-09-2016 08:27:47 -0400

1 Answer

Hi, When I execute queries that throw any error I always check the **execution trace** to see what query is executed at the source. That could help you to find out what is happening. Hope this helps!
Denodo Team
12-09-2016 06:22:28 -0400
You must sign in to add an answer. If you do not have an account, you can register here