Hi Bill,
It's hard to say without seeing the SQL you used to create the tables
and the SQL of the query which is failing. You may have another
capitalization problem here: column names obey the same casing rules as
table names.
Hope this helps,
-Rick
Wildman wrote:
After having fixed the table name capitalization problem, when I attempt to
execute the CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE call, I get this error:
java.sql.SQLException: The exception 'java.sql.SQLException: Column
'COLUMN2' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or
appears in a HAVING clause and is not in the GROUP BY list. If this is a
CREATE or ALTER TABLE statement then 'COLUMN2' is not a column in the
target table.' was thrown while evaluating an expression.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
This is quite a helpful error message, yes? Can anyone help in interpreting
it?
Thanks!
-Bill
