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

Question

I tried to create exactly the same but new table from old table in another database 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!

Answer 1

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.