What does it mean: SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query

I tried to create exactly the same but new table from old table in another databas开发者_StackOverflow社区e using dblink. This procedure used to worked last two times, but this time I got message: "SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query."

Anyone knows where is the problem or how to solve it? Please!

I encountered this problem and fixed it by using single quotes, rather than double quotes, for the string I was searching for:

select * from table where column = 'value';

Here is a list of possible causes:

http://www.sqlerror.de/db2_sql_error_-206_sqlstate_42703.html

Best to catch the query before it is executed, then you will be able to see what exactly the problem is. If you post it here, we can help you further.